Senior Data Engineer

Cognitive Group | Part of the Focus Cloud Group; United States; Remote; GBP 70,000 - 100,000; Full time

Benefits offered by this job

Bonuses

Medical coverage

Pension

Income protection

Family leave enhancements

Recognition programs

EAP 24/7

Online marketplaces access

Job summary

Cognitive Group | Part of the Focus Cloud Group is seeking a Data Engineer/Data Architect with consultancy experience to design and optimize cloud-based data pipelines using Azure Synapse, Azure Data Factory, Databricks, and Microsoft Fabric. You will work directly with clients and cross-functional teams to deliver scalable data solutions supporting AI, ML, and analytics initiatives.

Strong Python scripting, Kimball modeling, and Power BI skills are essential in a dynamic cloud-focused

Qualifications

• Experience in data engineering or data architecture within client-facing environments.
• Hands-on with Azure Synapse, Data Factory, or Databricks.
• Hands-on exposure to Microsoft Fabric and its AI features.
• Proficient in Python for data pipelines and analytics tasks.
• Knowledge of Kimball data modeling principles.

Responsibilities

• Design, build, and optimize scalable data pipelines and models.
• Ingest and transform large datasets ensuring data quality and availability.
• Develop Python scripts for data engineering tasks.
• Collaborate with data scientists and stakeholders on ML and analytics.
• Evaluate new cloud data technologies, focusing on Fabric features.
• Apply Kimball data modeling to analytics solutions.
• Communicate solutions clearly to non-technical stakeholders.
• Promote knowledge sharing and continuous learning.

Skills

Data engineering

Data architecture

Python scripting

Kimball modeling

Consulting experience

Power BI

Tools

Azure Synapse Analytics

Azure Data Factory

Databricks

Microsoft Fabric

Power BI

Job description

No visa sponsorship is possible for this role

About the Company

A leading technology consultancy recognized for excellence in cloud data solutions and AI-driven business transformation. The organization is ranked among the top global partners for Microsoft, with a focus on delivering innovative, scalable, and impactful data and analytics projects for diverse clients across industries.

About the Role

We are seeking a Data Engineer or Data Architect with hands-on consultancy experience and proven familiarity with Microsoft Fabric’s AI and analytics capabilities. The successful candidate will design, develop, and optimize scalable data pipelines and models to support AI, machine learning, and advanced analytics initiatives. They will collaborate directly with clients and cross-functional teams to create cloud-based data solutions that enable strategic insights and operational efficiencies. A strong understanding of the Fabric ecosystem, including its latest AI integrations, is highly desirable.

Key Responsibilities

• Design, build, and enhance high-performance data pipelines and workflows using Azure Synapse, Azure Data Factory, Databricks, and Microsoft Fabric.
• Ingest, store, and transform large datasets, ensuring high data quality, consistency, and availability across client environments.
• Develop clean, efficient Python scripts for data engineering and advanced analytics tasks.
• Collaborate with data scientists and stakeholders to support machine learning, data modeling, and predictive analytics initiatives.
• Explore, evaluate, and implement new cloud data technologies, emphasizing latest Fabric features and AI capabilities.
• Apply data modeling best practices, including Kimball methodology, to create scalable analytics solutions.
• Communicate technical solutions clearly to non-technical stakeholders and team members.
• Promote knowledge sharing, innovation, and continuous learning within teams.

Essential Experience & Skills

• Proven consulting experience in data engineering, data architecture, or BI roles within client or enterprise environments.
• Practical experience with Azure Synapse Analytics, Azure Data Factory, or Databricks.
• Hands-on exposure to Microsoft Fabric, with enthusiasm for learning its evolving AI and data management features.
• Proficiency in Python programming, especially in data pipeline scripting and manipulation.
• Strong understanding of data modeling frameworks such as Kimball methodology.
• Ability to deliver scalable, high-quality data solutions in complex or client-facing projects.
• Strong problem-solving, analytical, and communication skills.
• Flexibility to adapt to rapidly evolving cloud data ecosystems and AI features.
• Certifications in Fabric or related Azure data and analytics modules (e.g., DP-600).
• Experience with Fabric’s AI, Machine Learning, and Natural Language Processing features.
• Development experience with Power BI dashboards and reports.
• Knowledge of additional Azure data services such as Data Lake or SQL Server.
• Familiarity with other Azure AI tools and cloud data platforms.

Technologies / Tools / Methodologies

• Microsoft Fabric (including AI and analytics modules)
• Power BI
• Python for data pipeline scripting and automation
• Kimball data modeling methodology
• Agile and DevOps methodologies

Candidate Profile

The ideal candidate will come from a consultancy background, with practical experience in data engineering, BI, or data architecture. They will have demonstrated expertise in Azure data platforms and ideally have exposure to Fabric’s AI and analytics modules. Candidates familiar with delivering complex data projects leveraging modern Fabric components, including AI features, will be preferred. They should be comfortable managing stakeholder expectations, working collaboratively across teams, and driving innovative cloud data solutions.

Dealbreakers / Non-Negotiables

• Proven experience with Azure Synapse, Data Factory, and Databricks in a consultancy or enterprise environment
• Practical experience with Fabric and its AI modules
• Demonstrable experience designing scalable, high-quality data pipelines
• Consultancy experience working directly with clients or in stakeholder-facing roles

Location & Working Pattern

Remote working is supported, with optional access to a central office.

Salary & Benefits

Competitive package including bonuses, medical coverage, pension, income protection, family leave enhancements, recognition programs, 24/7 Employee Assistance Program, and access to online marketplaces