Data Architect - ELT / ETL - SQL Azure

Data Architect - ELT / ETL - SQL Azure, Synapse Analytics (Dataflows, Juypter, on-demand SQL), Databricks, and ADF Power BI

Location: UK, West Midlands HQ / UK Wide Work From Home Options - Remote First!

Salary: Highly Competitive + Excellent Benefits Package - Remote Working & Work From Home

This client is a key Microsoft player and a specialist in the cloud, experiencing fantastic global growth over the past 5 years. They are seeking someone with a Data Consultancy Background, who is experienced in managing clients and cementing long-term client relationships.

You will be an experienced Data Architect and a "Master Data Manipulator" with Python / SQL / Data Pipelines. You will be a Technical Specialist capable of managing customer requirements for data-centric projects, designing integration solutions, data modeling, and hands-on implementation of data and management information-based technologies.

Your key experience will revolve around SQL Azure, Synapse Analytics (Dataflows, Juypter notebooks, on-demand SQL), Databricks, ADF Power BI, DAX, Azure, SQL, Python, ETL, and SSIS.

You will be a self-starter, technically confident, and able to land on a project and instantly add value. A quantitative mindset and proven experience working in a data architecture role in an Azure ecosystem are essential, with preference given to those with hands-on skills.

Required Experience:

• Able to manage work and juggle priorities on multiple projects and workstreams
• Working in an agile landscape to make technical decisions/recommendations amidst uncertainty
• Stakeholder management and technical team interaction (internal, external, and 3rd party)
• Requirements gathering (ETL, BI)
• Identifying needs through workshops
• Refining solutions to an Engineer-friendly technical approach
• Documentation of designs using industry-recognized formats such as ER, UML, ArchiMate, or Erwin
• Data migration experience into SaaS CRM solutions
• Large scale Data Lakehouse/Data Warehouse design
• Conceptual, Logical, and Physical Architecture
• ETL/ELT best practices for monitoring and error-handling
• Understanding of Kimball data-modeling techniques
• Hands-on experience with Data Engineers to enhance solutions for customer-readiness
• Experience with SQL Azure, Synapse Analytics (dataflows, Juypter notebooks, on-demand SQL), Databricks, ADF
• Proficiency in Power BI, DAX, and data flows
• Experience with SSIS
• Appreciation of information security standards such as ISO27001, PCI-DSS, or Cyber Essentials
• BPSS clearance required on start
• Security and DBS Vetting will be necessary upon job offer presentation

Desirable Experience:

• Public Sector experience (Government, Education, Local Councils, MoJ, MoD, Transport)
• Azure Data Certifications (DP-203, DP-600)
• Experience with Data Governance tools (i.e., Microsoft Purview)
• Community engagement and amplification of best practices at organizational & industry levels
• Integration with D365 and Dataverse solutions
• Knowledge of Azure storage technologies and cost/performance characteristics
• Techniques and tools for sanitizing data prior to use
• Experience with Master Data solutions
• Proficiency in 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!