What are the responsibilities and job description for the BI/Microsoft Fabric Engineer position at The AES Group?
Job Title: BI / Microsoft Fabric Engineer
Location: East Boston, MA
Work Model: Hybrid – 3 Days Onsite per Week from Day 1
Job Overview
We are seeking an experienced BI / Microsoft Fabric Engineer to support the implementation of a new Microsoft Fabric environment. The ideal candidate will have strong expertise in Microsoft Fabric, OneLake, Lakehouse architecture, Snowflake, Power BI, and enterprise data engineering.
The consultant will collaborate closely with an existing Microsoft implementation vendor to develop scalable data ingestion, transformation, consolidation, and analytics solutions.
The primary objective is to integrate data from multiple enterprise sources, including Snowflake, into Microsoft Fabric for efficient data management, governance, reporting, and business intelligence.
Key Responsibilities
- Design, develop, and implement analytics solutions using Microsoft Fabric, OneLake, Lakehouse, and Power BI.
- Build scalable Lakehouse and data warehouse architectures within Microsoft Fabric.
- Develop automated data ingestion, ETL/ELT workflows, Fabric Dataflows, and Data Engineering pipelines.
- Integrate data from Snowflake, Microsoft Dataverse, and other enterprise platforms into Microsoft Fabric.
- Clean, transform, consolidate, categorize, and optimize datasets for enterprise analytics.
- Create and maintain Power BI dashboards, semantic models, datasets, and reporting frameworks.
- Develop advanced DAX calculations, SQL queries, and reusable analytical models.
- Build Fabric Notebooks and Spark-based data transformation solutions.
- Implement incremental refresh, partitioning, aggregation, and performance optimization techniques.
- Establish data governance, lineage tracking, validation, reconciliation, and monitoring processes.
- Implement CI/CD, DevOps practices, and deployment pipelines for Fabric and Power BI solutions.
- Configure Power BI workspaces, security roles, row-level security (RLS), and object-level security (OLS).
- Monitor and optimize Fabric workloads, Power BI capacity, query execution, and reporting performance.
- Support migration of legacy Tableau reports and BI solutions to Microsoft Fabric and Power BI.
- Collaborate with data engineers, architects, implementation vendors, and business stakeholders.
- Develop technical documentation covering data architecture, pipelines, semantic models, and reporting solutions.
Required Qualifications
- 5 years of experience in Business Intelligence, Data Engineering, or Analytics Engineering.
- Strong hands-on experience with Microsoft Fabric, OneLake, and Lakehouse architecture.
- Experience developing Microsoft Fabric Data Pipelines, Dataflows Gen2, and ETL/ELT solutions.
- Strong expertise in Power BI, DAX, SQL, and enterprise data modeling.
- Experience integrating Snowflake with Microsoft Fabric or other cloud analytics environments.
- Experience developing scalable data warehouse and Lakehouse solutions.
- Knowledge of Microsoft Dataverse and its integration with analytics platforms.
- Experience with Fabric Notebooks, Apache Spark, or PySpark.
- Understanding of Microsoft Purview, enterprise data governance, and data lineage.
- Strong troubleshooting, performance optimization, and stakeholder communication skills.
Preferred Qualifications
- Experience implementing Microsoft Fabric environments from the ground up.
- Experience with Azure Data Factory, Azure Data Lake Storage, and Azure DevOps.
- Knowledge of CI/CD practices and Power BI deployment pipelines.
- Experience migrating Tableau dashboards and reports to Power BI.
- Experience collaborating with Microsoft implementation partners or external technology vendors.
- Familiarity with enterprise data security, access management, and capacity optimization.