Senior BI Data Engineer

Key Responsibilities
Develop and maintain ETL/ELT processes using SSIS, Microsoft Fabric Pipelines, and/or Azure Data Factory. Develop advanced Script Tasks using C# or VB.NET to automate file operations and implement custom business logic. Develop and implement Microsoft Power BI and Microsoft Fabric solutions, including Lakehouse/Warehouse models, Dataflows Gen2, Pipelines, and Semantic Models. Support modernization of existing ETL and reporting assets into Microsoft Fabric and Azure cloud-based frameworks.

Design, develop, and optimize complex T-SQL stored procedures, functions, and database objects for high-volume OLTP and Data Warehouse environments. Work with transaction isolation levels, table hints, deadlocks, linked servers, OPENQUERY, triggers, and column-level encryption. Perform advanced database performance tuning, including execution plan analysis, indexing strategies, partitioning, and transaction optimization. Contribute to the design and enhancement of OLTP and OLAP data models based on business, analytical, and performance requirements.

Build and support integrations that consume or expose REST APIs, including testing, validation, and troubleshooting using Postman and related API tools. Create and govern dashboards and visual analytics using Power BI and/or Tableau. Ensure dashboards and visualizations accurately align with established semantic models and governance standards. Verify and maintain data quality and integrity across data warehouses, semantic models, dashboards, reports, and data extracts. Troubleshoot database, ETL, reporting, data quality, performance, capacity, replication, and distributed data issues.

Participate in incident resolution and root-cause remediation activities. Maintain thorough technical documentation and adhere to change control processes. Support regulatory, cybersecurity, and data protection compliance requirements. Collaborate with Product Managers, Analysts, Engineers, and cross-functional teams to enhance BI and data platform capabilities. Evaluate technical approaches and recommend appropriate solutions for business and data requirements. Stay current with industry trends and participate in relevant training, conferences, and professional development programs.

Uphold service excellence behaviors and support organizational mission, values, policies, and guiding principles.

Required Qualifications
6+ years of experience
Bachelor's

Skills
OLTP Solutions Development
Business Intelligence Solutions Development
Data Warehouse Solutions Development
Microsoft Fabric
SSIS
SQL Server
ETL/ELT Processes
C#
VB.NET
Azure Data Factory
T-SQL Stored Procedures
Database Performance Tuning
OLTP Data Modeling
OLAP Data Modeling
REST APIs
Postman
Power BI
Tableau
Oracle
Dimensional Modeling
Microsoft Azure
DBA Activities
XML Data
TFS
Requirements Gathering
Technical Evaluation
Troubleshooting
Data Migration
Data Quality Management
Regulatory Compliance
Cybersecurity Compliance
Data Protection
Incident Resolution
Root Cause Analysis
Technical Documentation
Change Control Processes
Cross-functional Collaboration

Schedule
Start date: 2026-09-14