Senior Data Engineer

Overview:

Design and deliver scalable OLTP, Business Intelligence, and Data Warehouse solutions using Microsoft Fabric, SSIS, SQL Server, and related BI technologies. Develop and maintain enterprise reports, support requirements gathering, evaluate and recommend technical approaches, and implement solutions within established timelines.

Responsibilities:

• Develop and maintain ETL/ELT processes using SSIS, Fabric Pipelines, and/or Azure Data Factory
• Develop and implement solutions in Microsoft PowerBI and Microsoft Fabric
• Design, develop, and optimize complex T-SQL stored procedures, functions, and database objects
• Perform advanced database performance tuning
• Contribute to the design and enhancement of OLTP and OLAP data models
• Build and support integrations that consume or expose REST APIs
• Create and govern dashboards and visual analytics in Power BI or Tableau
• Verify and maintain data quality and integrity
• Troubleshoot and resolve database, ETL, reporting, and data quality issues
• Maintain thorough documentation and support compliance
• Collaborate with cross-functional teams to enhance BI and data platform capabilities

Requirements:

• Bachelor’s degree in Engineering or Computer Science
• 6 years of experience in reports and data warehouse development
• 5 years software development experience on Microsoft BI Platform including MS SQL Server
• 4 years of experience in DB Development (OLTP) using MS SQL
• 2 years of experience in building Data Marts using dimensional models
• 2 years of experience in building Dashboards and KPI visualization on Power BI and/or Tableau
• Strong reporting and data warehouse development skills
• Large data migration experience
• Hands-on experience using Oracle