About the company
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.
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.
Requirements
- Experience in data engineering, with a focus on data integration, pipeline development, and data governance.
- Strong skills in SQL, Python, and data modeling.
- Experience with ERP/MRP systems, project management tools, and financial systems.
- Knowledge of data warehousing concepts and data lake house architectures.
- Familiarity with APIs, scripting, and automation.
- Excellent communication and collaboration skills.
- Analytical and solutions-oriented mindset.
- Critical thinking and problem-solving abilities.
- Relationship building and influencing skills.