Data Cloud Architect

Ford • Dearborn, MI

1d • $158,364 - $195,946 • Remote

About The Position

Note, this is a purely telecommuting/work-from-home position whereby the employee may reside anywhere within the U.S. 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. 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. We are offering a salary of $158,364.12 - $195,946.08/yr. 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 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. https://fordcareers.co/GSR-HTHD Verification of employment eligibility will be required at the time of hire.

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.
• Application of data warehousing, data lake architectures, and advanced data modeling techniques.
• 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.
• Creating GitHub repository to manage ETL DataStage/Informatica and PL/SQL code versions.
• Creating Python programs to parse and load complex source data into a target database.
• 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.

Responsibilities

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

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