Data Engineer

Job DetailsJob Location: Irving, TX 75038Position Type: Full TimeEducation Level: 4 Year DegreeTravel Percentage: Up to 10%Job Shift: DayJob Category: ITWho We Are:

RailPros is the premier provider of engineering and diversified safety services to America's rail and transit industry. Driven by a passion for our people, clients, and communities, we are committed to solving our customers' challenges and earning their trust through teamwork, continuous improvement, and service excellence. As a people first organization, we prioritize the safety, well being, and growth of our employees, fostering a culture of caring and support. We believe that when our people thrive, our company thrives.

Our mission is to enhance mobility, safety, and quality of life for residents, passengers, and partner companies. We do more than just provide services; we are constantly innovating and staying informed of industry developments to help our customers succeed. Join us in our shared goal of keeping America moving and ensuring customer satisfaction in an environment where your contributions are valued and your growth is encouraged. Apply now and become a part of our exciting journey!

 

Job Summary:

The Data Engineer supports the design, build, and maintenance of the data infrastructure that supports the organization’s analytics and reporting ecosystem. This role focuses on building and maintaining scalable data pipelines, managing complex integration processes, and ensuring that data remains available, accurate, and high quality across the enterprise. The role plays a key part in M&A data integration assisting with data mapping and transformation. By applying solid technical expertise and a problem solving mindset, the Data Engineer contributes to reliable, high performance analytics and empowers the business with trusted data.

 

Essential Duties & Responsibilities:

Data Pipeline Development & Maintenance


Build, maintain, and optimize ETL/ELT pipelines to support data ingestion, transformation, and delivery from multiple sources
Automate data workflows to ensure efficiency, scalability, and reliability
Monitor and troubleshoot data pipeline issues, ensuring system resilience and minimal downtime
Develop repeatable integration patterns and frameworks to accelerate post acquisition data onboarding
Collaborate with data analytics stakeholders to streamline the data acquisition, processing, and presentation process
Perform any necessary data mapping, data lineage activities and document information flows


Data Architecture & Warehousing


Collaborate with analytics teams to implement and maintain scalable data warehouse solutions (e.g., star and snowflake schemas)
Support implementation of modern data architectures, including medallion/lakehouse frameworks
Partner with Finance, Ops, IT, and HR teams to integrate new data sources into the warehouse
Assess and rationalize data models from acquired entities, mapping, and harmonizing schemas to enterprise standards


Data Quality & Governance


Ensure data accuracy, consistency, and security across systems
Implement monitoring and validation processes to detect and resolve data quality issues
Support data governance initiatives, including metadata documentation and compliance with organizational standards
Support data quality controls and reconciliation processes for merged datasets during M&A integrations


Data Visualization


Support the creation and maintenance of dashboards and reports through collaboration with data analysts and decision makers to ensure pipelines are optimized, validated, and performant


Collaboration & Support


Work closely with Data Analysts and BI teams to optimize data models for reporting and analytics
Provide technical expertise on SQL, Python, and data modeling best practices
Partner with business stakeholders to understand data requirements and deliver solutions that support decision making
Support cross functional teams during M&A activities to support data discovery, gap analysis, and integration planning
Continuously enhance your domain knowledge of connected vehicle data, connected services and algorithms/models developed by data scientists within Ford
Stay current on the latest data engineering practices and contribute to the technical direction of the company while keeping a customer centric approach


Professional Standards & Expectations


Contribute to a positive, inclusive, and respectful workplace culture, free from behaviors that undermine morale, productivity, or organizational values
Uphold the organization’s standards of integrity, accountability, and respect in all duties and interactions
Adhere to all company policies, procedures, and applicable laws and regulations
Other duties as assigned or required to meet the business needs

QualificationsRequired Education and Experience:


Bachelor’s degr