Data Analyst, Business Intelligence - HealthCare Partners, MSO

HealthCare Partners, IPA and HealthCare Partners, MSO together comprise our health care delivery system providing enhanced quality care to our members, providers and health plan partners. Active since 1996, HealthCare Partners (HCP) is the largest physician-owned and led IPA in the Northeast, serving the five boroughs and Long Island. Our network includes more than 10,000 primary care and specialist physicians delivering services to over 200,000 members enrolled in Commercial, Medicare and Medicaid products. Our Management Services Organization employs over 200 skilled staff professionals dedicated to ensuring practices deliver the highest quality of care to their patients while efficiently utilizing healthcare resources.

HCP’s vision is to be recognized by members, providers and payers as the organization that delivers unsurpassed excellence in healthcare to the people of New York and their communities. We pride ourselves on selecting the most qualified candidates who reflect HCP’s mission of serving our members by facilitating the delivery of quality care.

Interested in joining our successful Garden City Team? We are currently seeking a Data Analyst, Business Intelligence.

Position Summary: The Business Intelligence Data Analyst plays a pivotal role in driving data-driven decision-making processes within the organization. As an intermediate-level data analyst, this position requires a skillset with a strong proficiency in SQL, Python, VBA, SSRS reports, and Power BI. The successful candidate will possess excellent problem-solving skills, the ability to debug and troubleshoot, strong process documentation skills, and a deep understanding of data structures & algorithms.

Essential Position Functions/Responsibilities:

• Develop and maintain SQL queries to extract, transform, and load data from various sources, ensuring data accuracy and integrity.
• Utilize advanced SQL techniques to manipulate and transform large datasets efficiently.
• Design, develop, and deploy SSRS reports for business stakeholders, providing actionable insights and visual representations of data trends.
• Create and maintain interactive and visually appealing dashboards using Power BI, enabling stakeholders to explore and analyze data effectively.
• Collaborate with cross-functional teams to gather requirements and provide insights from data analysis, driving strategic decision-making processes.
• Identify trends, patterns, and opportunities for improvement through advanced data analysis techniques, such as statistical analysis and predictive modeling.
• Perform ad-hoc analysis to address specific business questions or challenges, generating actionable insights to support decision-making processes.
• Communicate findings and recommendations to stakeholders clearly and concisely, tailoring communication to both technical and non-technical audiences.
• Work collaboratively with team members and stakeholders to understand business needs, gather requirements, and ensure alignment between data analysis and business objectives.
• Other duties and special projects as assigned.

Qualification Requirements:
Skills, Knowledge, Abilities

• Strong data interpretation and critical thinking skills, with the ability to translate complex data into actionable insights.
• Solid understanding of statistical analysis techniques and their application in data analysis.
• Experience in developing and deploying SSRS reports, with a focus on creating informative and visually appealing reports.
• Strong knowledge of Power BI for creating interactive dashboards and visualizations, enhancing data-driven decision-making processes.
• Excellent communication skills, with the ability to articulate complex ideas to both technical and non-technical stakeholders.
• Ability to work independently as well as collaboratively in a team environment, demonstrating strong problem-solving skills and attention to detail.

Training/Education:

• Bachelor's degree in Computer Science, Statistics, Mathematics, or a related field, required.
• Master’s degree, preferred.

Experience:

• Minimum of two years of experience in a similar role, demonstrating proficiency in SQL, Python, VBA, SSRS reports, and Power BI.
• 3-5 years in business analytics or related field, demonstrating progressive experience in data analysis, reporting, and visualization.

Base Comp Range: $90,000 - $110,000 annual
Bonus - Up to 5% of base salary based on organizational performance

HealthCare Partners, MSO provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, HealthCare Partners, MSO complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

The above position information is intended to describe the general nature and level of work being performed by the job incumbent(s) and is not to be considered an all-encompassing description of all responsibilities, duties, and skills required.