Data Reporting Analyst – Mid-Level

Role Overview

• This job drives and supports all activities related to collecting, analyzing, and reporting on the Organization's key performance indicators including developing dashboards, scorecards, forecasting, trending, tracking results, and executive presentations.
• Consults with cross-functional enterprise groups and levels to identify data and analytical needs, conduct analyses, review analyses and findings with leadership, facilitate related process/data improvement efforts and develop executive level presentations.
• Prepares similar intelligence for customers and interacts with customers as such. Specifically, this role is responsible for transforming complex operational, financial, and membership data into actionable insights that inform executive decision-making across Government Programs.
• The Analyst will go beyond producing reports
• this role identifies performance drivers, qualifies risk and opportunities, and delivers clear, data-backed recommendations that improve program outcomes, financial performance, and strategic positioning.
• Work with various internal departments to collect source data, on a regular basis and as needed.
• Design and build analyses/trending/forecasting reports using Excel or other technology.
• Publish metrics dashboards and executive presentations.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Build and maintain forecasting models for membership, utilization, and financial performance.
• Develop processes, tools, and templates to enable efficient, accurate, and standardized data analyses and related deliverables.
• Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.
• Ensure consistency and accuracy of information and reporting by identifying issues and fluctuations with core metrics/KPIs.
• Collaborate with cross-functional teams (operations, finance, network, compliance) to understand business needs and translate them into analytical solutions.

Requirements

• Minimum Bachelor’s Degree in Math, Computer Science, Quantitative Business Analysis, or closely related field
• Minimum 3
• 5 years of relevant, progressive experience
• Experience in project management
• Experience in healthcare, insurance, or government programs (Medicaid, DoD, etc)
• Exposure to forecasting, or statistical modeling
• Experience working with large, complex datasets in a matrix organization.
• Lean Six Sigma (preferred)
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Proficient to master level with Microsoft Office products including Excel, Power Point, Word, and Access
• Basic understanding of SQL / querying capabilities
• Experience with BI tools such as Power BI or Tableau
• Familiarity with the Software Development Lifecycle Process
• Strong written and verbal communication skills

Tech Stack

• SQL
• Tableau

Benefits

• Health insurance
• 401(k)
• Flexible work arrangements
• Paid time off
• Professional development opportunities