Ford Motor Company

Data Cloud Architect

Ford Motor Company

full-time

Posted on:

Location Type: Remote

Location: MissouriUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $158,364 - $195,946 per year

Job Level

About the role

  • Provide technical stability and anchoring for a team of data scientists, data engineers, and BI specialists.
  • Design and architect highly scalable and performant data solutions on GCP, leveraging services such as BigQuery, Dataflow, Dataproc, and Cloud Storage.
  • Develop and maintain CI/CD pipelines using Tekton, ensuring automated deployments to Cloud Run and other GCP services.
  • Implement robust data governance and security policies, adhering to OIC compliance standards.
  • Develop and maintain Terraform infrastructure-as-code for consistent and repeatable deployments.
  • Collaborate with stakeholders to define and implement key performance indicators (KPIs) and metrics.
  • Oversee data modeling, data warehousing, and data lake design and implementation.
  • Champion the adoption of best practices in data engineering and data architecture.
  • Utilize GitHub for version control, code review, and collaborative development.
  • Work closely with BI specialists to create interactive dashboards and reports using Looker, Data Studio, and other BI tools.
  • Manage and mentor team members, fostering a collaborative and innovative environment.

Requirements

  • Bachelor’s degree or foreign equivalent in Computer Science, Computer Engineering, Data Engineering, Data Science or a related field and 7 years of progressive, post-baccalaureate experience in the job offered or a related occupation.
  • 7 years of experience with each of the following skills is required:
  • 1. Analyzing different Data Sources including DB2, SQL Server, Oracle and Flat files from which data is coming and understand the relationships by analyzing the source and build solution architecture.
  • 2. Application of data warehousing, data lake architectures, and advanced data modeling techniques.
  • 3. Utilizing SQL and Python programming languages for complex data processing, transformation, analysis, and automation tasks, integrated with version control (Git), CI/CD practices, and preparing data for consumption by Business Intelligence (BI) tools (Looker and Tableau).
  • 3 years of experience with each of the following skills is required:
  • 1. Using Tableau, Power BI, and IBM Cognos Analytics BI tools to develop numerous custom business intelligence reports, dashboards, and data extracts for business units/departments including Capital Markets, Secondary Markets, Quantitative Risk Management, Mortgage Subservicing, Mortgage Servicing, and Mortgage Origination.
  • 2. Creating GitHub repository to manage ETL DataStage/Informatica and PL/SQL code versions.
  • 3. Creating Python programs to parse and load complex source data into a target database.
  • 4. Using Microsoft Access, SQL, and VBA to develop databases, data queries, reports, logic statements, database business rules, and graphical user interfaces (forms) for data entry by business users.
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.****
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data engineeringdata architecturedata modelingdata warehousingdata lakeSQLPythonCI/CDTerraformdata governance
Soft Skills
collaborationmentoringleadershipcommunicationproblem-solvinginnovationstakeholder engagementteam managementanalytical thinkingbest practices adoption