Data Engineer

Ford - Dearborn, MI

Full-time - Entry Level

Dearborn, MI

Transportation Equipment Manufacturing

About the position

The Ford Data Engineer position is designed for individuals with a strong technical background who are adept at handling various aspects of data management. This role encompasses the design, implementation, and optimization of data storage solutions, as well as the manipulation of data and providing Level 2 support. As a Data Engineer, you will work closely with multiple stakeholders, including Business Customers, Product Owners, Data Tech, and IT, to translate business objectives into effective data storage solutions. The position emphasizes collaboration within small, cross-functional teams and adheres to lean and agile methodologies, ensuring the application of software best practices, quality scanning, automated testing, and continuous integration/continuous deployment (CI/CD) processes. In this role, you will be responsible for identifying, documenting, and communicating design requirements, working alongside Data Product Owners to create data stores. You will implement these data stores on Google Cloud Platform (GCP), utilizing tools such as DBT for data transformations, BigQuery for data storage, and Astronomer for orchestration. Testing is a critical component of this position, and you will participate in testing activities while adopting test-driven development practices. Additionally, you will tune data stores by optimizing indexes and SQL queries to enhance performance and provide Level 2 support by assisting with customer inquiries and resolving incidents or problems. Collaboration across teams is essential, as you will work within and across various groups to achieve project goals.

Responsibilities

• Identify, document, communicate and design per requirements.
• Work with Data Product Owners to design data stores.
• Implement data stores on GCP, using DBT for transformations, BigQuery for data store and Astronomer for overall orchestration.
• Participate in testing and adopt test driven development.
• Tune data stores (indexes, SQL queries) to improve performance.
• Assist with customer inquiries and incidents/problems as part of L2 support.
• Collaborate within/across teams.

Requirements

• Bachelor's degree in Computer Science, Computer Engineering, Electrical Engineering or related field or a combination of education and equivalent work experience.
• At least 2 years of experience in big data technologies.
• At least 1 year experience with cloud computing (AWS, Microsoft Azure, Google Cloud).
• Critical thinking and decision making skills.
• Experience in Data Architecture (Data Design, Index Design, Referential Integrity).
• Experience in DB Create/Modify (DB Create/Modify tables, DDL export/import, Data export/import).
• Experience in Performance Tuning (DB-side identification of issues, SQL tuning, DB tuning).
• Data Manipulation skills using GCP BigQuery, DBT.
• Data Pipeline Orchestration experience with Astronomer, GCP Cloud Scheduler.
• Strong communication skills, both verbal and written.

Nice-to-haves

• Prior experience coordinating on-going landing of data as a Data Steward.
• Experience with Database Replication.
• Experience in DB Create/Modify (Physical design).
• Experience in Security (FIM Groups, Ranger).
• Data Manipulation skills using GCP (Big Query, Cloud Storage, Data Proc, etc.), Terraform, Airflow.
• Data Manipulation skills related to PII (PII Policy, PII Scanning).
• Data Manipulation skills using Python.
• Experience with Streaming data (Kafka, MQTT).
• L2/L3 support experience.

Benefits

• Immediate medical, dental, and prescription drug coverage.
• Flexible family care, parental leave, new parent ramp-up programs, subsidized back-up child care and more.
• Vehicle discount program for employees and family members, and management leases.
• Tuition assistance.
• Established and active employee resource groups.
• Paid time off for individual and team community service.
• A generous schedule of paid holidays, including the week between Christmas and New Year's Day.
• Paid time off and the option to purchase additional vacation time.