IT Infrastructure Cost Transparency Analyst

We made history and now we work to transform the future for our customers our communities and our families. Youll see your work on the road every day helping people move freely and pursue their dreams. At Ford you can build more than vehicles. Come build what matters.

Enterprise Technologyplays a critical part in shaping the future of mobility. If youre looking for the chance to leverage advanced technology to redefine the transportation landscape enhance customer experience and improve peoples 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.

In this position...

The IT Infrastructure Cost Transparency Analyst is part of a small team within Fords Enterprise Platforms Engineering Operations (EPEO) organization that works with Service Teams and Finance to translate EPEO service usage by customer into cost allocation forecasts and reports for the purpose of allocating IT infrastructure cost throughout the global enterprise and supporting financial planning

Based in Dearborn MI this is a hybrid position with a required four-day onsite presence each week.Relocation assistance may be available for qualified candidates.

What youll do...

• Prototype build and maintain Qlik Sense dashboards and migrate existing ones to Power BI.
• Manage and streamline data collection integration and transformation for dashboard presentation including migration of existing Alteryx flows to TBD future solution(s).
• Work with end users service teams and app portfolio owners to design and prototype Business Intelligence solutions that meet the needs of IT Service Teams Application Portfolio Owners and IT Executive Management.
• Develop and implement mechanisms to audit data integrity both upstream from data sources and downstream when presented to end users.
• Perform and build solutions analysis of data for identification of issues and opportunities with IT service consumption relative to budget and allocation of service costs to customers based on physical metrics.

Youll have...

• Bachelors Degree equivalent combination of relevant education and experience

• 3 years of dashboarding experience using Qlik Sense / Power BI or similar

• 3 years of experience collaborating using SharePoint / MS Teams tools

• 2 years of experience with data wrangling and analysis using Excel and Alteryx. Big Query is nice to have

• 2 years of business analysis experience including requirements gathering process reengineering or similar.

Even better you may have...

• Masters Degree

• Application of AI to financial management processes data processing and dashboards/ reports experience

• Project Management experience (team leadership; work management with Jira/ Rally)

• Financial Acumen (purchase orders; spend forecasting; cost allocation and billing)

• Solid written and verbal communication skills

You may not check every box or your experience may look a little different from what weve 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 builderor all of the above No matter what you choose we offer a work life that works for you including:

• Immediate medical dental vision and prescription drug coverage
• Flexible family care days paid parental leave new parent ramp-up programs subsidized back-up childcare and more
• Family building benefits including adoption and surrogacy expense reimbursement fertility treatments 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 Years Day
• Paid time off and the option to purchase additional vacation time.
  
  

This position is a salary grade of 7 or 8 and ranges from $86600- 166200.

Final determination of salary grade will be based on candidates skills and experience and base salary will be set within the applicable range according to job scope responsibility and competitive market value.

For more information on salary and benefits click here:

sponsorship is not available for this position.

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 the United States if you need a reasonable accommodation for the online application process due to a disability please call 1-.

#LI-Hybrid

#LI-LA1