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 Organizations 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 the team.
• Ensure the correct first time / quality review processes are utilized and that changes maintain data integrity control processes.
• 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 : Bachelors Degree in Math, Computer Science, Quantitative Business Analysis, or closely related field

Substitutions : None

Preferred : Masters Degree in Information Technology, Mathematics / Statistics, or Operations Research

Experience

Minimum : 3 - 5 years of relevant, progressive experience

Preferred : Experience in Project Management

Licenses / Certifications

Required : None

Preferred : Lean Six Sigma

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

Strong analytical skills

Effective participation in team-based work

Additional competencies :

Energetic : The ability to find solutions and deliver results within a rapid, fast changing, entrepreneurial, technology-driven culture; Passion for technology and a positive, can-do attitude is a must.

Adaptability : Capable of adjusting to changing priorities, and possesses the ability to understand business needs to master new skills and technologies in a short period of time.

Results-Oriented and Data Driven : Must be a data driven decision maker who loves impacting the bottom line and achieves goals with available resources and abilities.

Communication (written & oral) : Must have strong interpersonal skills and the ability to establish, develop and maintain cross-functional business relationships, as well as have excellent presentation and problem-solving skills

Language (Other than English) : None

Travel Requirement : 0% - 25%

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

Disclaimer : The job description has been designed to indicate the general nature and essential duties and responsibilities of work performed by employees within this job title. It may not contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to do this job.

Compliance Requirement : This position adheres to the ethical and legal standards and behavioral expectations as set forth in the code of business conduct and company policies.

Pay Range Minimum : $50,200.00

Pay Range Maximum : $91,200.00

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