Senior Data Engineer, CRM

Ford • Dearborn, MI

12h • Onsite

About The Position

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

Requirements

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

Nice To Haves

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

Responsibilities

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

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level