MICROSOFT DATA ARCHITECT

We are Dufrain, a pure-play data consultancy specialising in helping businesses unlock the true value of their data by providing market-leading data solutions and services which includes developing strategies for AI readiness, improving data literacy and enhancing real-time reporting.

At Dufrain we prides ourselves on a creative and innovative approach, focusing on delivering exceptional outcomes for clients by leveraging data to drive growth and efficiency.

Our mission is to inspire, shape and deliver the data capabilities of tomorrow.

We have a great opportunity for an Microsoft Architect Specialist to play a pivotal role in helping clients navigate the complexities of data architecture and strategy. Providing early engagement with clients to develop and understand business needs and proposing suitable architectural solutions.

MAIN PURPOSE OF THE ROLE:

Our Data Architects provide expertise, guidance, and strategic advice to clients to help them effectively develop their data assets for making informed decisions and achieving their business objectives.

RESPONSIBILITIES

• Implementing industry-standard Fabric solutions including both Fabric Lakehouse and Warehouse solutions.
• Presenting and explaining architectural decisions to different level stakeholders.
• Support clients across a range of sectors.
• Debugging and optimization of existing solutions.
• Resource consumption and cost optimization.
• Develop understanding of governing enterprise-level data environments.
• Testing and documentation.

EXPERIENCE

To be a suitable candidate for this Data Architect role you will have the experience to:

• Demonstrate deep expertise in enterprise-level data analytics solutions end-to-end using Fabric, with a focus on Lakehouse Architecture and ML/AI-driven analytics.
• Apply domain knowledge to recommend best practices and innovative architectures for modern data platforms.
• Develop good working relationships with clients on a project. This includes presenting deliverables and proof of concept demonstrations with confidence.
• Inform a client's data strategy, encourage adoption of best practices. Our architects must have the ability to challenge clients and colleagues around delivery approach or content of deliverables.
• Gather requirements from stakeholders with a range of technical backgrounds.
• Have accountability for the delivery of solutions that delight our clients.
• Deliver to agreed plans and timelines, ensuring high standards of architecture, performance, and security.
• Contribute to the Architecture Practise to develop standard architecture patterns and resources.

TECHNICAL SKILLS

• Consulting / Professional Services experience.
• Proficient with data modelling 3NF/Kimball.
• Excellent understanding and experience of implementing Modern Data Warehouse architectures.
• Experience with back-end Azure Data Engineer technologies like ADF, Azure SQL Database and Synapse.
• Proficient in designing, implementing, and maintaining solutions using Microsoft Fabric.
• Python data engineering experience.
• Strong understanding of SQL and NoSQL databases, SQL, CosmosDB and Kusto Query Language (KQL).
• Solid experience of data pipeline development using both cloud and on-premises data sources.
• Excellent problem-solving, analytical, and communication skills.
• Strong desire to learn and adapt to new technologies.

Desirable experience:

• Data governance principles including Microsoft Purview
• Azure Infrastructure and Networking experience
• Databricks experience.
• Machine Learning and AI
• DevOps experience
• Power BI semantic modelling

Nice to have certifications

• Microsoft Certified: Fabric Analytics Engineer Associate
• DP-203 Azure Data Engineering
• AZ-305 Azure Solutions Architect

What to do next

If you’re passionate about data, and you’re looking to join a leading data and analytics company based in the UK, you could find your dream role at Dufrain.

Please submit your CV highlighting your relevant experience and certifications. Applicants must have the right to work in the UK and not require sponsorship now or in the future. Visa sponsorship is not available .

We are an equal opportunity employer and value diversity at our company. . We do not discriminate on the basis of race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, age, or any other status protected by law. All qualified applicants will receive consideration for employment without regard to these factors. We encourage applications from individuals of all backgrounds and experiences.