Cloud Data Architect/Data Engineer

At Ford Motor Company, we believe freedom of movement drives human progress. We also believe in providing you with the freedom to define and realize your dreams. With our incredible plans for the future of mobility, we have a wide variety of opportunities for you to accelerate your career potential as you help us define tomorrow's transportation.

Creating the future of smart mobility requires the highly intelligent use of data, metrics and analytics. That's where you can make an impact as part of our Global Data Insight & Analytics team. We are the trusted advisers that enable Ford to clearly see business conditions, customer needs and the competitive landscape. With our support, key decision makers can act in meaningful, positive ways. Join us and use your data expertise and analytical skills to drive evidence-based, timely decision making.

The Data & Analytics Product Group under FCSD Tech seeks a Senior Data Engineer for its Data Orchestration product line. Key responsibilities include:

• Designing and modernizing big data solutions on Google Cloud Platform (GCP)

• Leading large-scale implementations of data warehouses, data lakes, and analytics platforms

• Architecting solutions using a combination of GCP native services and third-party technologies

The ideal candidate will have:

• Extensive experience with GCP data services (e. g. , BigQuery, Dataflow, Dataproc)

• Proven track record in designing and implementing cloud-based data architectures

• Strong skills in data modeling, ETL/ELT processes, and big data technologies

• Expertise in data security and governance on cloud platforms

This role requires a dynamic, results-oriented individual with broad technical knowledge and the ability to design scalable, efficient data solutions in a cloud environment

What you'll do.

• Develop and implement a comprehensive data strategy, design data models, and establish data architecture standards to ensure data integrity and accessibility across the organization

• Gather business requirements and design ETL systems to meet application needs, translating these into scalable data solutions on Google Cloud Platform (GCP)

• Work closely with stakeholders to gather requirements and provide technical guidance on the migration process from legacy systems to GCP

• Collaborate with data engineering teams to understand existing JCL/ETL jobs and their dependencies, designing migration strategies for moving ETL to GCP native services

• Architect, design, and implement large-scale data processing systems and data pipelines optimized for scaling on GCP, ensuring reliability and performance

• Lead effort estimation for new developments and enhancements, delivering product features as part of the roadmap and business needs

• Co-create test plans and lead execution and code deployment, including performance tuning to optimize job execution

• Troubleshoot and resolve production issues or challenges that arise during migration and ongoing operations

• Implement data quality and governance procedures to ensure the accuracy and reliability of data

• Validate, run, schedule, and monitor jobs using appropriate tools and platforms

• Debug and resolve ticketing issues in the production phase

• Stay current with industry trends and GCP's evolving services, continuously improving data architecture and processes

Additional Responsibilities

• Establish data security measures and ensure compliance with relevant regulations

• Collaborate with cross-functional teams, including business analysts, data scientists, and IT teams, to align data architecture with organizational objectives

• Design and implement data integration processes and APIs to facilitate seamless data flow between systems

• Evaluate and recommend appropriate database management systems and data storage solutions for optimal performance

• Develop and maintain documentation for data models, architecture frameworks, and best practices

You'll have.

• Bachelor's degree in Computer Science or related field OR a combination of education and experience

• 8+ years of Data Engineering experience

• Experience in design, development and implementation of data pipelines using Data Warehousing applications

• Experience in integrating various data sources like Oracle, Teradata, DB2, Big Query & Flat files

• Hands on experience in performance tuning and debugging ETL jobs

• Involving in review meetings and coordinating with the team in job designing and fine-tuning the job performance

• Extensive experience in designing and implementing cloud-based data architectures

• Extensive experience in data modeling, ETL/ELT processes, and big data technologies

• 5+ years of Cloud experience (GCP preferred) with solutions designed and implemented at production scale

• Strong understanding of key GCP services, especially those related to data processing [Batch/Real Time] Big Query, Cloud Scheduler, Airflow, Postgres, Data Flow, Pub/Sub, Cloud Logging and Cloud Monitoring

• Experience with infrastructure as code Terraform/ GitHub

Even better, you may have…

• Proven experience in data engineering [GCP Native ETL tools preferred]

• Strong knowledge of ETL processes, data integration and data management

• Proficiency in programming languages such as SQL, Python or Java

• Familiarity with cloud computing platforms and data storage solutions

• Excellent problem solving skills and ability to work independently as well as team player

• Professional Certification in GCP (e. g. , Professional Data Engineer)

• Experience in Mainframe to GCP migration considered plus

• Agile Methodology Practitioner

You may not check every box, or your experience may look a little different from what we've outlined, but if you think you can bring value to Ford Motor Company, we encourage you to apply!

As an established global company, we offer the benefit of choice. You can choose what your Ford future will look like: will your story span the globe, or keep you close to home? Will your career be a deep dive into what you love, or a series of new teams and new skills? Will you be a leader, a changemaker, a technical expert, a culture builder…or all of the above? No matter what you choose, we offer a work life that works for you, including:

• Immediate medical, dental, vision and prescription drug coverage

• Flexible family care days, paid parental leave, new parent ramp-up programs, subsidized back-up child care and more

• Family building benefits including adoption and surrogacy expense reimbursement, fertility treatments, and more

• Vehicle discount program for employees and family mem.