Sr Data & Analytics Engineer

Job description

POSITION PURPOSE

The Senior Data & Analytics Engineer within the AI, Data & Emerging Tech organization, responsible to support, enhance, and modernize the organization’s enterprise Data & Analytics capabilities using Microsoft Fabric and Power BI. This role is responsible for maintaining reliable production reporting while developing scalable data pipelines, transformation processes, Enterprise Data Warehouse solutions, and reusable semantic models.

The position will partner with global business and technology teams to transform data from enterprise source systems into trusted, governed, and reusable data products, enabling consistent reporting and self-service analytics across Finance, Sales, Manufacturing, Supply Chain, and Engineering. This role will also help establish scalable engineering practices, improve data quality and reconciliation, enhance performance and operational stability, and accelerate delivery through responsible use of AI-assisted development.

While the role has no formal direct reports: The individual is expected to take ownership of assigned work, collaborate effectively with business and technical teams, troubleshoot issues through resolution, and deliver reliable, scalable, and maintainable solutions aligned with business priorities and enterprise Data & Analytics standards.

PRINCIPAL ACCOUNTABILITIES

Support & Enhance Existing Power BI Reporting

• Provide day-to-day support for existing Power BI reports, dashboards and workspaces.
• Troubleshoot data discrepancies, refresh failures, DAX issues, report performance, access concerns, and business-user questions.
• Deliver report enhancements, new measures, visuals, filters, and usability improvements based on approved requirements.
• Monitor scheduled data loads and report refreshes, perform root-cause analysis, and coordinate issue resolution with onshore and offshore teams.
• Support regression testing, user acceptance testing, deployment validation, and production stabilization.

Microsoft Fabric & Enterprise Data Warehouse Implementation

• Develop and maintain Microsoft Fabric Data Pipelines for ingestion, orchestration, parameterization, and dependency management.
• Develop Fabric Notebooks using PySpark and SQL for cleansing, transformation, validation, enrichment, and reconciliation.
• Build and maintain OneLake, Lakehouse, Warehouse, and Delta table solutions using scalable engineering patterns.
• Implement Bronze, Silver, and Gold data layers, including full-load and incremental-load strategies.
• Translate business reporting requirements into curated data products and dimensional models, including Fact and Dimension tables.
• Contribute to enterprise data domains such as Finance, Sales, Manufacturing, Supply Chain, and Engineering.
• Implement reusable components for logging, monitoring, exception handling, data quality, and reconciliation.
• Support migration and modernization of existing reporting and data solutions into the Microsoft Fabric architecture.
Semantic Models & Self-Service Reporting
• Maintain, support, enhance, and optimize existing semantic models, including solutions developed during the Proof of Value (PoV), while developing new reusable, business-aligned semantic models to support enterprise and domain-specific reporting.
• Design governed measures, KPIs, dimensions, hierarchies, relationships, and business calculations using consistent enterprise definitions.
• Develop and optimize DAX measures and apply star-schema and dimensional-modeling principles to ensure performance, scalability, usability, and maintainability.
• Enable self-service analytics by providing trusted, intuitive, and business-friendly semantic models that allow users to develop Power BI reports with reduced dependency on IT.
• Implement appropriate Row-Level Security (RLS) and data-access controls to support secure and governed data consumption.
• Establish and follow standards for semantic-model naming conventions, documentation, ownership, governance, and reuse.
• Partner with business and technical teams to determine whether new requirements should extend existing semantic models or require new domain-specific models.
Production Support, Enhancements & Development
• Provide day-to-day support for production data, Microsoft Fabric, semantic model, and Power BI solutions, including investigation of defects, root-cause analysis, troubleshooting, and timely resolution.
• Work with the Data & Analytics Lead to understand priorities and execute assigned defects, change requests, enhancements, and new development based on agreed business requirements.
• Support the end-to-end solution lifecycle, working across data engineering, semantic modeling, Power BI development, and production support as required.
Data Quality, Testing & Reconciliation
• Ensure data accuracy and consistency through validation, reconciliation, and testing across source systems, the Fabric Enterprise Data Warehouse, semantic models, and Power BI reports.
• Develop and execute appropriate testing to validate new development, enhancements, and defect resolutions prior to production deployment.
• Continuously improve solution performance, reliability, scalability, and operational stability across the Microsoft Fabric and Power BI environment.
Business & Technical Collaboration
• Partner with business stakeholders to understand reporting and analytical requirements and translate them into effective, scalable technical solutions.
• Collaborate effectively with global business stakeholders, internal technology teams, and distribute delivery resources to resolve dependencies and deliver solutions aligned with established priorities.
• Communicate technical concepts, issues, solutions, and progress clearly to both business and technical stakeholders.
Documentation & Governance
• Maintain clear technical and operational documentation, including solution designs, business rules, data definitions, support procedures, and development standards.
• Promote reusable and maintainable solutions by adhering to established Data & Analytics architecture, governance, security, naming, and development standards.
• Support knowledge sharing and knowledge transfer to improve long-term solution maintainability and operational continuity.
Communication
• Demonstrate strong verbal and written communication skills in English, with the ability to effectively communicate technical concepts, issues, and solutions to both business and technical audiences.

Preferred

• 8+ years of experience in data engineering, business intelligence, analytics, or enterprise data warehousing.
• Hands-on experience with Microsoft Fabric.
• Strong experience developing and supporting Power BI reports and semantic models in production.
• Experience implementing or modernizing Enterprise Data Warehouse.
• Experience working in a global onshore/offshore delivery model and supporting business users across regions.
• Experience integrating SAP S/4HANA, SAP BW, CDS Views, OData/APIs, or other Non-SAP data sources is highly desirable.
• Microsoft Fabric and/or Power BI certification is an advantage.
• AI-assisted development for Fabric Pipelines, Notebooks, SQL, PySpark, DAX, and Power Query
• Code generation, refactoring, documentation, testing, and troubleshooting

WORKING CONDITIONS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to stand and walk up to 50% of the time. Working conditions include those of a normal construction environment, as well as standard hazards associated with installed HVAC equipment and rotating equipment. This position requires occasional lifting of up to 30 lbs, and travel of 10 – 20% of the time.

Apply at Baltimore Aircoil Company (opens in a new tab)

Source: Baltimore Aircoil Company job board (UKG (UltiPro)).

Report this job

Wrongly listed? Tell us why.