Sr Data Engineer / Data Architect

Integra Mission Critical, LLC.; United States; On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Performance rewards

Comprehensive healthcare

Life and disability insurance

Flexible benefits

Generous paid time off

Education assistance

Retirement plans

Job summary

Integra Mission Critical, LLC. is seeking a Senior Data Engineer/Data Architect to design and evolve an Azure-based Lakehouse enterprise data platform. You will architect scalable data models and drive governance, quality, and self-service analytics across ERP, CRM, HR and manufacturing domains.

The role combines strategic architecture with hands-on delivery, leveraging Fabric, Azure Databricks, Delta Lake, and Spark to optimize performance, cost, and reliability of the data platform.

Qualifications

• Bachelor's degree or equivalent professional experience.
• 8 years of experience in Data Engineering or Data Architecture.
• Proven experience designing and implementing enterprise scale cloud data platforms and modern Lakehouse architectures.
• Strong hands-on Azure data services, SQL, Python, PySpark, Spark, Delta Lake and ETL/ELT design, governance and effectiveness.

Responsibilities

• Define and maintain enterprise data architecture standards, best practices and reusable patterns that support modernization and migrations.
• Design scalable Bronze-Silver-Gold Lakehouse architectures and enterprise semantic models for reporting and self-service BI.
• Develop canonical data models spanning ERP, CRM, scheduling, manufacturing and HR domains.
• Establish standards for data integration, metadata lineage, data quality governance and security.

Skills

Azure data services

SQL

Python

PySpark

Spark

Delta Lake

Parquet

ETL/ELT

metadata driven frameworks

performance optimization

Education

Bachelor's degree in Computer Science Information Systems Data Engineering or a related discipline or equivalent professional experience

Tools

Microsoft Fabric

Azure Databricks

Spark

Delta Lake

Parquet

Job description

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 andor 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

Bachelors 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 ETLELT design metadata driven frameworks and performance optimization Practical experience with Microsoft Fabric andor 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 S4HANA 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

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

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 talentacquisitionintegracom