Senior Data Engineer

About the position

The Senior Data Engineer will be able to design, build, and maintain scalable data pipelines and models that power analytics and business intelligence across the organization. This role will play a crucial part in optimizing data architecture, integrating multiple data sources, and ensuring the reliability of data processing workflows. The ideal candidate will work closely with cross-functional teams to deliver high-quality, actionable insights through modern data engineering best practices. Additionally, this role will support business intelligence initiatives by ensuring that data is structured, accessible, and optimized for reporting and decision-making.

Responsibilities

• Develop and maintain efficient, scalable data pipelines for ingestion, transformation, and integration.
• Design and manage dimensional data models (star/snowflake) within a medallion architecture to support business reporting and analytics.
• Partner with Enterprise Data teams and business analysts to translate data requirements into practical solutions.
• Coach users in the business on how to connect to, consume, and translate data.
• Ensure data structures and models support business intelligence tools and reporting needs, enabling data-driven decision-making across the organization.
• Automate workflows and data integration processes using Azure Data Factory, Microsoft Fabric, Logic Apps, APIs, and other relevant tools.
• Continuously monitor and enhance data pipeline performance to ensure scalability, reliability, and efficiency.
• Work with teams across the business to ensure high-quality, consistent data is accessible throughout all systems.
• Lead initiatives to centralize data from multiple systems into a single master dimensional model.

Requirements

• Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field (or equivalent experience).
• 7+ years of experience in data engineering, data integration, or a similar role.
• Proficiency in SQL for data extraction, transformation, and management.
• Strong programming skills in languages such as Python, Scala, or Java for building data pipelines.
• Hands-on experience with Microsoft Azure and Microsoft Fabric for data engineering tasks (DP-600 or 700 certification is a plus).
• Experience designing and implementing dimensional data models using a medallion architecture.
• Expertise in managing dataflows and pipelines with automation tools.
• Proficiency in creating and consuming APIs for data integration.
• Strong workflow and business process improvement skills, particularly in data migration and system integration.
• Experience supporting business intelligence and analytics teams by optimizing data for reporting and visualization tools.
• Experience working in cloud-based data environments, particularly within the Microsoft ecosystem.
• Familiarity with real-time and batch data processing frameworks.
• Strong problem-solving skills with a data-driven mindset.