
Data Cloud Architect
Ford Motor Company
full-time
Posted on:
Location Type: Remote
Location: Missouri • United States
Visit company websiteExplore more
Salary
💰 $158,364 - $195,946 per year
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