Data Engineer

Join Team Royal! 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. One Royal Culture Short Story We have a current opening for a Data Engineer for our Dallas Office. ROLE SUMMARY 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. Who you are: 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. 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 Salary Range: Dallas, TX: $93,000/year - $119,000/year Please note that at this time, Royal Electric is unable to provide visa sponsorship or participate in any employment-based immigration or work authorization programs. Candidates must have current authorization to work in the United States without the need for present or future sponsorship. Royal is proud to be an equal opportunity workplace. Individuals seeking employment at Royal are considered without regards to age, ancestry, color, race, gender (including pregnancy, childbirth, or related medical conditions), gender identity or expression, sexual orientation, genetic information, marital status, medical condition, mental or physical disability, national origin, protected family care or medical leave status, religion, military or veteran status, or any other characteristic protected by federal, state, or local laws. We utilize E-Verify to confirm work authorization with both the Social Security Administration and the Department of Homeland Security. E-Verify Link: We promote a drug free workplace. 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 KisxCard(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) CancerCARE1: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! #J-18808-Ljbffr