Data Analyst II

CareOregon is hiring a Data Analyst II to conduct moderately complex healthcare data analysis, create reports and visualizations, and support decision-making and improvement initiatives. The role collaborates across departments, provides analytical support to stakeholders, and stewards the quality and documentation of data.

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

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
• Understanding of or ability to learn program evaluation methodologies and analytic strategies
• Understanding of basic statistics and calculations utilized for metrics development
• Ability to self-direct learning to acquire knowledge and understanding of federal and state rules and regulations related to managed health care operations (e.g., HIPAA, etc.)
• 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
• Experience with reporting and analysis in area of focus (varies by department)
• Familiarity with healthcare data and various data domains within healthcare (preferred)