Business Intelligence Analyst #1361

LifeWorks NW is a private, non-profit organization providing prevention, mental health, substance use treatment, and related social services to youths, adults, and older adults in over fifteen locations throughout Multnomah, Washington, and Clackamas counties. LifeWorks NW promotes a healthy community by providing quality and culturally responsive mental health and addiction services across the lifespan.

Our core values-Recovery and Relationships, Resilience, and Results-inform the work we do. The four pillars of the strategic vision include Compassionate, Impactful Care, Holistic Health, Passionate Team, and Thriving Organization. Diversity, Equity, and Inclusion are critical to successfully achieving the mission. We know that "life works" when people get the help they need and are dedicated to changing lives.

The Business Intelligence Analyst is responsible for driving the collection, analysis, and reporting of clinical and business data across our integrated care environment.  By performing data analytics, data visualization, and data modeling, this strategic role will identify emerging trends and patterns within industry, clients, and business operations to define the transformation of clinical care models and business models for improved client care, integrated health care system, and business operations for meaningful change.

As a behavioral health organization, LifeWorks NW employees are required to have had their COVID 19 vaccination (or have an approved medical/religious exemption) per State of Oregon rules. Proof of COVID-19 vaccination is required upon hire. 

Location: This position is based out of LifeWorks NW's Sylvan site. 

Pay/Benefits: $99,175 to $110,333 annual salary plus Full benefits.

Essential Responsibilities:  (Must be able to be performed with or without reasonable accommodation.)

  • Build models and analyzing data to unearth trends and patterns to address clinical care and business opportunities to drive improving client care models and business models.
  • Interpret and analyze data to discover discrepancies or to identify trends and patterns in complex data sets
  • Work closely with management, partner organizations, and internal teams to understand and maintain focus on their analytical needs, including identifying critical measures and KPIs, and deliver actionable insights to relevant decision-makers
  • Define and implement data collection and transformation logic, selecting appropriate combination of methods and tools to ensure data integrity while optimizing scalability and performance of the solution
  • Develop and maintain databases by acquiring data from primary and secondary sources, and build scripts that will make our data evaluation process more flexible and scalable across data sets
  • Present and explain information and data, communicating data interpretation and analysis, suggesting operational improvements.   Communicating information in digestible and accessible way both orally and written including creating and maintaining rich interactive visualizations which integrate various reporting components from multiple data sources
  • Uses appropriate software programs and tools, including statistical packages and programming languages to query, process, analyze, and present data and findings including required documentation
  • Strong business acumen with experience or expertise in health care operations and systems
  • Ability to handle protected health information (PHI) in a manner consistent with the Health Insurance Portability and Accountability Act of 1996 (HIPAA).
  • Exhibits an excellent attention to detail and multi-tasking ability with the capability of working independently
  • Acts professionally with a passion for assisting others and problem-solving
  • Meets performance standards set by assigned project work/objectives and organizational policies and norms.
  • Continually increases level of cultural sensitivity, awareness and competency.
  • Participates in regular individual and team meetings with manager; attends trainings, all staff, team, and other meetings as required.  

Qualifications(Equivalent education and/or experience may be substituted for qualifications.  Requirements are representative of minimum levels of knowledge, skills and/or abilities.  To perform this job successfully, the employee will possess the abilities or aptitudes to perform each task proficiently.)

  • Proven working experience as a data analyst or similar for min of 2 year; preferably 3-5years
  • Preferred experience in clinical/healthcare reporting and analytics
  • Strong SQL proficiency with the ability to learn other analytic tools
  • Technical expertise regarding data models, database design, data mining and segmentation
  • Strong knowledge of and proficiency with reporting packages (Business Objects etc), programming (XML, Javascript, or ETL frameworks)
  • Practical experience in statistical analysis through the use of statistical packages (Excel, SPSS, SAS)
  • Strong analytical skills including collection, mining, evaluation, analysis, and visualization to disseminate significant amounts of information with attention to detail and accuracy
  • Adept at queries, report writing and presenting findings
  • Experience using business intelligence tools (e.g. Tableau) and data frameworks (e.g. Hadoop)
  • Ability to work effectively on a team, and to work independently with minimal supervision. Self-motivated.  Proven success in a collaborative, team-oriented environment.
  • Demonstrates critical thinking and analytical capability; Ability to learn new technologies quickly
  • Demonstrates punctuality, accountability, and patience
  • Ability to perform under pressure, be flexible, and effectively manage workload.
  • Strong business acumen
  • Outstanding organizational and problem-solving aptitude
  • Demonstrates effective communication and presentation skills (both written and oral) and maintains a cooperative working relationship with others in a culturally diverse environment
  • Organizational agility with the ability to facilitating complex projects and project specific discussions with multiple stakeholders with diverse professional backgrounds
  • Ability to perform essential functions of job without creating a direct threat to the safety of self or others
  • BSc/BA in Mathematics, Economics, Computer Science, Information Management or Statistics
  • MBA preferred

Work Activities

Interacting with Computers - Using computers and computer systems to set up functions, enter data, or process information.

Updating and Using Relevant Knowledge - Keeping up-to-date technically and applying new knowledge to job.

Interpreting the Meaning of Information for Others - Translating or explaining what information means and how it can be used.

Making Decisions and Solving Problems - Analyzing information and evaluating results to choose the best solution and solve problems.

Getting Information - Observing, receiving, and otherwise obtaining information from all relevant sources.

Identifying Objects, Actions, and Events - Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.

Establishing and Maintaining Interpersonal Relationships - Developing constructive and cooperative working relationships with others, and maintaining them over time.

Documenting/Recording Information - Entering, recording, storing, or maintaining information in written or electronic form.

Judging the Qualities of Things, Services, or People - Assessing the value, importance, or quality of things or people.

Thinking Creatively - Developing, designing, or creating new applications, ideas, relationships or systems.

Provide Consultation and Advice to Others - Providing guidance and expert advice to co-workers and clinical team.

Communicating with Supervisors and Peers - Providing information to supervisors and co-workers by telephone, in written form, e-mail, or in person.

Communicating with Persons Outside Organization - Communicating with people outside the organization, representing the organization to clients the public, government, and other external sources. This information can be exchanged in person, in writing, or by telephone or e-mail.

Evaluating Information to Determine Compliance with Standards - Using relevant information and individual judgment to determine whether events or processes comply with laws, regulations, or standards.

Organizing, Planning, and Prioritizing Work - Developing specific goals and plans to prioritize, organize, and accomplish your work.


Computers and Electronics - Knowledge of computer hardware and software, including applications and programming.

Mathematics- Knowledge of arithmetic and statistics, and their applications.

Customer and Personal Service - Knowledge of processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services.

English Language - Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.


Reading Comprehension - Understanding written sentences and paragraphs in work related documents.

Active Listening - Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.

Critical Thinking - Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.

Complex Problem Solving - Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.

Writing - Communicating effectively in writing as appropriate for the needs of the audience.

Coordination- Adjusting actions in relation to others' actions.

Speaking- Talking to others to convey information effectively.

Judgment and Decision Making - Considering the relative costs and benefits of potential actions to choose the most appropriate one.

Social Perceptiveness - Being aware of others' reactions and understanding why they react as they do.


Oral Expression - The ability to communicate information and ideas in speaking so others will understand.

Inductive Reasoning - The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).

Problem Sensitivity - The ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing there is a problem.

Deductive Reasoning - The ability to apply general rules to specific problems to produce answers that make sense.

Written Expression - The ability to communicate information and ideas in writing so others will understand.

Equal Opportunity Employer

Drug Free/Tobacco Free Site 01/09