Data Cloud Architect

At Ford Motor Company, we believe freedom of movement drives human progress. We also believe in providing you with the freedom to define and realize your dreams. With our incredible plans for the future of mobility, we have a wide variety of opportunities for you to accelerate your career potential as you help us define tomorrow’s transportation.

Enterprise Technology plays a critical part in shaping the future of mobility. If you’re looking for the chance to leverage advanced technology to redefine the transportation landscape, enhance the customer experience and improve people’s lives, this is the opportunity for you. Join us and challenge your IT expertise and analytical skills to help create vehicles that are as smart as you are.

What you'll be able to do:

Data Cloud Architect - positions offered by Ford Motor Company (Dearborn, Michigan). 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.

You'll have…

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.

You may not check every box, or your experience may look a little different from what we've outlined, but if you think you can bring value to Ford Motor Company, we encourage you to apply!

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.

For a detailed look at our benefits, click here:

https://fordcareers.co/GSR-HTHD (https://urldefense.com/v3/__https:/fordcareers.co/GSR-HTHD__;!!N_LtwI-RPugbI9wg0dJn!F28ynabcaKIc7ibgleTo5xmBkVxcWFIcvoVtj4f5fZAe3dztzz7RAQ_chBUN4jykXwdp7HsiPodLRds$)

Candidates for positions with Ford Motor Company must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, age, sex, national origin, sexual orientation, gender identity, disability status or protected veteran status. In the United States, if you need a reasonable accommodation for the online application process due to a disability, please call 1-888-336-0660.

#LI-DNI

#DNP

Requisition ID : 58536