Sr Data Engineer / Data Architect

Location: DFW

Department: DEPADM

The Opportunity

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.

What you will do?

Enterprise Data Architecture

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

Data Engineering & Platform Delivery

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

Lakehouse Engineering

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

Enterprise Systems Integration

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

Analytics Enablement & Data Governance

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

Technical Leadership & Delivery Standards

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

Required Qualifications

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

Preferred Qualifications

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

How we support you

We believe your best work happens when you feel supported - professionally, personally, and financially. That’s why we offer a range of benefits designed to help you thrive, stay healthy, and plan for the future.

• Performance-driven rewards – Competitive pay with incentive opportunities that recognize your results and contributions.

• Comprehensive healthcare – Medical, dental, and vision coverage that supports you and your family’s total well-being.

• Security and peace of mind – Life and disability insurance programs that provide protection when it matters most.

• Flexible benefits options – A variety of voluntary benefits so you can personalize coverage to fit your needs.

• Time to recharge – Generous paid time off to relax, travel, and maintain a healthy work-life balance.

• Investing in your growth – Education assistance and tuition support to help you build skills and advance your career.

• Planning for the future – Retirement and savings programs that help you achieve long-term financial confidence.

Come build with us

At Integra, we’re driven by a vision to transform the data center industry. We specialize in delivering optimized turnkey solutions that bring together speed, quality, and reliability - helping our clients build and operate the mission-critical infrastructure that powers today’s digital world. Integra is a vertically integrated company - owning and managing every phase of the process from site selection and design to manufacturing, procurement, commissioning, and warranty. This approach allows us to move faster, solve challenges more efficiently, and deliver exceptional outcomes for our partners.

What truly sets Integra apart is our people. We are a team of problem-solvers, engineers, builders, and operators who thrive on tackling complex challenges and delivering results. Our culture values collaboration, accountability, and continuous improvement - because in a rapidly evolving digital landscape, excellence and adaptability matter.

Joining Integra means being part of a company that is shaping the future of data center infrastructure. If you’re passionate about innovation, impact, and building systems the world depends on, you’ll find the opportunity to grow and make a difference here.

Equal Opportunity Statement

Integra provides equal employment opportunities for all people. No employee or applicant for employment will be discriminated against because of race, creed, origin, marital status, sexual orientation, age, otherwise qualified disabled or veteran status or any other characteristic protected by law. If you are a qualified applicant who requires reasonable accommodation to complete a job application, pre-employment testing, a job interview or to otherwise participate in the hiring process, please contact [email protected]