25 Sep
|
AgileGrid Solutions
|
Canada
25 Sep
AgileGrid Solutions
Canada
About Us At Gifthealth, we're revolutionizing the way people experience healthcare by simplifying the process of managing prescriptions and health services. Our mission is to provide a seamless, personalized, and efficient healthcare experience for all our customers. We're a dynamic, innovative, and customer-centric company dedicated to making a positive impact on people's lives.
About The Role We are seeking a Data Analyst II to own recurring reporting and ad hoc analysis for an assigned manufacturer program or internal domain, becoming the person who knows that program's enrollment funnel, payer quirks, fulfillment path, and data sources deeply. This position plays a key role in supporting the Data & Analytics department and reports to the Manager, Analytics & Reporting, ensuring alignment with organizational goals, operational excellence, and compliance standards.
Depth in one program or domain is prioritized over broad but shallow knowledge across multiple areas, especially in the first year. This role has no direct reports and offers an excellent opportunity for a detail-oriented analyst to make a significant impact by providing insights that drive decision-making and operational improvements.
Qualifications The ideal candidate will possess a combination of education, experience, and skills to succeed in this role:
- Education: Bachelor's degree preferred; demonstrated capability and experience are valued equally.
- Experience: Typically 2 to 4 years of experience in data analysis, with proficiency in SQL and data validation techniques.
- Knowledge, Skills, and Abilities: Ability to interpret vague questions, sharpen them into answerable queries, and communicate findings clearly. Strong validation skills,
including comparing data sources and understanding discrepancies. Comfortable explaining complex findings in simple terms to non-technical stakeholders. Experience writing complex SQL queries, including window functions and careful aggregation, with a focus on understanding data grain. Curiosity about healthcare and pharmacy operations, with a willingness to learn and adapt.
- Nice to Have: Experience with pharmacy, claims, or payer data; familiarity with dbt, Looker or LookML, Snowflake, Python, or external client reporting.
Responsibilities
- Own and develop a deep understanding of one manufacturer program or internal domain, including its enrollment funnel, payer quirks, fulfillment path, and data sources.
- Manage recurring reports scheduled weekly and monthly, ensuring accuracy and timeliness. Support daily data feeds by reviewing numbers, investigating anomalies, and raising issues proactively.
- Respond to ad hoc questions with a clear understanding of claim adjudication, prior authorization, prescription status, and fulfillment records. Provide answers with confidence and document assumptions and caveats.
- Define and document metric definitions, ensuring consistency across reporting and clarity for future reference.
- Build and maintain dashboards in Looker, with ongoing support for client-facing reports and migration from Domo. When logic belongs in the data warehouse,
submit dbt model requests for proper transformation.
- Handle Protected Health Information (PHI) carefully, adhering to HIPAA and data privacy standards. Use the minimum necessary access and seek approval before moving patient-level data to new locations.
- Collaborate regularly with account, operations teams, and manufacturer contacts. Spend time on the distribution center floor and call center to gain operational insights and ensure data aligns with real-world processes.
Advantages Gifthealth offers a comprehensive benefits package designed to support our employees’ well-being and professional growth. Employees enjoy competitive salary packages, health insurance coverage, and paid time off. We foster a collaborative and inclusive work environment with opportunities for continuous learning and development. Our flexible work arrangements, including remote options, allow team members to balance their personal and professional lives effectively. Additionally, we promote a culture of innovation, transparency, and recognition, ensuring our employees feel valued and empowered to contribute to our mission of transforming healthcare.
Equal Opportunity
Gifthealth is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. All employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, transgender status, national origin, age, disability, veteran status, or any other legally protected status. We celebrate diversity and are committed to creating an inclusive environment for all employees.
If you do not meet every requirement but believe you would be a great fit for this role, we encourage you to apply.
📌 Remote Data Analyst (Canada)
🏢 AgileGrid Solutions
📍 Canada