
IT Infrastructure Cost Transparency Analyst
Ford Motor Company
full-time
Posted on:
Location Type: Hybrid
Location: Dearborn • Missouri • United States
Visit company websiteExplore more
Salary
💰 $86,600 - $166,200 per year
Tech Stack
About the role
- 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.
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.
- 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.
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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Qlik SensePower BIAlteryxExceldata wranglingdata analysisBig Querybusiness analysisrequirements gatheringprocess reengineering
Soft Skills
communication skillscollaborationleadershipdata integrity auditingproblem identificationopportunity analysisfinancial acumen
Certifications
Bachelor’s DegreeMaster’s Degree