Data Architect - ELT / ETL - SQL Azure
| Posting date: | 16 December 2024 |
|---|---|
| Salary: | £80,000 to £96,000 per year |
| Additional salary information: | Excellent Bens |
| Hours: | Full time |
| Closing date: | 23 December 2024 |
| Location: | UK Midlands, Warwickshire, B91 3DG |
| Company: | Experis |
| Job type: | Permanent |
| Job reference: | BBBH390148_1734351053 |
Summary
Data Architect - ELT / ETL - SQL Azure, Synapse Analytics (Dataflows, Juypter, on-demand SQL), Databricks, and ADF Power BI
UK, West Midlands HQ / UK Wide Work From Home Options - Remote First!
SQL Azure, Synapse Analytics (Dataflows, Juypter notebooks, on-demand SQL), Databricks, ADF Power BI, DAX, Azure, SQL, Python, ETL / ELT, SSIS, , ArchiMate or Erwin, Data migration experience into SaaS CRM solutions, Large scale Data Lakehouse/Data Warehouse Design.
Salary: Is Open & Highly Competitive + An Excellent Benefits Package - Remote Working & Work From Home
This client are a key Microsoft Player and a Specialist of the Cloud Ideal experiencing fantastic global growth over the past 5 years, all whilst their competition have weakened, and are therefore seeking someone with a Data Consultancy Background, who is used to managing clients, client engagement and cementing client relationships long term.
You will be an experienced Data Architect: And a "Master Data Manipulator" with Python / SQL / Data Pipelines and a Technical Specialist capable of managing customer requirements for data-centric projects, designing integration solutions, data modelling, and hands-on implementation of data and management information-based technologies.
This client always consider all architectural backgrounds, however, your key experience here will evolve around SQL Azure, Synapse Analytics (Dataflows, Juypter notebooks, on-demand SQL), Databricks, ADF Power BI, DAX, Azure, SQL, Python, ETL, SSIS is far more important.
You will be a self-starter, technically confident, be able to land on a project and instantly add value.
With a quantitative mindset, and proven experience working in a data architecture role in an Azure ecosystem. Azure modern data platform experience is essential, those with hands-on skills given preference.
Required Experience:
- Able to manage work on juggle priorities on multiple Projects and Workstreams
- Working in an agile landscape to making technical decisions/recommendations where there is uncertainty
- Stakeholder management and technical team interaction (internal, external and 3rd party)
- Requirements gathering (ETL, BI)
- Identifying through workshops
- Be the key actor in and refining solutions to an Engineer-friendly technical approach
- Documentation of designs with an industry-recognised form such as ER, UML, ArchiMate or Erwin
- Data migration experience into SaaS CRM solutions
- Large scale Data Lakehouse/Data Warehouse design
- Conceptual architecture
- Logical Architecture and Physical Architecture
- ETL/ELT best practise approaches to monitoring and error-handling
- Understanding of Kimball data-modelling techniques
- Hands-on experience and being able to get involved when required with Data Engineers to enhance solutions for customer-readiness with these technologies
- SQL Azure, Synapse Analytics (dataflows, Juypter notebooks, on-demand SQL), Databricks, ADF
- Power BI, DAX, data flows
- SSIS
- Appreciation of information security standards such as ISO27001, PCI-DSS or Cyber Essentials
- BPSS clearance will be required on start
- Security and DBS Vetting will be necessary on presentation of a Job Offer
Desirable experience:
- Public Sector (Government, Education, Local Councils, MoJ, MoD and Transport) experience.
- Azure Data Certifications (DP-203, DP-600)
- Data Governance tools (i.e. Microsoft Purview)
- Community engagement and amplification of best practise at organisation & industry level
- Integration to D365 and Dataverse solutions
- Azure storage technologies and cost/performance characteristics
- Techniques and tools for sanitizing data prior to use
- Master Data solutions
- Python and Data Science
- Real Flexibility - Remote First
- Interesting Work - The chance to work with household names
- Great recognition and growth opportunities
- Other great benefits including private healthcare, pension scheme and more
Call Experis IT today on 0121 712 8715 for more information!