IS Business Intelligence Analyst II - Portland, United States - CareOregon

Description

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 #

23995

Pay & Benefits

Estimated hiring range $ 8 7, 135 - $10 5 , 435 / year, 5% bonus target, full 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.

Required

Experience and/or Education

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
Experience with creating reports in Power BI.
Experience with Claims, Enrollment etc.

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 provide leadership and oversight of research and analytical project 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
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

☒ 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.

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.

Visa sponsorship is not available at this time.

#J-18808-Ljbffr