Sr BI Report Developer

Who we are

Community Health Plan of Washington is an equal opportunity employer committed to a diverse and inclusive workforce. All qualified applicants will receive consideration for employment without regard to any actual or perceived protected characteristic or other unlawful consideration.

Our commitment is to:

·       Strive to apply an equity lens to all our work. 

·       Reduce health disparities. 

·       Become an anti-racist organization. 

·       Create an equitable work environment. 

About the Role

Responsible to deliver actionable data insights needed to provide equitable access to health services for our members and improve the health of our communities. In this role you have a potential for influence and growth as we transform our data into actionable insights to continue to fuel the growth and expansion of our services.  This role is expected to build strong partnerships with business stakeholders and technical teams to deliver high-quality BI solutions that drive business decisions and actions. 

To be successful in this role, you:

• Have a minimum of five (5) years’ experience in developing dashboards, analytics, reports, and extracts in a business intelligence environment.
• Have experience in data analytics and/or programming tools such as Snowsight, Tableau, Power BI, Jupyter, and languages (Python, JAVA, SQL)
• Have experience writing and maintaining extract, transform, and load processes (ETL) using tools such as Snowflake Pipelines, Streams, Javascript, and Python.
• Have experience in health care industry, managed care health plan preferred.

Essential functions and Roles and Responsibilities:

• Work with business stakeholders and BSA to understand and consult on analytical solutions and level of effort estimates.
• Work cross-functionally with Data warehousing teams to understand existing datasets and identify data sources needed to support the business and ensure reporting is accurate and consistent across teams.
• Develop BI solutions such as pipelines, dashboards, and self-service tools to analyze and present data using tools such as Snowsight, Tableau, PowerBI, Jupyter notebooks, and languages such as Python.
• Apply standard operating procedures for analysis, design, prototyping, and development using agile methodologies.
• Perform integration testing of BI solutions to identify errors in programming logic and verify compliance with user specifications.
• Track development life cycle and document solutions using project and document management tools such as Atlassian Jira and Confluence
• Source control BI solutions using Git and remote systems such as Atlassian Bitbucket
• Contribute to cross-team discussions and workshops on design and architecture.
• Support system administration of BI tools such as Tableau, PowerBI, and programming environments such as Python
• Other duties as assigned.
• Essential functions listed are not necessarily exhaustive and may be revised by the employer, at its sole discretion.

Knowledge, Skills, and Abilities:

• Ability to communicate effectively at all levels of the organization.
• Ability to analyze, reconcile, evaluate/interpret, and recommend solutions.
• Ability to lead and participate in code reviews.
• Ability to develop BI solutions using Agile/SCRUM methodologies.
• Knowledgeable in administering and monitoring BI tools.
• Knowledgeable in SQL, Python, and modern analytical tools
• Perform all functions of the job with accuracy, attention to detail and within established timeframes.
• Demonstrate professional courtesy to others and ability to maintain confidentiality.

As part of our hiring process, the following criteria must be met:

• Complete and successfully pass a criminal background check.

Criminal History: includes review of criminal convictions and probation. CHPW does not automatically or categorically exclude persons with a criminal background from employment. The applicant’s criminal history will be reviewed on a case-by-case basis considering the risk to the business, members, and/employees.

• Has not been sanctioned or excluded from participation in federal or state healthcare programs by a federal or state law enforcement, regulatory, or licensing agency.
• Vaccination requirement (CHPW offers a process for medical or religious exemptions)
• Candidates whose disabilities make them unable to meet these requirements are considered fully qualified if they can perform the essential functions of the job with reasonable accommodation.

Compensation and Benefits:

The position is FLSA Non-Exempt (Exempt) and is (not) eligible for overtime. Based on market data, this position grade is 69 (see full range below) and has a 10% annual incentive target based on company, department, and individual performance goals.

CHPW offers the following benefits for Full and Part-time employees and their dependents: 

•  Medical, Prescription, Dental, and Vision
•  Telehealth app
•  Flexible Spending Accounts, Health Savings Accounts
•  Basic Life AD&D, Short and Long-Term Disability
•  Voluntary Life, Critical Care, and Long-Term Care Insurance
•  401(k) Retirement and generous employer match
•  Employee Assistance Program and Mental Fitness app
•  Financial Coaching, Identity Theft Protection
•  Time off including PTO accrual starting at 17 days per year.
•  40 hours Community Service volunteer time
•  10 standard holidays, 2 floating holidays
•  Compassion time off, jury duty

Sensory/Physical/Mental Requirements:

Sensory*:

• Speaking, hearing, near vision, far vision, depth perception, peripheral vision, touch, smell, and balance.

Physical*:

• Extended periods of sitting, computer use, talking and possibly standing
• Simple grasp, firm grasp, fine manipulation, pinch, finger dexterity, supination/pronation, wrist flexion
• Frequent torso/back static position; occasional stooping, bending, and twisting.
• Some kneeling, pushing, pulling, lifting, and carrying (not over 25 pounds), twisting, and reaching.

Mental:

• Frequent decision-making. Ability to gather and assess data, determine appropriate actions, apply protocols and knowledge to unique situations, problem-solve and provide consultation.

Work Environment:

Office environment Employees who frequently work in front of computer monitors are at risk for environmental exposure to low-grade radiation.