The Role
Design and implement end-to-end analytical solutions in Microsoft Fabric using Medallion architecture. Build scalable ETL/ELT, CDC, historical and incremental loads; optimize Delta tables; configure Fabric capacity; enforce governance via Purview; integrate multiple data sources; manage access, auditing, and data quality; document architectures and collaborate with BI, data quality, and business teams.
Summary Generated by Built In
This is a remote position.
Job Objective: Design, implement, and optimize end-to-end analytical solutions in Microsoft Fabric, ensuring data quality, scalability, governance, and alignment with business needs.
Responsibilities:
- Design architecture based on Medallion Architecture (Bronze, Silver, Gold).
- Implement scalable ETL/ELT processes, historical loads, incremental loads, and CDC.
- Configure and manage Fabric Capacity.
- Ensure data governance through Microsoft Purview.
- Optimize Delta tables (Partitioning, Optimize/Z-Order/V-Order).
- Integrate data from multiple sources (APIs, SFTP, ERP, SQL Server, ADLS Gen2).
- Manage access control, auditing, traceability, and data quality.
- Document processes and architectures clearly.
- Collaborate with BI, Data Quality teams, and business users.
Requirements
3–6+ years in Data Engineering / Analytics.
1–2 years working directly with Microsoft Fabric or participating in migrations from Azure/Synapse.
- Deep knowledge of OneLake, Lakehouse, Data Warehouse, and Pipelines.
- Strong SQL and Python skills (essential for Notebooks).
- Expertise in Delta Lake and Parquet formats.
- Familiarity with access control, error handling, and reprocessing.
Technical Skills:
- Fabric Data Factory (Pipelines) and prior experience with Azure Data Factory / Synapse.
- Fabric Data Engineering (Spark) with experience in Databricks / Synapse.
- Power BI (advanced semantic modeling, Direct Lake).
- PySpark, advanced SQL, Power Query / Dataflows Gen2.
- Git / Azure DevOps (version control, deployment pipelines).
- Governance and security in Fabric (Workspaces, Roles, OneSecurity).
Desirable Plus:
- Knowledge of Data Activator for real-time responses.
- Familiarity with Copilot in Fabric.
Certifications:
- Microsoft Fabric Analytics Engineer
- Azure Data Engineer
- Power BI Data Analyst
Soft Skills:
- Ability to translate business requirements into technical solutions.
- Effective communication with cross-functional teams.
- Clear and structured documentation.
- Autonomy and sound technical judgment (Fabric is still evolving).
Benefits
Work remotely
High-performance team
Excellent work culture
Competitive compensation package
Skills Required
- 3-6+ years in Data Engineering / Analytics
- 1-2 years working directly with Microsoft Fabric or participating in migrations from Azure/Synapse
- Deep knowledge of OneLake, Lakehouse, Data Warehouse, and Pipelines
- Strong SQL skills (advanced SQL)
- Strong Python skills (essential for Notebooks)
- Expertise in Delta Lake and Parquet formats
- Experience implementing ETL/ELT processes including historical loads, incremental loads, and CDC
- Experience integrating data from APIs, SFTP, ERP systems, SQL Server, and ADLS Gen2
- Configure and manage Fabric capacity
- Experience with Fabric Data Factory (Pipelines), Azure Data Factory, and Synapse
- Experience with Fabric Data Engineering (Spark), Databricks, and PySpark
- Power BI advanced semantic modeling and Direct Lake experience
- Power Query and Dataflows Gen2 experience
- Experience with Git / Azure DevOps for version control and deployment pipelines
- Governance and security experience in Fabric (Microsoft Purview, Workspaces, Roles, OneSecurity)
- Optimize Delta tables (partitioning, Optimize/Z-Order/V-Order)
- Familiarity with access control, error handling, reprocessing, auditing, traceability and data quality management
- Certifications: Microsoft Fabric Analytics Engineer, Azure Data Engineer, Power BI Data Analyst
- Knowledge of Data Activator for real-time responses and familiarity with Copilot in Fabric
- Ability to translate business requirements into technical solutions, strong communication, clear documentation, autonomy and sound technical judgment
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
SmartLogix is an information technology services and software development company creating custom cloud applications and market-ready products. Its capabilities include cloud integration, data analytics, mobile technology, UI/UX design, and managed IT services. The company also offers staffing and talent solutions, pre-screening professionals and organizing resources for projects, consultancy, daily operations, and IT staffing across healthcare, food distribution, insurance, and other industries.
