IS Business Intelligence Analyst II

Career Opportunities: IS Business Intelligence Analyst II (24618)

Requisition ID 24618 - Posted 11/05/2024 - CareOregon - Full Time - Permanent - Portland - Multi Location (9)

Print Preview

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

Job Title

IS Business Intelligence Analyst II

Exemption Status

Exempt

Department

Business Intelligence

Manager Title

IS Business Intelligence Supervisor

Direct Reports

n/a

Requisition #

24618

Pay & Benefits

Estimated hiring range $88,430 - $108,080 / year, 5% bonus target, full benefits. careoregon. org/about-us/careers/benefits

Posting Notes

This is a fully remote position, but you must reside in one of the listed 9 states.

This position is responsible for curating data and producing data products from health outcomes, quality of care, operational data, financial information analysis, and/or health care utilization studies by designing and creating state of the art enterprise 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. In addition, the position is a leader when needed to identify new development and analyst tools to self-learn, build governance processes, implement, and then support other analysts on company use and adoption.

• 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.
• Build enterprise external facing dashboards with row level security applied.
• 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.

• 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 and/or Power BI
• 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 Databricks
• Experience with statistical software packages, such as Python, R or SAS
• Experience in the healthcare or health insurance industry
• Experience creating Dashboards
• Experience with Claims
• Experience with Enrollment

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 provide leadership and oversight of research and analytical projects preferred
• 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
• Abilit.