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. www.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. Job Summary 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. 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. + 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. 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 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, 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 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 + 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 Enviornment(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. #MULTI 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. We are an equal opportunity employer. CareOregon considers all candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetic information, disability, or veteran status. Visa sponsorship is not available at this time.