Senior Data Engineer - Cybersecurity

Ford Motor Company; United States; On-site; USD 100,000 - 193,000; Full time

Benefits offered by this job

Medical, dental, vision and Rx

Flexible family care days

Tuition assistance

Vehicle discount program

Paid time off and holidays

Paid parental leave

Job summary

Ford Motor Company is seeking a GCP Data Engineer to design, develop, and maintain a Security Data Lake and related data products on Google Cloud Platform. You will build robust data pipelines, implement data quality frameworks, and integrate security tools via APIs to centralize oversight.

The role requires 8+ years in data engineering or cloud warehousing, 5+ years on GCP, and strong Python/SQL skills. Collaboration across teams in an agile environment is essential.

Qualifications

• 8+ years of professional experience in Data Engineering, Cloud Data Warehousing, or software development.
• 5+ years of hands-on experience on Google Cloud Platform (GCP) utilizing native services.
• Proficient in Python and SQL for building and optimizing ETL/ELT pipelines.
• Excellent communication and collaboration skills in an agile environment.

Responsibilities

• Design, develop, and maintain robust data pipelines using GCP native services.
• Build and manage data quality frameworks to ensure integrity of security data assets.
• Integrate diverse data sources and security tools via APIs to centralize security oversight.
• Optimize BigQuery performance, queries, and storage costs.
• Develop, deploy, and monitor ETL/ELT pipelines using Python and SQL on GCP services.
• Implement data quality and auditing with Dataplex and centralized rules metadata configuration.
• Design and maintain API integrations to ingest security logs from various platforms.

Skills

Python

SQL

Communication

Agile methodologies

Data modeling

Education

Bachelor's degree in Computer Science, Computer Engineering, Data Science, IT, or related field

Tools

Google BigQuery

Cloud Run/Functions

Cloud Storage

Dataflow

Pub/Sub

Cribl Stream

Job description

We are looking for a skilled GCP Data Engineer to join our EPEO - Data and AI Ops team. In this role, you will play a critical part in designing, developing, and maintaining our Security Data Lake and associated data products using GCP Cloud platform.

• Design, develop, and maintain robust data pipelines using GCP native services.
• Build and manage data quality frameworks to ensure the integrity and reliability of security data assets.
• Integrate diverse data sources and security tools via APIs to centralize security oversight.
• Optimize database performance, query efficiency, and storage costs within Google BigQuery.
• (Preferred) Utilize Cribl to route, shape, and enrich incoming security telemetry and log data.
• Develop, deploy, and monitor automated data pipelines (ETL/ELT) using Python, SQL, and GCP services (such as Cloud Functions, Cloud Scheduler, and Dataflow).
• Manage and optimize schema designs, partitioning, and clustering in Google BigQuery to ensure cost-effective and high-performance querying.
• Implement and scale data quality and auditing frameworks using GCP Dataplex with centralized rules metadata configuration.
• Design and maintain robust API integrations (e.g., EAMS, TrendMicro, and other threat detection platforms) to ingest critical security logs.
• [Preferred/Good to Have] Configure and manage Cribl Stream pipelines (sources, destinations, routes, and functions) to parse, mask, enrich, and route security logs.
• [Preferred/Good to Have] Implement log reduction strategies in Cribl to optimize data ingestion and lower downstream storage costs.
• Partner with security teams to deliver actionable data products, reporting views, and tactical dashboards to prevent service outages.

Education

Bachelor’s degree in Computer Science, Computer Engineering, Data Science, Information Technology, or a related technical field (or equivalent combination of education and experience).

Experience

8+ years of professional experience in Data Engineering, Cloud Data Warehousing, or software development.

Cloud Expertise

5+ years of hands-on experience designing and implementing production-grade solutions on Google Cloud Platform (GCP), specifically utilizing native services such as Google BigQuery, Cloud Run/Functions, and Cloud Storage, Dataflow, PubSub

Programming & Querying

High proficiency in Python and advanced SQL for building, optimizing, and troubleshooting complex ETL/ELT pipelines.

Collaboration

Excellent written and verbal communication skills, with a proven ability to collaborate effectively with cross-functional teams in an agile environment.

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

This position is a salary grade 7-8 and ranges from $99,600-$192,900.

Final determination of salary grade will be based on candidate's skills and experience, and base salary will be set within the applicable range according to job scope, responsibility and competitive market value.

Visa sponsorship is not available for this position.

Candidates for positions with Ford Motor Company must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, age, sex, national origin, sexual orientation, gender identity, disability status or protected veteran status. In the United States, if you need a reasonable accommodation for the online application process due to a disability, please call 1-888-336-0660.