Overview
This role provides lead-level analyst support for data analysis and reporting activities. You will organize data from multiple sources to produce reports, dashboards, and analyses related to utilization, cost-containment, and business performance. You will generate data-driven insights to support strategic and operational decision-making, and design and deliver reporting and analytics solutions across business and healthcare domains, including claims, utilization, finance, and related areas.
Responsibilities
- Lead the design, development, and maintenance of reports, dashboards, and data solutions using SQL, Microsoft Excel, and SQL Server Reporting Services (SSRS).
- Analyze complex datasets from multiple sources to identify trends, patterns, risks, and opportunities.
- Translate business needs into reporting and analytical requirements; partner with stakeholders to deliver actionable insights.
- Oversee end-to-end data processes, including extraction, transformation, integration, validation, and quality assurance.
- Facilitate complex healthcare data analysis, including claims, pharmacy, lab, utilization, cost, and other related areas.
- Develop and maintain database objects such as queries, views, functions, and stored procedures.
- Establish and document reporting standards, processes, and best practices.
- Ensure data accuracy, integrity, and consistency through quality assurance and validation.
- Create forecasts, models, and recommendations using statistical analysis and business context.
- Organize, document, and maintain datasets and reporting workflows across multiple business areas.
- Consolidate research, analysis, and insights into clear summaries and recommendations for business leaders and stakeholders.
- Drive process improvements, automation, and standardization across reporting and analytics functions.
- Support regulatory, contractual, and enterprise reporting requirements, including state mandated submissions.
- Identify and implement enhancements or fixes to existing reports and reporting processes.
- Collaborate with cross-functional teams to define reporting requirements and maintain project/report timelines.
- Document methodologies, reporting processes, and business requirements.
- Lead and manage projects, including timeline management, requirements gathering, and high-quality deliverable execution.
- Build and maintain strong cross-functional relationships to influence data-driven decision-making.
- Support regulatory, audit, and ad hoc data requests as needed.
- Facilitate peer reviews to ensure alignment with quality standards.
- Provide training, mentoring, and support to new and existing data analysis team members.
Requirements
- At least 6 years of experience in data analysis, reporting, or healthcare analytics, or equivalent combination of relevant education and experience.
- Bachelor’s degree in finance, economics, math, business administration, information systems, or a related field.
- Analytical problem-solving skills, including the ability to interpret complex datasets, identify patterns, and translate findings into actionable insights.
- Advanced technical proficiency with SQL, relational databases, Power BI, Excel, and reporting/analytics tools including SQL Server Reporting Services (SSRS), with the ability to learn new technologies quickly.
- Experience with healthcare analytics (e.g., claims, utilization, cost containment, medical economics).
- Advanced experience working with complex datasets and providing data analysis and insights.
- Experience with healthcare utilization metrics, medical cost analysis, and performance indicators.
- Experience with predictive modeling concepts and trend forecasting.
- Process improvement and automation experience.
- Project management experience and experience providing functional guidance.
- Demonstrated ability to manage multiple priorities and deliver results in a fast-paced environment.
- Strong attention to detail, accuracy in data validation, report development, and documentation.
- Ability to work cross-functionally across a highly matrixed organization.
- Effective verbal, written, and interpersonal communication skills; ability to collaborate across teams to define requirements/business needs and present data-related findings and solutions.
- Proficiency with the Microsoft Office suite and applicable software programs.
Preferred Qualifications
- Experience with Extract, Transform, Load (ETL) tools such as SQL Server Integration Services (SSIS) and data warehousing concepts.
- Familiarity with cloud data platforms (e.g., Azure data lakes) and business intelligence (BI) tools.
- Experience supporting regulatory reporting and healthcare payer systems (e.g., QNXT or similar platforms).
- Experience with customer relationship management (CRM) systems (e.g., Salesforce).
- Managed care and/or Medicaid experience.
- Experience supporting regulatory or encounter reporting.
- Microsoft certification or similar technical credentials.
Compensation & Benefits
- Pay range: $73,102 - $142,549 / ANNUAL
- Actual compensation may vary from posting based on geographic location, work experience, education and/or skill level.
- Competitive benefits and compensation package.
Location
- Not specified in the posting.