数据仓库/微软Fabric工程师
Data Warehouse/Microsoft Fabric Engineer
在充满可能性的世界中，追求一个充满无限机遇的事业。想象未来！
在Parsons，你可以想象一个让你成长、与优秀的人共事并做真实的自己的职业。我们以重视人才、拥抱敏捷和促进成长的领导愿景为指导，培养一种创新文化，使你能够充分发挥潜力。释放你的才能，重新定义可能。
**职位描述：**
我们正在寻找一名数据仓库工程师，负责设计、开发和维护可扩展的数据仓库解决方案，以支持分析、报告和应用开发。该职位将专注于构建高效的数据管道，实施结构化数据模型，并将来自各种源系统的数据整合到集中式、分析就绪的环境中。
入选的候选人将与分析和应用开发人员以及项目团队密切合作，确保数据平台可靠、高性能，并符合业务和项目需求。该职位需要扎实的SQL技能，有基于云的数据平台经验（优先考虑Microsoft Azure），并对现代数据仓库最佳实践有深入理解。
主要职责：
- 使用现代数据仓库原则设计、开发和维护企业级数据仓库解决方案
- 具有使用Microsoft Fabric的经验
- 构建和管理ETL/ELT管道，从各种结构化和非结构化数据源中获取和转换数据
- 开发和维护针对分析和报告优化的维度数据模型
- 编写高效、可扩展的SQL查询并优化数据库性能
- 从关系型数据库、云平台、API、SharePoint、平面文件和企业应用程序等系统中集成数据
- 支持Power BI等分析平台的数据准备和建模需求
- 实现数据验证、监控和质量控制流程，以确保数据完整性
- 与分析和应用开发团队协作，支持报告和应用需求
- 支持基于云的数据平台开发，主要在Microsoft Azure生态系统内
- 使用传统ETL工具和现代云数据集成工具
- 记录数据模型、管道流程和系统架构
典型任务：
- 设计和实现数据仓库模式，包括事实表和维度表
- 使用Azure Data Factory、SSIS、Microsoft Fabric等工具开发ETL/ELT管道
查看英文原文
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.
The selected candidate will work closely with analytics and application developers, as well as project teams, to ensure data platforms are reliable, high-performance, and aligned with business and project requirements. This role requires strong SQL skills, experience with cloud-based data platforms (preferably Microsoft Azure), and a solid understanding of modern data warehousing best practices.
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 issues
- Assist in establishing and maintaining data engineering and data warehousing best practices
**Education and Experience**
- High School Diploma
- 3–7+ 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 solutions that improve communities as well as people’s quality of life by promoting economic growth, enhancing mobility, and increasing sustainability and resiliency. Powered by our people, we provide the imagination necessary to support our customers’ visions—and to help them see what's next!
Salary Range: $88,400.00 - $154,700.00
We value our employees and want our employees to take care of their overall wellbeing, which is why we offer best-in-class benefits such as medical, dental, vision, paid time off, Employee Stock Ownership Plan (ESOP), 401(k), life insurance, flexible work schedules, and holidays to fit your busy lifestyle!
This position will be posted for a minimum of 3 days and will continue to be posted for an average of 30 days until a qualified applicant is selected or the position has been cancelled.
Parsons is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, veteran status or any other protected status.
We truly invest and care about our employee’s wellbeing and provide endless growth opportunities as the sky is the limit, so aim for the stars! Imagine next and join the Parsons quest—APPLY TODAY!
Parsons is aware of fraudulent recruitment practices. To learn more about recruitment fraud and how to report it, please refer to[https://www.parsons.com/fraudulent-recruitment/](https://www.parsons.com/fraudulent-recruitment/).