Data Engineer

The Data Engineer is a technology professional embedded within the Digital Transformation team, supporting Construction Operations and corporate functions through reliable data integration, scalable data pipelines, and well-governed enterprise data. Reporting to the DX manager, this role partners closely with IT, Construction Operations, Finance, and PMO to transform data from core business systems into trusted, accessible datasets that support reporting, analytics, forecasting, and operational decision-making.

This role supports data engineering initiatives for our data across ERP and MRP platforms, project management systems, field mobility tools, scheduling systems, financial systems, and construction technology solutions. The Data Engineer designs and maintains integrations and data pipelines that improve project visibility, reporting reliability, data availability, and digital transformation efforts across a capital-intensive construction environment.

The position plays a key role in strengthening data governance, improving data quality, automating data movement, and building scalable data infrastructure that enables enterprise growth and operational excellence through our data lake house.

Success in the position is achieved through the following duties & responsibilities:

• Construction Data Pipelines & Integration *

• Design, build, and maintain reliable data pipelines that support project managers, operations leaders, and executive reporting needs.
• Integrate data from ERP/MRP, project management, scheduling, field mobility, and financial systems into governed enterprise datasets.
• Develop and maintain transformations that standardize project, labor, cost, vendor, material, and operational data for downstream use.

• Technology & Systems Integration *

• Support data integration requirements for system implementations, upgrades, and digital transformation projects.
• Partner with application owners and vendors to define data interfaces, source-to-target mappings, and integration requirements.
• Automate recurring data movement and manual workflows through scripting, APIs, orchestration, and reusable data pipelines.

• Data Platform Engineering & Automation *

• Build and optimize data models, staging layers, and curated datasets that support enterprise analytics and reporting.
• Monitor pipeline performance, troubleshoot failures, and improve reliability, scalability, and data processing efficiency.
• Document data flows, transformations, dependencies, and technical standards to support maintainable and reproducible solutions.

• Data Governance & Quality Management *

• Collaborate with Technology teams to improve data quality, consistency, lineage, and reliability across enterprise systems.
• Support master data management initiatives across projects, vendors, materials, labor categories, and other shared business entities.
• Implement validation, reconciliation, and monitoring controls that strengthen enterprise reporting and trusted data use.

• Business Partnership & Communication *

• Work directly with Construction Operations, Finance, HR, and corporate leadership to translate business and reporting needs into data solutions.
• Partner with analysts and data consumers to deliver well-defined, accessible datasets and explain technical concepts to non-technical audiences.
• Contribute to change management and adoption efforts associated with new data integrations, reporting tools, and system enhancements.

WHY THIS ROLE MATTERS

This role is critical to ensure enterprise technology investments and construction operations are supported by accurate, timely, and reliable data. The Data Engineer strengthens the integration between technology systems and field execution by building trusted data pipelines that enable reporting, forecasting, financial controls, and operational decision-making.

By improving integrations across enterprise systems, this role creates a scalable data foundation for predictable project delivery, capital efficiency, and sustainable growth.

• Strive to be great- You’re eager to build and master your skills by seeking out - applying - training and new experiences. You’re willing to work smart, take initiative, and take on challenges with a tenacious and resourceful attitude.
• Fun & Friendly - You like people, have a sense of humor, and enjoy what you do.
• Analytical and Solutions-oriented - You’re skilled at identifying challenges and opportunities, developing practical solutions, and ensuring projects stay on track to meet their goals.
• Critical Thinker - You’re willing to be innovative, challenge yourself, and try new things.
• Relationship Builder - You work to build trust and relationships at all levels, cultivating collaboration, shared success, and mutual respect.
• Influencer - You’re an inspiration to others, capable of guiding actions, decisions, and strategies. You recognize other people’s underlying needs and motivations and can navigate individual and group perspectives.

Requirements

Required

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field.

• 3-5 years of experience in data engineering, data integration, or related data platform work.

• Proficiency in SQL and Python for data transformation, automation, and troubleshooting.

• Experience building ETL/ELT data pipelines, integrating APIs, working with relational databases, and implementing modern data engineering practices in Data Warehouse or Lakehouse environments.

• Experience with Microsoft Fabric, Azure-based data services, or similar cloud-based data platforms.

• Experience in data modeling and designing scalable data structures to support analytics, reporting, and business intelligence solutions.

• Strong problem-solving skills with attention to data quality, reliability, and documentation.

• Experience using Git and CI/CD practices for managing and deploying data engineering solutions.

Preferred

• Experience working with ERP, MRP, or construction/project management systems.

• Exposure to capital project delivery environments or construction operations.

• Familiarity with Power BI or similar enterprise BI platforms.

• Experience supporting financial, job-cost, project-controls, or operational reporting data.

• Knowledge of enterprise data governance and security practices.

CORE COMPETENCIES

• Enterprise Data Engineering

• ERP & Systems Integration

• Data Pipeline Development & Automation

• Cloud Data Platforms & SQL

• Data Modeling & Transformation

• Data Quality, Governance & Reliability

• Cross-Functional Collaboration

• Problem Solving & Technical Rigor

SUCCESS METRICS

• Improved reliability and availability of enterprise data pipelines

• Faster access to trusted data for Construction and Technology teams

• Reduction in manual data movement and reconciliation efforts

• Improved integration across ERP, project, financial, and field systems

• Improved enterprise data quality, lineage, and reporting consistency

• Demonstrated contribution to scalable analytics and operational efficiency, Analysis Skills, Application Programming Interface (API), Automation, Business Intelligence, Business Solutions, Capital Project, Change Management, Channel Strategies, Childcare, Cloud Computing, Coaching, Computer Science, Construction, Construction Management, Construction Support, Consulting, Continuous Deployment/Delivery, Continuous Integration, Cross-Functional, Customer/Client Research, Data Lake, Data Management, Data Modeling, Data Processing, Data Quality, Data Sets, Data Structures, Data Warehousing, Database Extract Transform and Load (ETL), Database Report Tools, Dental Insurance, Documentation, ERP (Enterprise Resource Planning), Electrical Design, Embedded Systems, Enterprise Application Integration (EAI), Finance, Financial Control, Financial Operations, Financial Systems, Flexible Spending Accounts, Forecasting, Genetics, Git, Health Plan, Healthcare, Healthcare Software, Homeland Security, Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), Insurance, Leadership, Master Data Management (MDM), Medical Conditions, Medical Office Administration, Mentoring, Metrics, Microsoft Windows Azure, Military, Operational Audit, Operational Support, Orthodontics, Performance Analysis, Pharmacy, Power BI, Problem Solving Skills, Project Control, Project Schedule, Project Tracking, Project/Program Management, Psychiatry and Mental Health, Python Programming/Scripting Language, Quality Management, Reconciliation, Relational Databases (RDBMS), Reliability Engineering, SQL (Structured Query Language), Scalable System Development, Social Security Administration, System Integration (SI), Systems Administration/Management, Systems Reliability, Technical Support, Technical/Engineering Design, Telehealth, Time Management, Training Data Sets, Tuition Reimbursement, Vendor/Supplier Relations, Vision Plan

• Health Care Plan (3 types of Medical plans, Discounted Dental & Orthodontist services for adults & children, Premium Vision Plan)
• Retirement Plan (Traditional 401k, Roth 401k).
• $50k Life Insurance (Basic, Voluntary, & AD&D)
• Paid Time Off (Vacation, Sick Leave, and 8 Paid Holidays)
• Family Leave FMLA (Maternity & Paternity)
• Short Term & Long-Term Disability
• Pet Insurance
• Flex Spending Accounts: Healthcare, Dependent care (Daycare children & elderly - work related), & Transit
• Pharmacy discounts
• Kisx Card (Surgery & Imaging Program)
• Opportunity for tuition reimbursement

Wellness Resources

• Free telehealth
• Health Joy App
• Free peer coach support - (mental health, stress management, substance use, and suicidal ideation)
• CancerCARE 1:1 Consulting and support with expert medical team
• Employee Assistance Support
• Hearing Aid discount plan
• Laser VisionCare discount plan

Learning & Development

• Safety training: Getting Everyone Home Safely
• Professional & Leadership Development Training
• Skill Development Training
• Mentorship Program
• On-The-Job & Classroom Training

Employee Referral Program: We value referrals from our employees! If you know someone who would be a great fit for this role, please refer them through our company’s referral program. Successful referrals can earn you an incentive!

Why Royal? At Royal Electric Company we provide expert electrical design, construction, and service with builders, contractors and facility owners who value relationships, trust, expertise, and a commitment to each other towards achieving exceptional results. We believe in transforming the culture of construction, creating a space where everyone feels they belong. We are proud to support initiatives like “Breaking Barriers,” showcasing the incredible contributions of women in our industry. Breaking Barriers: Women At Work Episode 1

We are able to sustain this through our linking values of expertise, collaboration, integrity, passion, and loyalty. These values support our core purpose; to build great relationships, one project at a time!

We believe in taking care of our team. From comprehensive wellness programs to continuous learning opportunities, we invest in your growth and well-being.