Data Analyst II

Data Analyst II --------------------------------------------------------------- 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.

Estimated Hiring Range: $74,250.00 - $90,750.00

Bonus Target: Bonus - SIP Target, 5% Annual

Priority will be given to candidates residing in Oregon and Southwest Washington.

Current CareOregon Employees: Please use the internal Workday site to submit an application for this job. --------------------------------------------------------------- Essential Responsibilities

Data Analysis 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. Data Collaboration 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. Data Stewardship 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. Experience and/or Education Required Minimum 3 years’ experience performing data analysis activities in a healthcare environment Preferred Experience with reporting and analysis in area of focus (varies by department) Knowledge, Skills and Abilities Required

Knowledge 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 business intelligence platforms such as Tableau and Power BI for data blending, joining, and other advanced functions to implement complex business logic Understanding of or ability to learn program evaluation methodologies and analytic strategies Understanding of basic statistics and calculations utilized for metrics development Familiarity with healthcare data and various data domains within healthcare (preferred) Skills and Abilities 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 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 Working Conditions Work Environment(s): ☒ Indoor/Office ☐ Community ☐ Facilities/Security ☐ Outdoor Exposure Member/Patient Facing: ☒ No ☐ Telephonic ☐ In Person Hazards: May include, but not limited to, physical and ergonomic hazards Equipment: General office equipment Travel: May include occasional required or optional travel outside of the workplace; the employee’s personal vehicle, local transit or other means of transportation may be used. Work Location: Work from home We offer a strong Total Rewards Program.

This includes competitive pay, bonus opportunity, and a comprehensive benefits package. Eligibility for bonuses and benefits is dependent on factors such as the position type and the number of scheduled weekly hours. Benefits-eligible employees qualify for benefits beginning on the first of the month on or after their start date. CareOregon offers medical, dental, vision, life, AD&D, and disability insurance, as well as health savings account, flexible spending account(s), lifestyle spending account, employee assistance program, wellness program, discounts, and multiple supplemental benefits (e.g., voluntary life, critical illness, accident, hospital indemnity, identity theft protection, pre-tax parking, pet insurance, 529 College Savings, etc.). We also offer a strong retirement plan with employer contributions. Benefits-eligible employees accrue PTO and Paid State Sick Time based on hours worked/scheduled hours and the primary work state. Employees may also receive paid holidays, volunteer time, jury duty, bereavement leave, and more, depending on eligibility. Non-benefits eligible employees can enjoy 401(k) contributions, Paid State Sick Time, wellness and employee assistance program benefits, and other perks. Please contact your recruiter for more information. We are an equal opportunity employer CareOregon is an equal opportunity employer. The organization selects the best individual for the job based upon job related qualifications, regardless of race, color, religion, sexual orientation, national origin, gender, gender identity, gender expression, genetic information, age, veteran status, ancestry, marital status or disability. The organization will make a reasonable accommodation to known physical or mental limitations of a qualified applicant or employee with a disability unless the accommodation will impose an undue hardship on the operation of our organization.