Overview
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.
