Senior Data Engineer, CRM

Job Description

As a Senior Data Engineer, you will be a key individual contributor responsible for building, maintaining, and governing the data architecture that powers Ford Pro’s commercial ecosystem. You will translate architectural blueprints into scalable data solutions while serving as the primary steward of our data integrity. This role requires a hands-on engineer who excels at data modeling, ETL/ELT development, and the proactive management of data flows between Salesforce, MuleSoft, and our cloud environments.

Responsibilities

Data Modeling & Ecosystem Stewardship

• Manage the Data Model: Act as the primary maintainer of the Data Model Entity Relationship Diagram (ERD), ensuring it accurately reflects the evolving state of Salesforce and integrated systems.
• Field Governance: Review and validate new data field requests to ensure alignment with existing structures, preventing redundancy and maintaining schema health.
• Data Flow Mapping: Track and document end-to-end data flows across the ecosystem (Salesforce, MuleSoft, GCP) to provide a clear "source of truth" for data lineage.
• Data Definitions: Ensure a deep understanding of data assets by creating and maintaining comprehensive data dictionaries and metadata documentation.
• Alignment: Partner with the Principal Architect to ensure all data elements comply with Ford Pro’s Common Engineering Policies (CEP) and global data standards.

Data Pipeline & Integration Engineering

• Build & Optimize: Design and maintain robust data pipelines to integrate Salesforce CRM with internal and external systems using MuleSoft and GCP.
• Automated Integration: Implement automated ETL/ELT processes to support Salesforce Data Cloud and other analytics platforms.
• Performance: Write and optimize complex SQL/SOQL queries and scripts to support high-volume data transformation and validation.

DevOps, Quality & Technical Excellence

• CI/CD Management: Work with the DevSecOps team to oversee the end-to-end release lifecycle for data products using DevOps tools like Copado and GitHub.
• Validation & Testing: Conduct rigorous performance and load testing on data workflows to ensure high availability and scalability for fleet operations.
• Security & Compliance: Implement data masking, encryption, and security protocols in alignment with Ford’s global security and privacy standards.
• Community Leadership: Contribute to the Salesforce Community of Practice (CoP) by sharing reusable engineering patterns and advocating for "clicks-not-code" data solutions where appropriate.

Qualifications

You’ll have...

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field (or equivalent experience).
• 5+ years of experience in data engineering, with a focus on enterprise-scale CRM or cloud platforms.
• 5+ years of proven expertise in Data Modeling and maintaining complex Entity Relationship Diagrams (ERDs).
• 3+ years strong proficiency in SQL (GCP/BigQuery) and at least one programming language (Python, Java, or Apex).
• 3+ years experience with data visualization and observability.
• Hands-on experience with Salesforce data structures (Objects, SOQL, SOSL) and Salesforce Data Cloud.
• Experience building and monitoring RESTful API integrations and web services.
• Experience with CI/CD pipelines and version control systems (GitHub, Copado, or similar).

Even better, you may have...

• Experience with MuleSoft Anypoint Platform for data orchestration and API management.
• Salesforce certifications (e.g., Salesforce Data Cloud Consultant, Platform Developer I).
• Google Cloud Professional Data Engineer certification.
• Experience navigating data governance and compliance within a large, global enterprise.
• Strong analytical skills with the ability to translate complex business requirements into technical data specifications.

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

For a detailed look at our benefits, click here: Benefit Summary

This role is on-site in Dearborn, MI, you will be required to be in office 4x week.

• Visa Sponsorship is NOT provided for this specific role*
• Relocation assistance is NOT provided for this specific role*

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 committed to a culturally diverse workforce. 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.