Want to know if you’re a fit? Upload your resume and let our AI show you.
Skills
Agile Programming Methodologiesunmatched
Analysis Skillsunmatched
Artificial Intelligence (AI)unmatched
Automationunmatched
Best Practicesunmatched
Business Caseunmatched
Business Intelligenceunmatched
Communication Skillsunmatched
Computer Scienceunmatched
Continuous Deployment/Deliveryunmatched
Continuous Integrationunmatched
Data Managementunmatched
Data Modelingunmatched
Data Qualityunmatched
Data Scienceunmatched
Data Structuresunmatched
Data Warehousingunmatched
Database Designunmatched
DevOpsunmatched
Dimensional Modelingunmatched
Engineeringunmatched
Enterprise Architectureunmatched
GitHubunmatched
Information Technology & Information Systemsunmatched
Metadataunmatched
Microsoft Certificationsunmatched
Microsoft Product Familyunmatched
Microsoft Windows Azureunmatched
Operational Auditunmatched
Performance Tuning/Optimizationunmatched
Power BIunmatched
Problem Solving Skillsunmatched
Python Programming/Scripting Languageunmatched
Query Optimizationunmatched
SQL (Structured Query Language)unmatched
Snowflake Schemaunmatched
Star Schemaunmatched
Team Playerunmatched
Training Data Setsunmatched
Use Casesunmatched
Warehousingunmatched
Description
We are seeking an experienced Data Scientist with a strong focus on Microsoft Fabric to design, implement, and maintain enterprise data solutions. The ideal candidate will have a minimum of 3 years of hands-on experience implementing Microsoft Fabric, including deep expertise in Fabric Data Factory, Dataflow Gen2, Notebooks, and Data Warehouse and Lakehouse design.
Key Responsibilities
Data Engineering & Pipeline Development
Design, develop, and maintain data pipelines using Microsoft Fabric Data Factory for data ingestion, transformation, and orchestration.
Build Dataflow Gen2 processes to prepare and enrich data from multiple sources for analytical consumption.
Develop and manage Fabric Notebooks (Python, Spark, SQL) for advanced transformations and automation.
Deploy, monitor, and optimize data pipelines using CI/CD processes in Azure DevOps or GitHub Actions.
Implement robust data quality, validation, and monitoring processes.
Data Architecture & Modeling
Design and implement Data Warehouses and Lakehouses within Microsoft Fabric to meet analytical and operational needs.
Understand when to use Lakehouse vs. Warehouse based on data volume, structure, performance requirements, and business use cases.
Apply best practices for data modeling (star/snowflake schema, dimensional modeling, and semantic models).
Ensure alignment with enterprise architecture and data governance standards.
Analytics & Business Enablement
Develop Power BI semantic models and datasets using DAX and Power Query for reporting and self-service analytics.
Collaborate with BI and business teams to ensure data products meet stakeholder needs.
Optimize Power BI performance by tuning data models, queries, and refresh strategies.
Required Qualifications
Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or 10 years of working experience in related field.
Minimum of 2 years of hands-on experience implementing Microsoft Fabric (Data Factory, Dataflow Gen2, Notebooks, Data Warehouse, Lakehouse).
Proven experience developing and deploying Fabric Data Factory pipelines with CI/CD automation.
Strong working knowledge of Power BI, DAX, and Power Query (M language).
Expertise in SQL and Python for data transformations, query optimization, and automation.
Solid understanding of data architecture principles, including data modeling, schema design, and performance tuning.
Experience applying DevOps and Agile methodologies in data engineering projects.
Ability to choose the right Fabric tools (Lakehouse, Warehouse, Dataflows, Notebooks, Power BI) to solve specific business problems.
Familiarity with Data Mesh principles, including domain-oriented data ownership, federated governance, and self-service data platforms.
Proficient in implementing Medallion Architecture (Bronze, Silver, Gold layers) within Microsoft Fabric for scalable and maintainable data solutions.
Excellent communication and collaboration skills, with experience working across multiple business domains.
Preferred Qualifications
Microsoft certifications such as:
Microsoft Certified: Fabric Analytics Engineer Associate
Microsoft Certified: Azure Data Engineer Associate
Experience with GitHub Actions or Azure DevOps YAML pipelines for CI/CD automation.
Familiarity with data governance frameworks, metadata management, and security best practices.
Exposure to real-time analytics, event-driven architecture, or AI/ML data preparation.
Numbers & Facts
Location
Pittsburgh, PA
Industry
Financial Services
Company Size
1 to 9 employees
Website
http://www.synergystaffing.net
About Company
We are a staffing company dedicated in placing quality candidates within our network of companies. We are unique and far different from most staffing companies. All Jobs posted on our sites are for immediate direct hire and we also hire on behalf of our clients. This eliminates steps in the hiring process and gets you to work faster!