Sr. Data Engineer

We are the movers of the world and the makers of the future. We get up every day, roll up our sleeves and build a better world -- together. At Ford, we’re all a part of something bigger than ourselves. Are you ready to change the way the world moves?

Enterprise Technology plays a critical part in shaping the future of mobility. If you’re looking for the chance to leverage advanced technology to redefine the transportation landscape, enhance the customer experience and improve people’s lives, this is the opportunity for you. Join us and challenge your IT expertise and analytical skills to help create vehicles that are as smart as you are.

This job is posted as HYBRID, and requires up to 3 days a week from our Dearborn, MI office.

Visa sponsorship is NOT available for this position.

We are looking for a Sr. Data Engineer with strong experience in transformation projects to take on an anchor role in our company’s large-scale transformation initiative. The ideal candidate will build upon the existing analytical data, including merging historical data from legacy platforms with data ingested from new platforms, drive data engineering pipelines, ensuring integration across various systems, building data products to support reporting and dashboard requirements, and removing architectural roadblocks to support a smooth transformation. You will be responsible for deep-dive analysis of Current State Receivables and Originations data in Datawarehouse, as well as impact analysis related to DCDS modernization and providing solutions for implementation.

What you'll do…

This isn't just another data engineering role; it offers a unique opportunity to contribute significantly to a large-scale data transformation. You'll build a future-ready data ecosystem by integrating data from numerous systems and working with cross-functional teams, using cutting-edge cloud technologies. Collaborate with diverse teams, expand your cloud and modern data engineering skills, and make a high-impact contribution. This dynamic and challenging role offers unparalleled professional growth.

Design, Develop and optimize scalable, reliable data solutions to deliver reusable patterns using Google Cloud Platform (GCP) services: Big Query, Dataflow, DataForm, Astronomer, Data Fusion, DataProc, Cloud Composer/Air Flow, Cloud SQL, Compute Engine, Cloud Functions, Cloud Run, Artifact Registry, GCP APIs, Cloud build and App Engine, and real-time data streaming platforms like Apache Kafka, GCP Pub/Sub.

• Collaborate with stakeholders to define data requirements and ensure alignment with business goals.
• Perform comprehensive current & future state analysis, data mapping, impact analysis, root cause analysis, and data lineage activities to maintain data integrity and traceability.
• Implement and promote an enterprise data governance model emphasizing data protection, sharing, reuse, quality, and standards.
• Create and maintain clear documentation for processes and systems.
• Employ best practices and participate in CI/CD processes for frequent code delivery, Monitor systems, troubleshoot issues, and provide production support.
• Continuously enhance DCDS domain expertise, stay current on data engineering best practices, and contribute to the company's technical direction. 
   

 

Required

• Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent experience).
• 5+ years of experience in data engineering, with a focus on data warehousing and ETL development.
• 5+ years of SQL development experience.
• 2+ years of GCP experience with solutions designed and implemented at production scale.
• GCP Professional Data Engineer certification or equivalent training
• Proven experience in designing and implementing enterprise-level data solutions in a regulated environment.
• Strong understanding of data security, governance, and compliance best practices.
• Excellent analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Understanding of relevant data privacy and security regulations (e.g., GDPR, CCPA).
• Experience with B2B integrations

Preferred

• Experience in Testing – manual or automated
• Experience in Dealer Management Systems domain
• Knowledge of STAR standards
• Bachelor's degree in Computer Science or a related field of study.
• Experience with Teradata migrations a plus.
• Proven ability to design, build, and optimize high-performance data pipelines using modern tools and technologies.
• Strong understanding of data security, governance, and compliance; experience implementing best practices