Data Engineer

RailPros•Irving, TX

1d•Onsite

About The Position

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.

Requirements

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

Responsibilities

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
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
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
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
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
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

Benefits

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.