Job Description

Candidates hired for remote positions must reside in Oregon, Washington, Utah, Idaho, Arizona, or Nevada.

Job Title

IS Business Intelligence Analyst II

Exemption Status

Exempt

Department

Business Intelligence

Manager Title

IS Business Intelligence Supervisor

Direct Reports

n/a

Requisition #

23577

Pay and Benefits

Estimated hiring range $87,140 - $105,435 / year, 5% bonus target, full benefits. To learn more about our benefits please visit www.careoregon.org/about-us/careers/benefits

Job Summary

This position is responsible for curating data and producing data products from health outcomes, quality of care, financial information analysis, and/or health care utilization studies by designing and creating state of the art Tableau dashboards and by automating data pipelines and analysis methods. The core function of this position is to build robust data products for analytical consumption to support actionable decision making by end users and reduce the need for ad-hoc analysis requests. The position collaborates closely with subject matter experts to gather requirements from users, design solutions, and use Tableau and automation skills to develop, test, and deploy data products.

Essential Responsibilities

• Collaborate with subject matter experts to identify opportunities for building repeatable data products.
• Gather requirements and design solutions.
• Expertly utilize visualization tools such as Tableau to build dashboards compliant with design standards.
• Expertly utilize SQL skills for identifying and shaping data for developing solutions.
• Utilize automation and general programming skills to automate data pipelines and handsfree operations of data products.
• Understand and codify algorithms and models developed by Healthcare Analysts.
• As appropriate, create new algorithms and analysis models and codify them.
• Prepare reports, graphs, tables, and other summarizations that are complete, thorough, and easily understood by those receiving and/or reviewing the information.
• Create user and testing documentation for data products.
• Create and maintain technical documentation such as data dictionaries, business glossaries, metric definitions, and other data resources.
• Update and maintain legacy reporting assets developed in SQL Server Reporting Server as needed.
• Provide follow-up support for end users after training.
• Effectively collaborate with other teams within the organization to develop strong data pipelines and reusable data products.
• Remain current with technology and the latest analytical methods; continually learn new skills.
• Contribute and actively participate in community of practice and other related analytic committees and workgroups to improve skills and capabilities of all analysts at CareOregon.
• Participate in code reviews and other activities to ensure the high standard of quality is maintained.
• Work towards becoming a subject matter expert in CareOregon analytic tools and applications to provide testing and support for our analytic community.

Organizational Responsibilities

• Perform work in alignment with the organization\'s mission, vision and values.
• Support the organization\'s commitment to equity, diversity and inclusion by fostering a culture of open mindedness, cultural awareness, compassion and respect for all individuals.
• Strive to meet annual business goals in support of the organization\'s strategic goals.
• Adhere to the organization\'s policies, procedures and other relevant compliance needs.
• Perform other duties as needed.

Experience and/or Education

Required

• Minimum 3 years\' business intelligence experience that includes some or all of the following:

• Use of analytical techniques including segmentation and data mining
• Creating Tableau dashboards
• SQL object development and automation
• Creating reports using SSRS
• Engaging both technical and non-technical stakeholders
• (Note: master\'s or bachelor\'s degree in computer science, data analytics, or related technical areas may be acceptable in lieu of 1 year experience)

Preferred

• Experience in planning, implementing, and summarizing complex analyses and reporting projects
• Experience with Snowflake
• Experience with statistical software packages, such as Python, R or SAS
• Experience in the healthcare or health insurance industry

Knowledge, Skills and Abilities Required

Knowledge

• Understanding of data warehousing, reporting automation and data visualization
• Expert understanding of Tableau Desktop/Creator products and SQL
• Knowledge of agile development processes
• Knowledge of Managed Care preferred
• Knowledge of Medicaid and/or Medicare programs preferred
• Knowledge of financial matters in the health care industry preferred
• Knowledge of medical and/or pharmacy claims preferred

Skills and Abilities

• Ability to independently gather, compile and analyze data using statistical methods
• Skill in developing high quality data visualizations
• Skill in developing data products
• Skill in automation of analysis tasks using general purpose programming language such as Python, PowerShell, etc.
• Skill in shaping data for analysis purposes
• Ability to follow standards for data architecture and database design
• Strong spoken, written and listening communication skills
• Excellent customer service skills
• Ability to clearly articulate policies and instructions.
• Ability to convey appropriate level of detail effectively to all levels of the organization including non-technical staff
• Strong critical thinking skills
• Possess a high degree of initiative and motivation
• Ability to manage multiple tasks
• Ability to effectively collaborate with coworkers, staff, and leaders across all departments
• 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

\xe2\x98\x92 Indoor/Office \xe2\x98\x90 Community \xe2\x98\x90 Facilities/Security \xe2\x98\x90 Outdoor Exposure

Member/Patient Facing: \xe2\x98\x92 No \xe2\x98\x90 Telephonic \xe2\x98\x90 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.

#Li-Remote

Candidates of color are strongly encouraged to apply. CareOregon is committed to building a linguistically and culturally diverse and inclusive work environment

Veterans are strongly encouraged to apply.

Equal opportunity employer. This company considers all candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.

CareOregon