Data Engineer

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

Required Education and Experience:

• Bachelor’s degree in computer science, information systems, data engineering, or related field
• 2 to 5 years of experience in a data engineering or related role
• Experience working with financial data including GL transactions, P&L, and balance sheet data from one or more ERP or accounting platforms (e.g., NetSuite, Deltek Ajera, QuickBooks, or similar)
• Knowledge of core financial data concepts: chart of accounts, cost centers, project based accounting, period end close cycles, and financial statement structures
• Hands on experience integrating data from multiple source systems, including legacy or acquired platforms
• Expert in SQL and data modeling (star/snowflake)
• Hands on experience with ETL/ELT tools and modern data integration techniques
• Proficiency in Python for data processing and automation
• Experience with cloud data migrations to/from Azure, AWS, etc
• Exposure to CI/CD pipelines
• Experience with relational databases and cloud based data platforms
• Experience with data visualization tools, e.g., PowerBI, Tableau, Qlik, etc

Why RailPros? Build Your Career Where Culture Leads The Way

• A People First Culture (Caring): At RailPros, you’re more than an employee; you’re part of a team driven by genuine care and respect. Our Align29 pillar of Caring reflects our deep commitment to supporting your growth, well being, and success every step of the way.
• A Workplace Where Your Voice Matters (Sharing): Our Sharing culture encourages transparency, active dialogue, and collaboration across every level of the company.
• A Company Invested in Your Growth (Progress): Through continuous improvement of our systems, processes, and operations, our Progress pillar ensures you have the tools and support to excel.
• An Innovative, Industry Leading Environment (Innovation): Our Innovation pillar fuels creative problem solving, modern technology adoption, and breakthrough thinking that positions RailPros as a leader in the rail and transit space.

Benefits & Perks:

• Comprehensive Health Insurance: Includes medical, dental, and vision coverage.
• Additional Coverage Plans: Accident plan, critical illness plan, and hospital indemnity with employee to family coverage.
• Legal Shield, ID Shield, Pet Insurance: Added protection for you...and your pets.
• Life & Disability Insurance: Employer provided coverage with additional voluntary options available.
• Retirement Savings: 401(k) plan with employer match includes pre and post deduction options.
• Paid Time Off (PTO): With carryover each year.
• Paid Holidays: For full time employees.
• Wellness Programs: Access to wellness initiatives and resources.
• Discount Programs: Exclusive discounts on products and services.
• Company Merchandise Allowance: Company funded allowance for our online store.
• Health Savings Accounts (HSA): With employer match.
• Health Reimbursement Arrangement (HRA): Employer funded.
• Flexible Spending Accounts (FSA): For dependent care expenses.
• Employee Assistance Programs (EAP): Support for personal and professional challenges.
• Professional Development: Opportunities for training and career growth.
• Balanced Work Environment: A culture that respects boundaries so employees can recharge and bring their best selves to work.
• Tuition Reimbursement: Support for continued education or professional development.
• Professional & Career Growth: Through mentorship, continuous training, career path partnerships, goal setting, and succession planning.
• Culture & Recognition: Employee spotlights, annual Service Excellence Awards, alignment committee, philanthropy opportunities, company events, monthly new hire calls, monthly newsletters, feedback surveys, and quarterly town halls.

Choose a career where your work truly matters. At RailPros, you’ll be part of a stable, growing industry and a team driven by strong core values. We collaborate, innovate, and stay ahead of industry changes to deliver exceptional service to our clients. Our culture is built on trust, continuous improvement, and practical problem solving.

If you’re passionate about making an impact and want to grow with a dedicated, supportive team, join us and contribute to our success.

Equal Employment Opportunity (EEO)

RailPros provides equal employment opportunities to all qualified candidates, regardless of race, religion, color, national origin, citizenship, sex, sexual orientation, gender identity, age, veteran status, disability, genetic information, or any other protected characteristic. We are committed to making reasonable accommodations for known physical or mental limitations unless doing so would impose undue hardship. For accommodation requests, contact peopleoperations@railpros.com.