Data Analyst II

This is a fully remote position, open to applicants in Oregon.

📋 Description

• Collaborate with business partners and departmental leadership to comprehend needs, formulate questions, and establish objectives.

• Acquire and maintain knowledge of both internal and external systems and data sources.

• Identify requirements for analysis and reporting.

• Gather and prepare data for analytical purposes.

• Construct queries to produce routine and customized reports.

• Enhance, develop, and sustain analysis capabilities, reports, dashboards, and visual reporting tools.

• Monitor data, investigate discrepancies, and communicate metric status and outcomes to leadership.

• Summarize, synthesize, visualize, and interpret data, identifying patterns, trends, changes, and anomalies.

• Implement quality assurance methods to guarantee data accuracy, reliability, and validity.

• Assist with diagnostic analytics, projection analyses on claims and utilization, trends, and risk assessments.

• Conduct research and analysis on healthcare-related data.

• Present analyses and findings to internal leaders and external stakeholders, translating complex data into actionable insights and recommendations.

• Develop documentation for models, algorithms, data products, processes, and reports.

• Contribute ideas for process, policy, and program enhancements.

• Support junior analysts.

• Act as the data-analysis point of contact and subject matter expert for the assigned team.

• Collaborate with analysts, departments, lines of business, ISBI staff, quality improvement analysts, leadership, and external partners.

• Assist with administrative data collection, dashboard data-element definitions, reporting specifications, workflow enhancements, and process improvements.

• Engage in CareOregon’s community of practice.

• Ensure the quality and integrity of data.

• Develop an understanding of data infrastructure and reporting processes.

• Create curated datasets at the department level.

• Maintain data dictionaries, business glossaries, metric definitions, and other technical documentation.

⛳️ Requirements

• A minimum of 3 years’ experience in performing data analysis activities within a healthcare environment.

• Preferred experience in reporting and analysis relevant to the area of focus.

• Familiarity with Tableau and Power BI for data blending, joining, and advanced functions.

• Knowledge of Microsoft SQL Server Management Studio (SSMS) and/or Snowflake.

• Ability to write intermediate to complex queries.

• Understanding of program evaluation methodologies and analytical strategies.

• Familiarity with basic statistics and calculations for metrics development.

• Preferred knowledge of healthcare data and healthcare data domains.

• Capacity to learn federal and state managed healthcare rules and regulations, including HIPAA.

• Advanced skills in Microsoft Word, Excel, and Outlook.

• Proficiency in Microsoft PowerPoint and Visio.

• Skilled in Tableau Desktop/Creator products and data visualization development.

• Ability to create comprehensive, thorough, and clear reports, graphs, tables, and summaries.

• Capability to gather, shape, analyze, and statistically evaluate data.

• Proficient in proposing and implementing process improvements.

• Strong communication, collaboration, interpersonal, customer service, critical thinking, prioritization, and deadline-management skills.

• Ability to work independently and in diverse teams.

• Capacity to see, read, and perform repetitive finger and wrist movements for at least 6 hours per day.

• Ability to hear and speak clearly for at least 3–6 hours per day.

🏝️ Benefits

• Bonus opportunity: 5% annual SIP target.

• Medical, dental, vision, life, AD&D, and disability insurance.

• Health savings account.

• Flexible spending account(s).

• Lifestyle spending account.

• Employee assistance program.

• Wellness program.

• Discounts.

• Supplemental benefits including voluntary life, critical illness, accident, hospital indemnity, identity theft protection, pre-tax parking, pet insurance, and 529 College Savings.

• Retirement plan with employer contributions.

• PTO.

• Paid State Sick Time.

• Paid holidays.

• Volunteer time.

• Jury duty leave.

• Bereavement leave.

• Work from home.