Data Engineer

Royal Electric•Dallas, TX

5h•$93,000 - $119,000•Onsite

About The Position

Royal Electric Company is seeking a Data Engineer to join their Digital Transformation team in Dallas. This role is responsible for reliable data integration, scalable data pipelines, and well-governed enterprise data to support Construction Operations and corporate functions. The Data Engineer will work with various systems including ERP, MRP, project management, field mobility, scheduling, financial systems, and construction technology solutions. Key responsibilities include designing and maintaining integrations and data pipelines, strengthening data governance, improving data quality, automating data movement, and building scalable data infrastructure within a data lake house. This position is crucial for ensuring that enterprise technology investments and construction operations are supported by accurate, timely, and reliable data, thereby enabling reporting, forecasting, financial controls, and operational decision-making. The role aims to create a scalable data foundation for predictable project delivery, capital efficiency, and sustainable growth by improving integrations across enterprise systems.

Requirements

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.

Nice To Haves

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.

Responsibilities

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

Benefits

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!