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.
ResponsibilitiesWhat you'll 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.
Qualifications
You'll have...
- 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.
Even better, you may have...
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
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 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 Year’s 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 $86,600- 166,200.
Final determination of salary grade will be based on candidate's 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:
https://fordcareers.co/GSR
Visa 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 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-Hybrid
#LI-LA1
Top Skills
What We Do
Ford is a global company with shared ideals and a deep sense of family. From our earliest days as a pioneer of modern transportation, we have sought to make the world a better place – one that benefits lives, communities and the planet. We are here to provide the means for every person to move and pursue their dreams, serving as a bridge between personal freedom and the future of mobility. In that pursuit, our 186,000 employees around the world help to set the pace of innovation every day.
