Senior Data Engineer

Job Description

Senior Data Engineer Overview

\n

\n
• The Senior Data Engineer will lead the development and optimization of data engineering processes using Microsoft Fabric and SQL Server technologies.

\n

• Collaborate with cross-functional teams to ensure data integrity and reliability for critical business processes.

\n

• Contribute to the migration of legacy systems to modern cloud-based data platforms.

\n

• Design and implement data warehouse architectures using medallion layering for enhanced data accessibility.

\n

• Develop Power BI semantic models with robust data entitlement rules for secure reporting.

\n

• Ensure compliance with regulatory requirements and maintain high standards of data governance.

\n

• Support production environments, troubleshoot issues, and optimize workflows for efficiency.

\n

• Drive innovation by integrating AI solutions and modern data engineering practices.

\n

\n

Senior Data Engineer Key Responsibilities & Duties

\n

\n
• Design and optimize SQL Server objects, including schemas, stored procedures, and queries.

\n

• Develop and maintain ETL workflows using Informatica PowerCenter and Microsoft Fabric tools.

\n

• Implement data warehouse solutions with dimensional modeling and medallion architecture.

\n

• Create and certify Power BI semantic models with row-level security and entitlement rules.

\n

• Monitor production processes, troubleshoot failures, and ensure uninterrupted data operations.

\n

• Apply Git version control and CI/CD pipelines to data engineering workflows.

\n

• Document technical processes, data lineage, and operational runbooks for team collaboration.

\n

• Collaborate with stakeholders to align data solutions with business requirements.

\n

\n

Senior Data Engineer Job Requirements

\n

\n
• Bachelor’s degree in Computer Science, Information Systems, or related field.

\n

• 7+ years of experience in data engineering, SQL development, and ETL workflows.

\n

• Proficiency in Microsoft SQL Server, T-SQL, and Azure SQL.

\n

• Experience with Informatica PowerCenter and Microsoft Fabric tools.

\n

• Strong knowledge of data warehouse design and medallion architecture.

\n

• Hands-on experience with Power BI semantic model development and DAX.

\n

• Familiarity with Python for data engineering tasks.

\n

• Microsoft certifications such as DP-700 or DP-600 are preferred.

\n

\n