Data Analyst II

CareOregon • WFH (Oregon), OR

1d • $74,250 - $90,750 • Remote

About The Position

The Data Analyst II ensures the highest standards of data management and analysis activities for use in decision making and improvement initiatives within the assigned area of operations. The role is responsible for conducting moderately complex data analysis and report creation, collaboration across departments, and data stewardship. Specific duties and areas of focus vary by department.

Requirements

• Minimum 3 years’ experience performing data analysis activities in a healthcare environment
• Knowledge of or ability to gain expertise in the operations of assigned department (goals, metrics, workflows, policies, etc.)
• Familiarity with business intelligence platforms such as Tableau and Power BI for data blending, joining, and other advanced functions to implement complex business logic
• Familiarity with Microsoft SQL Server Management Studio (SSMS) and/or Snowflake and ability to write intermediate to complex queries
• Familiarity with healthcare data and various data domains within healthcare (preferred)
• Advanced skill with Microsoft Word, Excel and Outlook
• Proficient with Microsoft PowerPoint and Visio
• Proficient with Tableau Desktop/Creator products and develop data visualizations
• Strong ability to prepare reports, graphs, tables and other summarizations that are complete, thorough and easily understood by intended audience
• Strong ability to gather and analyze data
• Ability to shape data for analysis purposes
• Strong understanding of program evaluation methodologies and analytic strategies
• Ability to perform statistical analysis and math utilized for metrics development
• Ability to propose and implement process improvements
• Excellent interpersonal, collaboration and customer service skills
• Strong spoken, written and listening communication skills
• Strong ability to clearly articulate and communicate requirements, metrics and methodologies to IS Business Intelligence team members and other departments
• Strong ability to customize presentations and data visualizations to communicate technical information to a variety of audiences (e.g., technical, non-technical, senior leadership, external audiences, etc.)
• Critical thinking skills and ability to critically evaluate information gathered from multiple sources
• Ability to take the initiative, work independently and as part of a team
• Ability to set and meet deadlines, prioritize competing projects, and resolve barriers to meeting project requirements; collaborate with others to ensure accountability for deadlines
• Ability to continually learn and adapt to the rapidly changing analytic and reporting needs
• Ability to work effectively with diverse individuals and groups
• Ability to learn, focus, understand, and evaluate information and determine appropriate actions
• Ability to accept direction and feedback, as well as tolerate and manage stress
• Ability to see, read, and perform repetitive finger and wrist movement for at least 6 hours/day
• Ability to hear and speak clearly for at least 3-6 hours/day

Nice To Haves

• Experience with reporting and analysis in area of focus (varies by department)
• Understanding of or ability to learn program evaluation methodologies and analytic strategies
• Understanding of basic statistics and calculations utilized for metrics development

Responsibilities

• Collaborate with business partners (and department leadership as needed) to understand business needs, define the questions, and define the objectives of the assigned department.
• Learn and maintain a strong understanding of internal and external systems and data sources as needed (specific needs vary by department).
• Identify current and emerging analysis and reporting needs.
• Employ moderately complex data collection methods and prepare data for analysis.
• Write moderately complex queries to create routine and customized reports.
• Improve, augment and develop new analysis capabilities (e.g. methodologies, reports, etc.) as needed.
• Develop simple to moderately complex analysis and visual reporting capabilities and tools (e.g., recurring reports, dashboards, etc.); maintain and improve dashboards.
• Monitor data and keep leadership informed of any anomalies, output or results needing research, and the status of metrics; provide status reports.
• Summarize and report data as appropriate (e.g., frequency distributions, measures of central tendency, measures of variability, pivot tables, etc.).
• Explore data to uncover any patterns, trends, unexpected changes or outliers.
• Synthesize data (i.e., combine, integrate and evaluate data).
• Employ quality assurance methods and procedures to ensure accuracy, reliability and validity of synthesized data.
• Learn and assist in use of diagnostic analytics methods as needed (e.g., probability theory, regression analysis, filtering, and time-series analysis, etc.) to identify, understand and respond to anomalies in the data.
• Assist in preparation of projection analyses on claims and utilization, including underlying trends and risk analysis.
• Perform research and analysis of healthcare-related data.
• Create data visualizations (e.g., PowerPoint, graph, tables, etc.) and narrative formats as appropriate to convey meaning with clarity.
• Provide basic to intermediate level analytics and statistical support to translate complex data into meaningful information for decision makers.
• Present analyses and findings to internal leaders and external stakeholders; translate complex data into meaningful insights and recommendations with clarity and concision.
• Create documentation as needed for models, algorithms, data products, processes, reports developed, etc.
• Contribute ideas for ways to improve processes, policy and programs.
• May participate in project meetings as needed.
• Support less experienced analysts in all aspects of the role.
• Serve as a key point of contact and partner related to data analysis within assigned team; act as subject matter expert for questions related to department data.
• Partner with other analysts, departments and lines of business to collaborate on reports, share data and information, and assist as needed to meet the needs of the organization.
• Collaborate with ISBI staff to improve administrative data collection, define data elements for the reporting dashboards, and finalize reporting specifications.
• Support collaboration with department leadership, quality improvement analysts, and others to implement workflow and other process improvements.
• Actively participate in CareOregon’s community of practice to share knowledge and contribute to the learning of others.
• Depending on the assigned department, may engage with external partners for technical assistance or support as needed.
• Ensure the quality and integrity of data and data management practices.
• Develop and maintain deep understanding of the data, data infrastructure and processes used for reporting department metrics and for measuring operational and/or program performance.
• Create department-level curated data sets for consumption by others within the assigned team.
• Create and maintain technical documentation such as data dictionaries, business glossaries, metric definitions and other data resources.

Benefits

• Competitive pay
• Bonus opportunity
• Medical insurance
• Dental insurance
• Vision insurance
• Life insurance
• AD&D insurance
• Disability insurance
• Health savings account
• Flexible spending account(s)
• Lifestyle spending account
• Employee assistance program
• Wellness program
• Discounts
• Multiple supplemental benefits (e.g., voluntary life, critical illness, accident, hospital indemnity, identity theft protection, pre-tax parking, pet insurance, 529 College Savings, etc.)
• Strong retirement plan with employer contributions
• PTO accrual
• Paid State Sick Time accrual
• Paid holidays
• Volunteer time
• Jury duty leave
• Bereavement leave
• 401(k) contributions (for non-benefits eligible employees)
• Paid State Sick Time (for non-benefits eligible employees)
• Wellness and employee assistance program benefits (for non-benefits eligible employees)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed