Data Engineer

Royal Electric Company is hiring a Data Engineer embedded within its Digital Transformation team. The role builds and maintains data integrations, pipelines, and governed datasets across construction and corporate systems to support reporting, analytics, forecasting, and operational decision-making.

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

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
• ERP Systems
• MRP Systems
• Construction Management Systems
• Project Management Systems
• Capital Project Delivery
• Construction Operations
• Power BI
• Enterprise BI Platforms
• Financial Reporting Data
• Job-Cost Reporting Data
• Project-Controls Reporting Data
• Operational Reporting Data
• Enterprise Data Governance
• Data Security Practices

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
• Safety training: Getting Everyone Home Safely
• Professional & Leadership Development Training
• Skill Development Training
• Mentorship Program
• On-The-Job & Classroom Training
• Employee referral program; successful referrals can earn an incentive.

Company

• Electrical contractor for complex infrastructure and mission-critical projects
• Sacramento, California, USA
• https://www.royalelect.com/
• Founded in 1971
• 501-1000 employees

Qualifications

• 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
• Candidates must have current authorization to work in the United States without the need for present or future sponsorship
• 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
• 3-5 years of experience in data engineering, data integration, or related data platform work.

Required skills

• API Integration, Azure Data Services, CI/CD, Construction Project Management Systems, Data Governance, Data Lakehouse, Data Modeling, Data Warehousing, ERP Systems, ETL/ELT Data Pipelines, Git, MRP Systems, Microsoft Fabric, Power BI, Python, Relational Databases, SQL

Preferred skills

• Familiarity with Power BI or similar enterprise BI platforms

Experience

• 3-5 years