Lead Data Reporting Analyst (SQL)

HM Insurance Group; Pittsburgh (Allegheny County); On-site; USD 95,000 - 140,000; Full time

Job summary

HM Insurance Group in Pittsburgh is seeking a senior data analytics professional to turn data into actionable insights. You will collaborate with business stakeholders to understand information needs, analyze data, and present concise conclusions to senior leadership.

The role emphasizes guiding analytics initiatives, mentoring teammates, and driving data-driven change across the organization. Ideal candidates bring 7–10 years of experience in data analytics or business intelligence, a

Qualifications

• Bachelor's degree in Statistics, Computer and Information Science, Mathematics or Information Technology.
• 7-10 years in Data Analytics OR 7-10 years in Business Intelligence.
• Health insurance industry experience preferred; 1-3 years in Project Management; 0-1 year in Consulting.

Responsibilities

• Evaluate a need for information. Coordinate with internal areas to identify complex business problems and define outcomes.
• Lead teams to identify potential solutions and assess requirements against available tools and information.
• Gather and analyze data from necessary sources; test hypotheses and uncover patterns.
• Present conclusions to senior leadership concisely; use effective information design for various media.
• Provide direction, training to teammates; act as project manager for highly complex work.
• Other duties as assigned.

Skills

Microsoft Office

Communication Skills

Analytical Skills

Data Analysis

Statistical Analysis

Education

Bachelor's Degree in Statistics, Computer and Information Science, Mathematics or Information Technology

Job description

JOB SUMMARY

This job turns data into information, information into insight, and insight into action. The incumbent collaborates with business stakeholders to evaluate their need for information, identify potential solutions, gather and analyze data, and present conclusions in a concise and understandable format. The incumbent is expected to become intimately familiar with “the story of the business” as viewed through the lens of data, to champion the adoption of analytics as a tool for organizational change, and to serve as trusted advisors for all levels of management.

Company

HM Insurance Group

Job Description

This job turns data into information, information into insight, and insight into action. The incumbent collaborates with business stakeholders to evaluate their need for information, identify potential solutions, gather and analyze data, and present conclusions in a concise and understandable format. The incumbent is expected to become intimately familiar with “the story of the business” as viewed through the lens of data, to champion the adoption of analytics as a tool for organizational change, and to serve as trusted advisors for all levels of management.

ESSENTIAL RESPONSIBILITIES

• Evaluate a need for information Coordinate with a broad spectrum of internal customer areas to identify complex business problems. Define the required outcomes and determine the ideal path toward achieving these outcomes.
• Lead teams to identify potential solutions Evaluate new requirements against the tools, methods, and information currently available to solve the problem. Develop new tools and methods if necessary. Understand the interaction between new and existing solutions across the business.
• Gather and analyze data Extract and transform data from all necessary sources. Foster relationships with data owners and become an expert on the information available in various data repositories. Be prepared to test established hypotheses, independently discover hidden patterns, and everything in between.
• Present conclusions to senior leadership in a concise and understandable format Understand how to effectively communicate with customers in every possible medium, be it in-person conversations, phone calls, email, instant messages, presentations, or interactive dashboards. Use information design best practices to design content that is immediately understandable by the intended audience.
• Provide direction, guidance, and training to teammates with less experience. Serve as a project manager, assigning highly complex work and monitoring the accuracy and progress of the assigned work.
• Other duties as assigned.

EDUCATION

Required

• Bachelor's Degree in Statistics, Computer and Information Science, Mathematics or Information Technology

Substitutions

• None

Preferred

• None

EXPERIENCE

Required

• 7 - 10 years in Data Analytics OR
• 7 - 10 years in Business Intelligence

Preferred

• Health insurance industry experience
• 1 - 3 years in Project Management
• 0 - 1 year in Consulting

LICENSES OR CERTIFICATIONS

Required

• None

Preferred

• None

SKILLS

• Microsoft Office
• Communication Skills
• Analytical Skills
• Data Analysis
• Statistical Analysis

Language

None

Travel Required

0% - 25%

PHYSICAL, MENTAL DEMANDS and WORKING CONDITIONS

Position Type

Office-Based

Teaches / trains others regularly

Frequently

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

Rarely

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

Never

Physical work site required

Yes

Lifting up to 10 pounds

Does Not Apply

Lifting 10 to 25 pounds

Does Not Apply

Lifting 25 to 50 pounds

Does Not Apply

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 job adheres to the ethical and legal standards and behavioral expectations as set forth in the code of business conduct and company policies.

As a component of job responsibilities, employees may have access to covered information, cardholder data, or other confidential customer information that must be protected at all times. In connection with this, all employees must comply with both the Health Insurance Portability Accountability Act of 1996 (HIPAA) as described in the Notice of Privacy Practices and Privacy Policies and Procedures as well as all data security guidelines established within the Company’s Handbook of Privacy Policies and Practices and Information Security Policy.

Furthermore, it is every employee’s responsibility to comply with the company’s Code of Business Conduct. This includes but is not limited to adherence to applicable federal and state laws, rules, and regulations as well as company policies and training requirements.

Highmark Health and its affiliates prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on any category protected by applicable federal, state, or local law.

We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the email below.

For accommodation requests, please contact HR Services Online at [e-mail]

California Consumer Privacy Act Employees, Contractors, and Applicants Notice