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
  <