Sign upLog in
Data Analysis Jobs in Pittsburgh, PA

Data Scientist

Synergy Staffing Inc

Pittsburgh, PA

Apply
JOB DETAILS
SKILLS
Agile Programming Methodologies, Analysis Skills, Artificial Intelligence (AI), Automation, Best Practices, Business Case, Business Intelligence, Communication Skills, Computer Science, Continuous Deployment/Delivery, Continuous Integration, Data Management, Data Modeling, Data Quality, Data Science, Data Structures, Data Warehousing, Database Design, DevOps, Dimensional Modeling, Engineering, Enterprise Architecture, GitHub, Information Technology & Information Systems, Metadata, Microsoft Certifications, Microsoft Product Family, Microsoft Windows Azure, Operational Audit, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Python Programming/Scripting Language, Query Optimization, SQL (Structured Query Language), Snowflake Schema, Star Schema, Team Player, Training Data Sets, Use Cases, Warehousing
LOCATION
Pittsburgh, PA
POSTED
6 days ago
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.

About the Company

S

Synergy Staffing Inc

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!

COMPANY SIZE
1 to 9 employees
INDUSTRY
Financial Services
WEBSITE
http://www.synergystaffing.net

Resume Resources

Free Resume TemplatesFree Resume Builder

Similar Job Searches

Applications Analyst JobsBusiness Systems Analyst JobsData Analyst Jobs