Data Warehouse/Microsoft Fabric Engineer

Parsons; United States; On-site; USD 90,000 - 130,000; Full time

Job summary

Parsons is seeking a Data Warehouse Engineer to design, develop, and maintain scalable data warehouse solutions that support analytics, reporting, and application development. You will build efficient data pipelines, implement structured data models, and integrate data from diverse sources into centralized, analytics-ready environments.

The role focuses on Azure-based data platforms, modern cloud data integration tools, and collaboration with analytics and dev teams to enable robust reporting

Qualifications

• High School Diploma.
• 3+ years of experience in data engineering, data warehousing, or related field.
• Extensive experience using Microsoft Fabric.
• Strong proficiency in SQL, including query optimization, indexing, and performance tuning.
• Experience designing and implementing data warehouse architectures and dimensional data models.
• Experience developing ETL/ELT pipelines and data integration workflows.
• Experience with SQL Server Integration Services (SSIS).
• Experience working with relational databases such as SQL Server, Azure SQL, or similar platforms.
• Experience with structured and semi-structured data formats, including Parquet files.

Responsibilities

• Design, develop, and maintain enterprise data warehouse solutions using modern data warehousing principles.
• Build and manage ETL/ELT pipelines to ingest and transform data from various sources.
• Develop and maintain dimensional data models optimized for analytics and reporting.
• Write efficient, scalable SQL queries and optimize database performance.
• Integrate data from systems such as relational databases, cloud platforms, APIs, SharePoint, flat files, and enterprise apps.
• Support data prep and modeling for analytics platforms like Power BI.
• Implement data validation, monitoring, and quality control to ensure data integrity.
• Collaborate with analytics and application teams to support reporting and app requirements.
• Support cloud-based data platform development within the Microsoft Azure ecosystem.
• Work with both traditional ETL tools and modern cloud-based data integration tools.
• Document data models, pipeline processes, and system architecture.

Skills

SQL

Power BI

Python

Education

High School Diploma

Tools

SSIS

Azure Data Factory

Microsoft Fabric

Job description

In a world of possibilities, pursue one with endless opportunities. Imagine Next! At Parsons, you can imagine a career where you thrive, work with exceptional people, and be yourself. Guided by our leadership vision of valuing people, embracing agility, and fostering growth, we cultivate an innovative culture that empowers you to achieve your full potential. Unleash your talent and redefine what's possible.

Job Description:

We are seeking a Data Warehouse Engineer to design, develop, and maintain scalable data warehouse solutions that support analytics, reporting, and application development. This role will focus on building efficient data pipelines, implementing structured data models, and integrating data from various source systems into centralized, analytics-ready environments.

Key Responsibilities:

• Design, develop, and maintain enterprise data warehouse solutions using modern data warehousing principles
• Experience using Microsoft Fabric
• Build and manage ETL/ELT pipelines to ingest and transform data from various structured and unstructured sources
• Develop and maintain dimensional data models optimized for analytics and reporting
• Write efficient, scalable SQL queries and optimize database performance
• Integrate data from systems such as relational databases, cloud platforms, APIs, SharePoint, flat files, and enterprise applications
• Support data preparation and modeling needs for analytics platforms such as Power BI
• Implement data validation, monitoring, and quality control processes to ensure data integrity
• Collaborate with analytics and application development teams to support reporting and application requirements
• Support cloud-based data platform development, primarily within the Microsoft Azure ecosystem
• Work with both traditional ETL tools and modern cloud-based data integration tools
• Document data models, pipeline processes, and system architecture

Typical Assignments:

• Design and implement data warehouse schemas, including fact and dimension tables
• Develop ETL/ELT pipelines using Azure Data Factory, SSIS, Microsoft Fabric, or similar tools
• Build and maintain Azure SQL databases, data lakes, Synapse, or Fabric-based warehouse environments
• Transform and integrate data from multiple enterprise systems into centralized warehouse environments
• Work with structured and semi-structured data formats, including Parquet files, CSV, and JSON
• Optimize data structures and queries to improve performance and scalability
• Support Power BI development teams by providing clean, structured, and performant data models
• Assist in the design and implementation of cloud-based data platform architecture
• Support backend data integration for Power Platform solutions, including Power BI and Power Pages
• Troubleshoot and resolve data pipeline, performance, and integration issuesAssist in establishing and maintaining data engineering and data warehousing best practices

Education and Experience

• High School Diploma
• 3+ years of experience in data engineering, data warehousing, or related field.
• Extensive experience using Microsoft Fabric
• Strong proficiency in SQL, including query optimization, indexing, and performance tuning
• Experience designing and implementing data warehouse architectures and dimensional data models
• Experience developing ETL/ELT pipelines and data integration workflows
• Experience with SQL Server Integration Services (SSIS)
• Experience working with relational databases such as SQL Server, Azure SQL, or similar platforms
• Experience working with structured and semi-structured data formats, including Parquet files

Preferred:

• Experience working within Microsoft Azure data ecosystem, including tools such as: Azure Data Factory
• Azure SQL Database
• Azure Synapse Analytics
• Microsoft Fabric
• Azure Data Lake Storage
• Experience supporting Power BI semantic models and analytics environments
• Experience working with data lake architectures and modern cloud data platforms
• Experience with scripting languages such as Python and PySpark for data processing and automation
• Experience supporting Power Platform solutions, including Power BI and Power Pages
• Experience working in consulting or project-based environments

Security Clearance Requirement:

None

This position is part of our Critical Infrastructure team.

For more than 80 years, our experts have designed and delivered the critical infrastructure that connects and protects communities around the world. We work in collaborative teams, both within the company and with our partners and customers, to plan, design, build, and modernize infrastructure. We take special pride in projects and s