Data Engineer / Data Architect

Design, develop, and own the governed data architecture that supports all EPMO reporting, analytics, and assurance activities. Build and maintain scalable dimensional data models, including fact tables, dimensions, semantic layers, and reporting-ready datasets. Design, develop, and manage automated ETL/ELT pipelines integrating data from SAP, Primavera P6, CPCO, DAMAS, and other enterprise systems. Implement automated data refresh schedules, orchestration processes, incremental loading, monitoring, alerting, and recovery mechanisms. Lead Primavera P6 data integration, transforming schedule, WBS, resource, and cost data into analytical models. Develop calculations and models supporting schedule variance analysis, earned value reporting, critical path analysis, float analysis, and progress measurement. Establish robust data governance standards, including validation rules, reconciliation controls, lineage documentation, and audit-ready processes. Ensure all reported metrics are traceable from executive reports back to validated source systems through documented transformation logic. Design and optimize Power BI data models, datasets, measures, security structures, and reporting performance. Partner with business stakeholders, project controls teams, and analytics teams to translate reporting requirements into scalable data solutions. Support AI and analytics initiatives by preparing governed, high-quality datasets suitable for AI models, automation, and advanced analytics solutions. Utilize AI-assisted engineering, anomaly detection, and quality monitoring techniques to improve data reliability and operational efficiency.