Provide data and analytical support to Michigan Program Portfolios
Support individual programs and clients, providing regular reports and responding to ad-hoc data requests
Develop and maintain mid-level Power BI dashboards and reports, including establishing and managing data connections with SharePoint-based files to ensure automated refreshes
Leverage custom coding (DAX, or other scripting as needed) to optimize data models and deliver tailored visualizations
Manage program and portfolio data and conduct complex analysis to ensure program success
Communicate data to internal and external stakeholders and respond to client requests
Ensure data accuracy, completeness, integrity, and security using best practices and tools
Balance and prioritize scheduled reports with ad-hoc requests using independent judgment
Collaborate with Operations Support and Program Management to communicate data projects and brainstorm solutions to delivery challenges
Develop new reports to track program performance and support Program Managers in delivering to program KPIs
Provide analysis beyond established reports and contribute to a culture of continuous improvement
Perform project/process management (including IT projects/tickets) and related work as needed
Requirements
Must reside in Michigan
3-5 years relevant experience
High School diploma or GED required
Bachelor's degree required
Develop and maintain mid-level Power BI dashboards and reports
Establish and manage data connections with SharePoint-based files to ensure automated refreshes and reliable performance
Leverage custom coding (DAX, or other scripting as needed) to optimize data models and implement calculated measures
Manage program and portfolio data and conduct complex analysis
Communicate data by providing regular reports and responding to ad-hoc data requests for multiple programs and stakeholders
Ensure data is accurate, complete, and utilize best practices and tools for data integrity and security
Exercise independent judgement in balancing and prioritizing scheduled data requests and ad-hoc requests
Collaborate with Operations Support and Program Management teams
Project and/or process management experience (IT projects/tickets) as needed
Sponsorship is not available for this position
Successful hires must pass pre-employment checks
Benefits
Medical, Dental, and Vision Insurance
Company-paid health care concierge service to help navigate our health plan to make the best decisions for you and yours
401(k) with company match
Paid vacation, sick, personal and parental leave time
Paid Volunteer Time
Employee Recognition Program – convert your recognition points into gift cards
Employee Assistance Program – offers benefits to help you manage daily responsibilities
Access to on-demand training courses to advance further in your career
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Power BIDAXdata analysisdata modelingreport developmentdata visualizationdata integritydata securityproject managementprocess management
Soft skills
communicationindependent judgmentcollaborationprioritizationproblem-solvinganalytical thinkingattention to detailadaptabilitytime managementcontinuous improvement