<p>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.</p> <p>Senior Data Engineer position in Ford Pro Tech</p> <p>Data Modeling & Ecosystem Stewardship</p> <ul> <li>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. </li><li>Field Governance: Review and validate new data field requests to ensure alignment with existing structures, preventing redundancy and maintaining schema health. </li><li>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. </li><li>Data Definitions: Ensure a deep understanding of data assets by creating and maintaining comprehensive data dictionaries and metadata documentation. </li><li>Alignment: Partner with the Principal Architect to ensure all data elements comply with Ford Pro's Common Engineering Policies (CEP) and global data standards. </li></ul> <p>Data Pipeline & Integration Engineering</p> <ul> <li>Build & Optimize: Design and maintain robust data pipelines to integrate Salesforce CRM with internal and external systems using MuleSoft and GCP. </li><li>Automated Integration: Implement automated ETL/ELT processes to support Salesforce Data Cloud and other analytics platforms. </li><li>Performance: Write and optimize complex SQL/SOQL queries and scripts to support high-volume data transformation and validation. </li></ul> <p>DevOps, Quality & Technical Excellence</p> <ul> <li>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. </li><li>Validation & Testing: Conduct rigorous performance and load testing on data workflows to ensure high availability and scalability for fleet operations. </li><li>Security & Compliance: Implement data masking, encryption, and security protocols in alignment with Ford's global security and privacy standards. </li><li>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. </li></ul> <p>Data Modeling & Ecosystem Stewardship</p> <ul> <li>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. </li><li>Field Governance: Review and validate new data field requests to ensure alignment with existing structures, preventing redundancy and maintaining schema health. </li><li>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. </li><li>Data Definitions: Ensure a deep understanding of data assets by creating and maintaining comprehensive data dictionaries and metadata documentation. </li><li>Alignment: Partner with the Principal Architect to ensure all data elements comply with Ford Pro's Common Engineering Policies (CEP) and global data standards. </li></ul> <p>Data Pipeline & Integration Engineering</p> <ul> <li>Build & Optimize: Design and maintain robust data pipelines to integrate Salesforce CRM with internal and external systems using MuleSoft and GCP. </li><li>Automated Integration: Implement automated ETL/ELT processes to support Salesforce Data Cloud and other analytics platforms. </li><li>Performance: Write and optimize complex SQL/SOQL queries and scripts to support high-volume data transformation and validation. </li></ul> <p>DevOps, Quality & Technical Excellence</p> <ul> <li>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. </li><li>Validation & Testing: Conduct rigorous performance and load testing on data workflows to ensure high availability and scalability for fleet operations. </li><li>Security & Compliance: Implement data masking, encryption, and security protocols in alignment with Ford's global security and privacy standards. </li><li>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. </li></ul>