Data Architect - ELT / ETL - SQL Azure

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 (phone number removed) for more information!