Data Warehouse/Microsoft Fabric Engineer

Parsons Corporation•USA TX (Virtual Office), TX

2d•$88,400 - $154,700

About The Position

Parsons is seeking a Data Warehouse Engineer to design, develop, and maintain scalable data warehouse solutions supporting analytics, reporting, and application development. The role focuses on building efficient data pipelines, implementing structured data models, and integrating data from multiple source systems into centralized, analytics-ready environments. The engineer will collaborate with analytics and application developers and project teams to ensure data platforms are reliable, high-performing, and aligned with business and project requirements. The position calls for strong SQL skills, experience with cloud-based data platforms—preferably Microsoft Azure—and knowledge of modern data warehousing practices. The role is part of Parsons’ Critical Infrastructure team.

Requirements

High school diploma.
At least 3 years of experience in data engineering, data warehousing, or a related field.
Extensive experience using Microsoft Fabric.
Strong SQL proficiency, 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 with relational databases such as SQL Server, Azure SQL, or similar platforms.
Experience working with structured and semi-structured data formats, including Parquet files.

Nice To Haves

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

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 structured and unstructured sources.
Develop and maintain dimensional data models optimized for analytics and reporting.
Write scalable SQL queries and optimize database performance.
Integrate data from relational databases, cloud platforms, APIs, SharePoint, flat files, and enterprise applications.
Support data preparation and modeling 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 traditional ETL tools and modern cloud-based data integration tools.
Document data models, pipeline processes, and system architecture.
Design and implement data warehouse schemas, including fact and dimension tables.
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 formats, including Parquet, CSV, and JSON.
Support Power BI development teams by providing clean, structured, performant data models.
Assist with cloud-based data platform architecture and backend data integration for Power Platform solutions, including Power BI and Power Pages.
Troubleshoot and resolve data pipeline, performance, and integration issues.
Help establish and maintain data engineering and data warehousing best practices.