Data Analyst II

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

📋 Description

• Collaborate with business partners and department leadership to understand business requirements, formulate questions, and set objectives.

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

• Identify needs for analysis and reporting.

• Gather and prepare data for analytical purposes.

• Construct queries to generate standard and tailored reports.

• Develop and sustain analytical capabilities, reports, dashboards, and visual reporting tools.

• Monitor data, detect anomalies and trends, and keep leadership updated.

• Summarize, synthesize, and ensure the quality of data.

• Assist with diagnostic analytics, projection analyses, claims and utilization analyses, and risk analysis.

• Conduct research and analysis of healthcare-related data.

• Create data visualizations and narratives to effectively communicate findings.

• Provide analytical and statistical support for decision-makers.

• Present analyses and recommendations to both internal leaders and external stakeholders.

• Document models, algorithms, data products, processes, and reports.

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

• Support less experienced analysts.

• Act as a data-analysis point of contact and subject matter expert.

• Collaborate with analysts, departments, lines of business, and ISBI staff on reporting and data initiatives.

• Aid in workflow and process improvements.

• Participate in CareOregon’s community of practice.

• Ensure data quality and integrity.

• Create curated datasets and maintain data dictionaries, business glossaries, metric definitions, and other technical documentation.

⛳️ Requirements

• At least 3 years of experience in data analysis activities within a healthcare setting.

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

• Knowledge of or capacity to acquire expertise in the operations of the assigned department.

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

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

• Ability to write intermediate to complex SQL queries.

• Understanding of program evaluation methodologies and analytic strategies.

• Basic understanding of statistics and calculations necessary for metrics development.

• Preferably familiar with healthcare data and related domains.

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

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

• Proficient in Microsoft PowerPoint and Visio.

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

• Ability to perform statistical analysis and mathematics for metrics development.

• Capability to see, read, and engage in repetitive finger and wrist movement for a minimum of 6 hours/day.

• Ability to hear and speak clearly for at least 3–6 hours/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.

• Paid time off (PTO).

• Paid State Sick Time.

• Paid holidays.

• Volunteer time.

• Jury duty leave.

• Bereavement leave.

• Work from home.