Data Cloud Architect

Description

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 Big Query, 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 Git Hub 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 Git Hub repository to manage ETL Data Stage/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 $ - $/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…