Data Reporting Analyst - HNAS

Job Opportunity At Highmark Inc

This job turns data into information, information into insight, and insight into business decisions. More specifically, 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 for the purposes of supporting operational excellence, management intelligence for effective decision-making, and overall tracking of organizational performance. 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.

HNAS (Health Now Administrative Services) offers flexible, cost-effective solutions for employee health benefits. HNAS is part of Highmark Health, a national blended health organization with a mission to create remarkable health experiences. Our culture is built on your growth and development, collaborating across our organization, and making a big impact for those we serve.

This role is looking for someone who has advanced level excel experience, along with some stop loss, TPA, or self funded experience in health insurance.

Essential Responsibilities

• 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.
• Develop processes, tools, and templates to enable efficient, accurate, and standardized data analyses and related deliverables; leverages automation to greatest extent possible.
• Ensure consistency and accuracy of information and reporting by identifying issues and fluctuations with core metrics / KPIs, facilitates changes, research questions, participate and / or lead process and data improvement efforts.
• Contribute to ensuring that all changes to reporting, processes, and procedures are reflected, appropriately documented, and that consistency is maintained for team.
• Maintain effective communication with internal organizations, external vendors / partners and internal staff. Structure and present complex subjects in a meaningful and comprehensible manner.
• Develop work plans to meet deadlines, accurately estimate completion dates and communicate status.
• Work closely with management to prioritize business and information needs.
• Other duties as assigned or requested.

Education

Minimum : Bachelor's Degree in Math, Computer Science, Quantitative Business Analysis, or closely related field

Preferred : Master's Degree in Information Technology, Mathematics / Statistics, or Operations Research.

Experience

Minimum : 3 - 5 years of relevant, progressive experience

Preferred : Experience in project management

Skills

Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy

Problem solving capabilities, critical thinker, able to investigate root causes and recommend solutions

Proficient to master level with Microsoft Office products including Excel, Power Point, Word, and Access

Basic understanding of SQL / querying capabilities

Experience with end-user reporting tools

Familiarity with the Software Development Lifecycle Process

Strong written and verbal communication skills

Physical, Mental Demands and Working Conditions

Position Type : Office-Based

Teaches / trains others regularly : Rarely

Travel regularly from the office to various work sites or from site-to-site : Never

Works primarily out-of-the office selling products / services (sales employees) : Never

Physical work site required : Yes

Lifting : up to 10 pounds Occasionally

Lifting : 10 to 25 pounds Rarely

Lifting : 25 to 50 pounds Never

Pay Range Minimum : $50,200.00

Pay Range Maximum : $91,200.00

Base pay is determined by a variety of factors including a candidate's qualifications, experience, and expected contributions, as well as internal peer equity, market, and business considerations.