Overview
Since 1999, Core States Group has collaborated with clients to create a world where all environments improve everyday life. With 24 offices in the United States and Canada, the company designs, builds, and manages projects and programs across North America and has been recognized on top lists throughout the architecture, engineering, and construction (A/E/C) industry. Headquartered in West Chester, PA, Core States Group offers integrated solutions with seamless continuity, and many of the world’s most notable brands count on Core States Group to deliver compelling design and drive speed to market. The company is industry-recognized for expertise across several markets, including convenience, corporate, distributed generation, financial, grocery, housing, industrial, restaurants, retail, semiconductor, and ZEV infrastructure. For more information, visit www.core-states.com .
Summary Of Position
The
Data Engineer will be a member of the Digital Transformation team at Core States and report to the Manager of that group. The Data Engineer will be responsible for building and maintaining a Microsoft Fabric data environment and supporting analytics by developing PowerBI reports. This role involves working closely with various departments to ensure data integrity, optimize data workflows, and provide actionable insights through data visualization. The role will require the ability to understand a variety of data sources, including accounting, project management and AEC design data.
Who You Are
You are data driven and have a passion for new technologies. You are a strong communicator and collaborator. You have the ability to work as part of a team and individually on projects. You know how to manage your time. You align with our Values of Integrity, Service, Excellence, Innovation, and Inclusion.
Responsibilities
- Design, develop, and maintain a Microsoft Fabric data environment.
- Build and optimize notebooks, data pipelines and warehouses.
- Develop and maintain PowerBI reports to support business analytics.
- Collaborate with stakeholders to gather requirements and deliver data solutions.
- Write and execute validation tests to ensure data quality and integrity across all data sources.
- Provide technical support and troubleshooting for data-related issues.
- Stay updated with the latest trends and best practices in data engineering and analytics.
Qualifications
- Bachelor’s degree (or equivalent) in computer science, information technology or related field.
- Writing and deployment of Azure Data Fabric dataflows or similar, such as Fabric notebooks and pipelines or AWS equivalents.
- Understanding of structured data schemas and using SQL to read and alter data.
- Familiarity with managing data warehouses or lakehouses using the extract-transform-load process from multiple sources.
- Practice writing and executing data validation techniques to ensure quality of data.
- Proficiency in Microsoft Fabric and PowerBI.
- Strong knowledge of Python, SQL, and data modeling.
- Experience with data pipeline and workflow management tools.
- Familiarity with data warehousing concepts and best practices.
- Excellent problem-solving and analytical skills.
Team
You will work with our Innovation and Technology team and report to our Digital Transformation Manager.
Work Location:
This is a remote role in the state of PA.
Benefits
- Medical Insurance
- Paid Time Off
- Parental Leave
- Dental Insurance
- Vision Insurance
- 401(k) matching
Note: Please do not be concerned if you do not meet every requirement. At Core States we are dedicated to building a diverse and inclusive workplace, so if you are excited about this role but your experience does not align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.
This position will remain open until it is filled.
