IT Infrastructure Cost Transparency Analyst

Ford Motor • Dearborn, MI

7d • Hybrid

About The Position

We made history and now we work to transform the future – for our customers, our communities and our families. You'll 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 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 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. In this position... The IT Infrastructure Cost Transparency Analyst is part of a small team within Ford’s 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.

Requirements

• Bachelor’s 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.

Nice To Haves

• Master’s 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

Responsibilities

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

Benefits

• 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 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
• Number of Employees: 5,001-10,000 employees