Senior Microsoft Stack BI Engineer Staff Connect Information Technology Consultants

1. BI Architecture & Design

• Design and document end-to-end BI architecture, including ETL pipelines, semantic models, and reporting frameworks.

• Define scalable data pipelines and reporting standards for enterprise analytics.

2. Data Modeling & Transformation

• Build and maintain Bronze (staging), Silver (transformation), and Gold (presentation) layers.

• Implement dimensional models using Star and Snowflake schemas.

3. ETL Development

• Develop and manage ETL pipelines using SQL Server Integration Services (SSIS).

• Implement full and incremental data load strategies for large datasets.

4. Data Analytics & Visualization

• Develop advanced dashboards and reports using Microsoft Power BI.

• Create optimized DAX measures, calculated columns, and semantic models.

5. Automation & Performance Optimization

• Automate workflows and report distribution using Microsoft Power Automate.

• Optimize SQL queries and SSAS performance for large-scale analytics workloads.

• Use Python for data manipulation, automation, and integration scripting.

6. Documentation & Handover

• Deliver comprehensive source-to-destination mapping documentation, including:

  • Primary Keys

  • Join Logic

  • Data Transformations

  • Data Lineage

• Collaborate with business and technical stakeholders to ensure data accuracy and reporting reliability.