Senior Data Engineer

Job DetailExperience Level Sr LevelDegree Type Bachelor of Science (BS)Employment Full TimeWorking Type HybridJob Reference Salary Type AnnuallyIndustry Broker Dealer;Financial ServicesSelling Points Lead impactful data engineering projects at a leading organization. Drive innovation with modern cloud-based data platforms and tools. Enhance your expertise in SQL, ETL, and Power BI technologies.Job DescriptionSenior Data Engineer OverviewThe Senior Data Engineer will lead the development and optimization of data engineering processes using Microsoft Fabric and SQL Server technologies.Collaborate with cross-functional teams to ensure data integrity and reliability for critical business processes.Contribute to the migration of legacy systems to modern cloud-based data platforms.Design and implement data warehouse architectures using medallion layering for enhanced data accessibility.Develop Power BI semantic models with robust data entitlement rules for secure reporting.Ensure compliance with regulatory requirements and maintain high standards of data governance.Support production environments, troubleshoot issues, and optimize workflows for efficiency.Drive innovation by integrating AI solutions and modern data engineering practices.Senior Data Engineer Key Responsibilities & DutiesDesign and optimize SQL Server objects, including schemas, stored procedures, and queries.Develop and maintain ETL workflows using Informatica PowerCenter and Microsoft Fabric tools.Implement data warehouse solutions with dimensional modeling and medallion architecture.Create and certify Power BI semantic models with row-level security and entitlement rules.Monitor production processes, troubleshoot failures, and ensure uninterrupted data operations.Apply Git version control and CI/CD pipelines to data engineering workflows.Document technical processes, data lineage, and operational runbooks for team collaboration.Collaborate with stakeholders to align data solutions with business requirements.Senior Data Engineer Job RequirementsBachelor’s degree in Computer Science, Information Systems, or related field.7+ years of experience in data engineering, SQL development, and ETL workflows.Proficiency in Microsoft SQL Server, T-SQL, and Azure SQL.Experience with Informatica PowerCenter and Microsoft Fabric tools.Strong knowledge of data warehouse design and medallion architecture.Hands-on experience with Power BI semantic model development and DAX.Familiarity with Python for data engineering tasks.Microsoft certifications such as DP-700 or DP-600 are preferred.