ETL Developer – Construction (1862)

About the job
NOTE: HYBRID work model, 3 days/week onsite (initially more for first month for stakeholder engagement).

Type: 6 Month Contract (with potential extension), 8 hours/day, 40 hours/week

Work Experience: 5–10+ years ETL Developer / Data Engineering, SQL, Microsoft Fabric, Data Pipelines, Power BI, API Integration

Industry: Construction / Infrastructure

DESCRIPTION:

Design, develop, and maintain ETL processes within Microsoft Fabric and OneLake to build a centralized Common Data Environment (CDE)
Build scalable data pipelines to consolidate and standardize data from multiple enterprise systems into a single source of truth
Perform development lifecycle tasks, including:
Analyze and understand multiple data sources (e.g., Procore, Autodesk, Sage ERP, SharePoint, scheduling and safety systems) to design effective data integration strategies
Develop ETL/ELT solutions from scratch, integrating data via REST APIs and automated ingestion pipelines
Implement medallion architecture (Bronze, Silver, Gold) to manage raw, cleaned, and business-ready datasets
Design and implement master data models and common identifiers to eliminate duplication and ensure cross-system consistency
Build, optimize, and manage data models that support reporting and analytics
Design, develop, and maintain Power BI dashboards and semantic models to ensure consistent metric definitions
Implement data validation, quality checks, and exception reporting to ensure data integrity and trustworthiness
Configure and manage data security, access control, and governance using Microsoft/Azure identity and sensitivity labeling
Schedule, orchestrate, and automate ETL jobs and pipelines
Promote ETL processes and data models across environments
Document ETL pipelines, data models, architecture, and governance processes
Be proactive in providing status updates, effort estimates, and identifying risks impacting delivery
Collaborate with internal stakeholders (architects, analysts, BIM teams, IT, and business users) to gather requirements and deliver data solutions
Participate in evaluating and implementing new data technologies within the Microsoft ecosystem
Contribute to preparing the data platform for AI and Copilot adoption by ensuring trusted, governed data

REQUIREMENTS:

Bachelor’s degree in Computer Science, Engineering, or related field
5–10+ years of hands-on experience as an ETL Developer / Data Engineer in a data platform or data warehouse environment
Strong experience building centralized data platforms or single source of truth solutions
Technical expertise in:
Microsoft Fabric (Data Factory, OneLake, Lakehouse, Warehouse concepts)
ETL / ELT pipeline development and orchestration
SQL (advanced querying, transformations, performance tuning)
Python / PySpark for data processing and transformation
REST API integration and automated data ingestion
Medallion architecture (Bronze, Silver, Gold layers)
Data modeling (star schemas, semantic models, master data management)
Power BI (DAX, dashboard development, publishing, semantic layer design)
Strong understanding of:
Data integration, data quality, and data validation frameworks
Data governance, security, and Azure identity/access management
Designing common identifiers to link datasets across systems
Converting business requirements into scalable data pipelines
Ability to work independently in a consulting environment with minimal supervision
Ability to manage multiple priorities and deliver under pressure

NICE TO HAVE:

Microsoft Purview or similar data governance tools
Experience preparing data platforms for AI / Copilot integration
Familiarity with hub-and-spoke architecture patterns
Experience integrating ERP, finance, or project management systems
Knowledge of ISO 19650 and construction/BIM data practices
Microsoft certifications (Fabric Analytics Engineer, Power BI Data Analyst)

KEY OBJECTIVE:

To design and deliver a scalable, governed ETL framework within Microsoft Fabric that consolidates data from multiple construction business systems into a trusted single source of truth, enabling reporting, analytics, and future AI initiatives.

As part of our hiring process, we use AI‑based systems to support initial applicant screening.

TO APPLY: https://directitrecruiting.com/job/data-analyst-construction-1862/