Sr Data Engineer / Data Architect

Integra Mission Critical • Dallas, TX

4d

About The Position

The Senior Data Engineer / Data Architect designs, implements, and evolves the enterprise data platform, with a focus on a modern Azure-based Lakehouse environment that integrates data across ERP, scheduling, construction management, manufacturing, HR, CRM, and operational systems. This hands-on role establishes scalable data architecture and engineering standards, develops canonical and semantic data models, and delivers trusted data products that support ERP modernization, enterprise reporting, advanced analytics, and self-service business intelligence. The position combines strategic architecture responsibilities with direct technical contribution across Microsoft Fabric, Azure Databricks, data integration, governance, quality, lineage, observability, and platform optimization.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related discipline, or equivalent professional experience.
• 8+ years of experience in Data Engineering, Data Architecture, or a related discipline.
• Proven experience designing and implementing enterprise-scale cloud data platforms and modern Lakehouse architectures.
• Strong hands-on experience with Azure data services, advanced SQL, Python, PySpark, Spark, Delta Lake, Parquet, ETL/ELT design, metadata-driven frameworks, and performance optimization.
• Practical experience with Microsoft Fabric and/or Azure Databricks, including platform-specific Lakehouse, pipeline, orchestration, governance, and semantic modeling capabilities.
• Experience integrating data from multiple enterprise applications and business domains.
• Strong knowledge of canonical, dimensional, and star schema modeling; conformed dimensions; master data management; governance; lineage; and metadata management.
• Strong communication and stakeholder management skills, with the ability to translate business requirements into scalable technical solutions.

Nice To Haves

• Experience with Oracle Fusion ERP, Deltek Costpoint, Primavera P6, Procore, Salesforce, SAP S/4HANA, Autodesk Construction Cloud, or comparable enterprise platforms is preferred.
• Knowledge of financial and ERP, project controls, construction and engineering, or manufacturing data domains is preferred.

Responsibilities

• Define and maintain enterprise data architecture standards, best practices, and reusable patterns that support application modernization and future system migrations.
• Design scalable Bronze, Silver, and Gold Lakehouse architectures and enterprise semantic models for reporting, analytics, and governed self-service BI.
• Develop and govern canonical data models spanning ERP, CRM, scheduling, construction management, manufacturing, HR, and other operational domains.
• Establish standards for data integration, metadata, lineage, data quality, governance, security, and trusted business definitions.
• Design and implement metadata-driven ingestion and processing frameworks for structured, semi-structured, and API-based data sources.
• Build scalable ELT pipelines, Change Data Capture processes, incremental loading strategies, reconciliation controls, and audit capabilities.
• Implement monitoring, alerting, logging, observability, and operational support frameworks across the data platform.
• Optimize platform performance, scalability, reliability, storage architecture, and cloud cost management.
• Design and implement enterprise Lakehouse solutions using Microsoft Fabric and/or Azure Databricks.
• Build and maintain Delta Lake-based Bronze, Silver, and Gold data layers and develop Spark and PySpark transformation pipelines.
• Implement data quality controls, lineage tracking, governance processes, job orchestration, and reusable engineering standards.
• Evaluate platform options based on business requirements, scalability, operational considerations, and cost optimization.
• Integrate data from ERP, scheduling, project controls, construction management, manufacturing, HR, CRM, and other operational platforms.
• Define and maintain source-to-canonical mappings across enterprise applications, including Oracle Fusion ERP, Deltek Costpoint, Primavera P6, Procore, Salesforce, and comparable systems.
• Partner with business and technology stakeholders to translate requirements into scalable, supportable data solutions.
• Support ERP modernization and broader enterprise transformation initiatives through reliable data integration and architecture.
• Partner with Finance, Operations, Project Controls, and Business Intelligence teams to support enterprise reporting and analytics platforms.
• Define business metrics, KPIs, semantic models, conformed dimensions, and data standards in alignment with stakeholder requirements.
• Enable reusable, governed, and trusted data products that support self-service analytics and executive reporting.
• Improve enterprise data quality, governance, lineage, metadata management, and observability across the platform.
• Operate effectively as both an enterprise data architect and a hands-on senior engineering contributor.
• Provide technical guidance on architecture decisions, engineering practices, performance tuning, and platform reliability.
• Promote scalable patterns that reduce technical debt and support future business growth.
• Communicate technical concepts, risks, dependencies, and recommendations clearly to business and technology stakeholders.

Benefits

• Competitive pay with incentive opportunities that recognize your results and contributions.
• Medical, dental, and vision coverage that supports you and your family’s total well-being.
• Life and disability insurance programs that provide protection when it matters most.
• A variety of voluntary benefits so you can personalize coverage to fit your needs.
• Generous paid time off to relax, travel, and maintain a healthy work-life balance.
• Education assistance and tuition support to help you build skills and advance your career.
• Retirement and savings programs that help you achieve long-term financial confidence.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior