Senior Data Analyst

Pinnacle Home Care; Town of Florida (NY); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Employee referral program

Flexible scheduling

Ongoing professional development (CEUs

Job summary

Pinnacle Home Care is seeking a Senior Data Analyst to transform complex data into actionable insights. You will develop advanced SQL queries, automate data workflows in Python, and build executive dashboards using Power BI to drive strategic decisions.

Collaborating with operational, clinical, financial, and executive teams, you’ll translate business questions into measurable analyses, ensure data quality, and help establish analytics standards across the organization.

Qualifications

• 5+ years in data analytics or BI.
• Advanced SQL skills and data transformation.
• Proficiency in Python for automation.
• Experience with Power BI and dashboards.
• Experience with Snowflake or cloud data platform.
• REST APIs and JSON/CSV data handling.
• Knowledge of ETL/ELT and data pipelines.
• Git or source-control experience.

Responsibilities

• Analyze large, complex datasets to identify trends, risks, opportunities, and performance drivers.
• Develop advanced SQL queries and reusable datasets using SQL Server, Snowflake, and other enterprise data sources.
• Use Python to automate data processing, reconciliation, validation, reporting, and other repetitive workflows.
• Build dashboards and executive reporting using Power BI and related reporting tools.
• Translate business questions into clear analyses, metrics, dashboards, and recommendations.
• Combine data from databases, APIs, Excel, CSV, JSON, and cloud applications.
• Develop automated data pipelines and reporting processes.
• Validate data quality and investigate discrepancies across systems and reports.
• Partner directly with operational, clinical, financial, and executive teams.
• Identify opportunities to improve processes through better data, reporting, and automation.
• Document solutions and maintain strong development, testing, and source-control practices.
• Mentor junior analysts and help establish analytics and development standards.

Skills

Advanced SQL

Python

Analytical thinking

ETL/ELT

Problem-solving

Tools

SQL Server

Snowflake

Power BI

REST APIs

Git

Azure

Job description

Are you looking to make a difference in patients’ lives with a company that values your expertise? Join us in our mission of delivering compassionate healthcare where it matters most –– at home.

Pinnacle Home Care, Florida’s largest independent Medicare-certified home health provider, has been delivering high-quality, patient-centered care for over two decades, and we’re looking for a Senior Data Analyst to join our award-winning team.

Key Responsibilities

• Analyze large, complex datasets to identify trends, risks, opportunities, and performance drivers.
• Develop advanced SQL queries and reusable datasets using SQL Server, Snowflake, and other enterprise data sources.
• Use Python to automate data processing, reconciliation, validation, reporting, and other repetitive workflows.
• Build dashboards and executive reporting using Power BI and related reporting tools.
• Translate business questions into clear analyses, metrics, dashboards, and recommendations.
• Combine data from databases, APIs, Excel, CSV, JSON, and cloud applications.
• Develop automated data pipelines and reporting processes.
• Validate data quality and investigate discrepancies across systems and reports.
• Partner directly with operational, clinical, financial, and executive teams.
• Identify opportunities to improve processes through better data, reporting, and automation.
• Document solutions and maintain strong development, testing, and source-control practices.
• Mentor junior analysts and help establish analytics and development standards.

Qualifications

• 5+ years of experience in data analytics, business intelligence, data engineering, or a related field.
• Advanced SQL skills, including complex queries, data transformation, and performance optimization.
• Strong professional experience with Python, including data analysis and production-level automation.
• Strong experience with Power BI or comparable BI/reporting tools.
• Experience with Snowflake or another cloud data platform.
• Experience working with REST APIs and structured data such as JSON, CSV, and Excel.
• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to independently take a business problem from requirements through analysis and implementation.
• Experience with ETL/ELT, data pipelines, and automated workflows.
• Experience with Git or comparable source-control tools.
• Healthcare or home health experience preferred.
• Experience working with operational, clinical, or financial healthcare data preferred.
• Microsoft Azure and Microsoft Graph experience preferred.
• Familiarity with HIPAA and handling PHI preferred.
• Experience integrating SaaS and enterprise applications preferred.

Why Choose Pinnacle?

• Personalized, One-on-One Care: Help patients heal and regain their independence by delivering individualized care in the comfort of their homes.
• Growth & Stability: Over two decades as Florida’s largest independent home health agency.
• Ongoing Professional Development: Free Continuing Education Units (CEUs) to support licensure and career advancement.
• Competitive Benefits & Perks: Including an employee referral program where you can earn rewards.
• Recognized Excellence: Ranked as a USA Today Top Workplace.
• Flexible Scheduling: Enjoy a schedule that aligns with your personal priorities.
• Supportive & Fun Culture: Join a collaborative, forward‑thinking team that values both professional excellence and personal fulfillment.

Pinnacle promotes an inclusive environment and is an equal opportunity employer. We prohibit discrimination or harassment based on race, religion, age, gender, national origin, disability, veteran status, or other legally protected characteristics.