Who 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