Data Engineer

Job Title: Lead Data Engineer
Role Type: Permanent
Location: Birmingham (Hybrid)

Role Overview

As the Data Engineer, you will be responsible for managing a team of data engineers, analysts and leveraging your expertise in Microsoft BI tools and cloud-based technologies to drive their data initiatives. You will play a critical role in guiding the team, developing curated business models, and utilizing Azure services to optimize our data infrastructure.

Key Responsibilities

• Provide leadership, guidance, and support to team members, ensuring the successful execution of projects and tasks.
• Mentor and support the wider business, including Business Intelligence teams, to leverage data for decision-making using PowerBI and other Microsoft tools.
• Collaborate with cross-functional teams to achieve common business goals.
• Develop and maintain curated business models to support accurate and insightful decision-making.
• Utilize SSRS, SSAS, and SSIS to design, develop, and implement robust reporting and analytics solutions.
• Conduct complex data analysis to identify trends, patterns, and insights that drive business improvement.
• Demonstrate expertise in Azure Synapse and Azure Data Factory/Lakes for data integration, orchestration and management.
• Implement and optimize data pipelines for seamless and efficient data flow within the Azure ecosystem.
• Extract data from Dynamics to build and enhance curated business models in Synapse/PowerBI.
• Ensure data security, compliance, and best practices are followed in Azure cloud environments.
• Build migration paths to transition from on-premises technologies to the cloud where appropriate.

• Proven experience as a Data Engineer and experience in a team leadership role.
• Expertise in the Microsoft BI stack, including SSRS, SSAS, and SSIS.
• Hands-on experience with Azure Synapse, Azure Data Factory, and other Azure cloud services.
• Strong analytical and problem-solving skills, with the ability to turn complex data into actionable insights.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with diverse teams.
• Demonstrated ability to design and implement curated business models for reporting and analysis.