Principal Data Solution Architect (SFIA Level 6+). - WFH

Principal Data Solution Architect (SFIA Level 6+)

Remote First! Home Based / Work From Home - Occasional Visits to West Midlands HQ and Client Sites

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

ELT / ETL - SQL Azure, DevOps, Databricks Synapse Analytics SQL Azure, (Dataflows, Juypter Notebooks, Databricks, ADF Power BI, DAX, Azure, SQL, Python, ETL, SSIS is far more important (on-demand SQL), Databricks, and ADF Power BI, ER, UML, Archimate, Erwin, TOGAF, Microsoft Cloud Adoption Framework and Well Architected Framework, Data Lakehouse designConceptual Architecture, Logical Architecture and Physical Architecture.

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 Solution Architect and Consultancy Background, for their Principal Data Solution Architect (SFIA Level 6+) vacancy i.e. someone who has a solid Solutions Architectural portfolio who has experience managing clients, client engagement and cementing client relationships long term.

You will be an experienced Principal Data Solution Architect (SFIA Level 6+): 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.

The client are seeking a Technical Lead to join their Data practice and you will need a Data Consultancy / Azure background and be experienced in Leading Client Projects. This Primarily a Technical Role, and it is essential that you are able to coexist with colleagues and stakeholders within this dynamic, fast paced environment. You will be a self-starter, technically confident, and be able to land on a project and instantly add value. You will be keen to stay updated in the latest technologies, with a broad interest in all things Data.

You will have a quantitative mindset, and proven experience working in a Data Solutions Architecture role within an Azure ecosystem. Azure Modern Data Platform experience is essential, with hands-on skills. You will understand Networks, Security and Performance v Cost characteristics of your solutions and be able to configure these including through Infrastructure-as-Code.

Leveraging your hands-on experience of all things Data, you will be leading on Quoting, Design, Assurance and Oversight of Delivery of on-premises to Cloud Data Platform Migrations and Implementations.

Comfortable being hands-on, you will be a master data manipulator with Python/SQL/ADF and a technical specialist capable of managing customer requirements for data-centric projects, designing integration solutions 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:

• Requirements gathering - ETL, ELT and BI, Identifying through workshops, Elaborate user stories and refining to an Engineer-friendly technical approach, Documentation of designs with an industry-recognised form such as ER, UML, Archimate, Erwin, TOGAF
• Experience of managing priorities on multiple projects / 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)
• Large scale Data Lakehouse design, Conceptual Architecture, Logical Architecture and Physical Architecture
• ETL/ELT best practise approaches to monitoring and error-handling
• 10+ years' experience of Consulting, ideally with Nonprofit, Government, Public Sector or Financial Services experience
• 7+ years' experience of hands-on skills with ETL/ELT tools
• End-to-end migration of on-prem SQL-Server based solutions into Azure
• Working knowledge of Microsoft Cloud Adoption Framework and Well Architected Framework
• Integration to D365, Dataverse solutions or other SaaS applications
• Creation of fault-tolerant data ingestion pipelines in Azure Data Factory / Synapse Pipelines / Fabric Pipelines / Mapping Data Flows / SSIS/ KingswaySoft using Linked Services, Integration, Datasets
• Extracting data from a variety of sources including SQL Databases and Document Databases,
• Graph Databases, web APIs, etc, Microsoft Fabric exposure
• Data Governance tools (e.g. Microsoft Purview), Master Data Management tools (e.g. CluedIn)
• Appreciation of information security standards such as ISO27001, PCI-DSS, Cyber Essentials
• Azure Infrastructure and Networking, Azure DevOps, Git, ARM/Bicep, and building CI/CD pipeline