Salary: $68,858.00 - $81,802.00 Annually
Location : Walla Walla, WA
Job Type: Full Time
Job Number: 2024-001457
Department: INST. RESEARCH & EFFECTIVENESS
Opening Date: 08/06/2024
Closing Date: Continuous
Join our team to help inspire all students to discover their potential and achieve their goals by providing relevant, equitable, and innovative learning opportunities and services.
Description

Walla Walla Community College (WWCC) is seeking applicants for a Business Intelligence Analyst position at the Walla Walla campus.
At Walla Walla Community College, we inspire all students to discover their potential and achieve their goals by providing relevant, equitable, and innovative learning opportunities and services. We have identified three core themes that describe the fundamental aspects of the College's mission by translating it into practice: Student Success, Strong Communities, and Resource Stewardship. As an organization, we value learning opportunities, a sense of community, diversity, health and humor, excellence, integrity, teamwork, innovation, personal and professional growth, and sustainability.
General Description:
The Business Intelligence Analyst will be a key team member in the department of Institutional Research and Effectiveness (IRE). The department supports the college's mission and commitment to student learning and success by providing quality, accessible, reliable, and relevant information to facilitate decision-making and planning processes, enhance institutional effectiveness, and promote a culture of evidence-based inquiry and supports the institution at all levels including stakeholders both within and outside of the college.
This position works collaboratively with Business Systems Analysts, Technology Services, and other stakeholders under the direction of the Director of Institutional Research and Effectiveness to transform college data into meaningful information through interactive data visualizations, dashboards, and other reports. The position acts as a translator by communicating difficult, technical concepts to a non-technical audience, using the appropriate analytical tools.
The position is 50% grant funded through Sept 30, 2029 and will be fully institutionalized and funded by the college by the close of the grant cycle.
Essential Functions:
Data Visualization

• Generates clear, compelling, and accessible visualizations allowing users to generate insights using tools such as Tableau or Power BI.
• Adapts the visualization format based on the needs and comprehension levels of multiple audiences, from operational staff to executive leadership.

Strategic Analysis

• Interprets data and offers recommendations to the Director of Institutional Research and Effectiveness and other stakeholders.
• Collaborates closely with multiple departments to identify opportunities for process improvement and reporting.
• Reports on institutional and grant key performance indicators.
• Produces and presents reports on student success (e.g., credit accumulation, retention, and completion), demographics, educational interventions, and other subjects as required. Reports may require the use of advanced statistical analysis and require comparison between cohorts based on specific variables.

Data Management

• Handles raw data in various formats, including SQL, CSV, etc.
• Queries data in a complex, multi-table database using SQL, R, and/or other languages.
• Assures data quality and integrity by implementing relevant validation techniques.

Technical Support and Collaboration

• Offers technical expertise and support to other departments as needed.
• Works closely with Technology Services and other data-related departments to achieve strategic objectives.

Miscellaneous

• Helps foster a culture of inquiry, improvement, and evidence-based decision-making.
• Represents the department on collegewide committees and/or project-based working groups, as appropriate.
• Other duties as assigned.

Competencies

• Equitable Approaches : Demonstrates commitment to and understanding of diversity, equity, and inclusion, specifically through how data and research can shape and be shaped by such issues.
• Analytical Prowess: Demonstrates strong analytical skills, with the ability to identify and implement opportunities for business and process improvement. Ensures that all products meet the professional standards of analysis, writing, editing, and visual presentation necessary to fulfil the college's mission.
• Communication Skills: Demonstrates outstanding written and verbal communication skills, particularly the ability to translate complex data and concepts for non-technical audiences with minimal use of jargon. Bilingual in English and Spanish preferred.
• Adaptability: Demonstrates ability to work both independently and as part of a team within a dynamic environment requiring work prioritization and an aptitude for multi-tasking. Strong project management skills required.
• Technological Fluency: Demonstrates proficiency with large data sets, spreadsheets, and relational databases, such as Excel, Access, and SQL server. Demonstrates attention to detail and accuracy with complex data sets.Possesses familiarity with big data tools, cloud computing, data warehousing, and the ethical use of artificial intelligence in research.
• Interdisciplinary Collaboration: Demonstrated ability to work collaboratively across various departments to achieve institutional objectives.
• Ethical Standards: Demonstrates ethics, integrity, and sound professional judgment. The department adheres to the (AIR).

Qualifications:
Equivalent combination of education and experience may be considered at the discretion of the college.
This position is designed to be filled at either a level 1 or 2 depending on qualifications.

• Level 1 Requirements:
  • Bachelor's degree or equivalent professional experience in Data Science, Statistics, Computer Science, Sociology or related field; OR equivalent combination of education/experience.
  • Demonstrable intermediate to advanced expertise in data manipulation and visualization tools such as Tableau and Power BI.
  • Intermediate to advanced proficiency querying relational databases, such as Oracle and SQL. Experience with PeopleSoft or similar ERP system preferred.

Level 2 Requirements:

• Bachelor's degree from an accredited institution in Data Science, Statistics, Computer Science, Sociology or related field AND advanced expertise in data manipulation and visualization tools such as Tableau and Power BI. R expertise; OR equivalent combination of education/experience. Master's Degree preferred.
• Advanced proficiency querying relational databases, such as Oracle and SQL. Experience with PeopleSoft or similar ERP system preferred.
• Ability to use independent judgment with select authority for decision making.
• Exemplary professional experience in a data analysis role, preferably in an educational or research-oriented setting.

Level of Supervision
Level 1 - General supervision - Advice and assistance is available as needed. Review of work may be frequent but generally not detailed. Emphasis placed upon quality of completed assignments.

• Performs recurring assignments without daily oversight following established guidelines, policies, procedures and work methods.
• Responsible for prioritizing day-to-day work tasks. Supervisor provides guidance and approves deviation from established guidelines, policies, procedures and work methods.
• Decision-making is limited in context to the completion of work tasks. Completed work is consistent with established guidelines, policies, procedures and work methods. Supervisory guidance is provided in new or unusual situations.
• May develop procedures for performance of a variety of duties within the scope of the position.
• Performs complex duties within established guidelines.
• Work is periodically reviewed for compliance with guidelines, policies and procedures.

Level 2 - General direction - Position receives broad instruction. Advice and assistance is available upon request. Review of work generally emphasizes accomplishment of broader work unit goals and/or performance measures in lieu of specific work assignments.

• Independently performs all assignments using knowledge of established policies and work objectives with minimal direct oversight from supervisor.
• Plans and organizes work and assists in determining priorities and deadlines. May deviate from standard work methods, guidelines or procedures in order to meet work objectives.
• Exercises independent decision-making authority and discretion and determines which work methods to use, tasks to perform and procedures to follow in order to meet work objectives.
• Completed work is reviewed for effectiveness in producing expected results.
• Establishes procedures for attaining specific goals and objectives in a broad area of work.

You don't check every qualification listed? Please apply anyway! Studies have shown that traditionally marginalized communities - such as women, LGBTQ and people of color - are less likely to apply to jobs unless they meet every single qualification - even if they might be a great fit for the role! If you're excited about this opportunity but your experience doesn't align perfectly with every single qualification in the job description, we encourage you to still consider applying.
Conditions/Terms of Employment

This position is in a bargaining unit for which AFT is the exclusive representative.
This is a full-time professional position. Persons hired must be able to provide acceptable documentation of lawful authorization to work in the United States within three (3) days of employment. WWCC participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. Official college transcripts required at time of hire. Candidates may be subject to a criminal history background check as a condition of employment. Information from the background check may not necessarily preclude employment but will be considered in determining the applicant's suitability and competence to perform in the position. The college is a tobacco free institution.
Work is performed almost exclusively indoors in an office environment. Exposure to hazards is limited to those commonly found in office environments. This contract position work schedule will typically be Monday through Friday 8-hours each day. During the summer, work schedule is Monday through Thursday 10-hours each day.
Compensation:
Annual salary range for initial placement based on the represented exempt salary schedule Level 1: $68,858 - $77,907; Level 2: $72,301 - $81,802. The college has an excellent benefit program including paid sick leave; paid vacation leave; medical, dental, life, and long-term disability insurance; retirement and two optional deferred compensation programs. All full-time employees will automatically have 3% of taxable income deferred into the State of Washington Deferred Compensation Program (DCP). All administrative exempt staff set aside 1% of their gross salary in a Health Reimbursement Arrangement (HRA) (VEBA). All exempt employees are required to participate in this program. Walla Walla Community College requires all employees to participate in direct deposit for payment of salary.
Required Application Materials

Applications received by the initial screening date will have priority in the review process, noting the position will remain open until a final hire is made in the event a return for review of late applications is needed. To be included in the initial screening, applications should be received by August 26, 2024. To qualify for consideration, applicants must meet required qualifications and competencies and submit a complete application packet, which includes the following:

• Online NEOGOV application.
• Cover letter
  • In the cover letter, please describe what inspired you to apply for this position at WWCC? Please describe your educational and work background as it relates to the duties described in the announcement.
• Resume
• Names and contact information for three professional references
• Answer to one (1) supplemental question
• Unofficial transcripts for application purposes; official transcripts are required prior to an official start date.

Please ensure you have attached all required application materials as you will not be able to attach any documents after you have submitted your application. If you have difficulty logging into your account, attaching documents, submitting your application, etc., please call NEOGOV Applicant Support at 1-855-524-5627 or email them directly at support@governmentjobs.com.
WWCC reserves the right to not fill this position, reject all applicants, or reopen the position. Applications received during this recruitment may be used to fill future vacancies at the College's discretion.
Walla Walla Community College is committed to provide equal opportunity and nondiscrimination for all educational and employment applicants as well as for its students and employed staff, without regard to race, color, creed, national origin, sex, sexual orientation, including gender expression/identity, marital status, age (over 40), the presence of any sensory, mental, or physical disability, the use of trained guide dog or service animal by a person with a disability, or status as a Vietnam and/or disabled veteran, National Guard member or reservist in accordance with the Civil Rights Act of 1964, Title IX of the Education Amendments of 1972, the Federal Rehabilitation of 1973, the Americans with Disabilities Act of 1990, and any other applicable Federal and Washington State laws against discrimination. The Human Resources Office is accessible to persons with disabilities. If you need accommodations in the application/employment process, please contact the Human Resources Office at(509) 527-4224 - TDD (509) 527-4412, email personnel@wwcc.edu, address: 500 Tausick Way, Walla Walla WA, 99362.
MEDICAL/DENTAL INSURANCE
Medical, dental, life, and long-term disability insurance benefits are provided and administered under the Medical plans and benefits information along with a side-by-side comparison tool of medical plans can be found on the page.

• Dental Coverage - Walla Walla Community college provides dental coverage at no monthly premium cost to the employee.
• Vision Coverage - Employees do not pay a separate premium for vision coverage; it is covered under the medical plan. Optical service frequency and hardware (glasses, contact lenses, etc.) vary depending on type of plan selected.

Eligibility
Permanent, seasonal and part-time employees as determined by WAC 182-12-114. Benefits also cover spouse or State-Registered Domestic Partner (SRDP), and qualifying dependents.

Effective date of coverage
First day of the month following your date of employment. If the date of employment is the first working day of the month, coverage begins on that date.
Medical Plan Monthly Costs
Employees pay their portion of medical care costs through payroll deduction. The employee premium is based on the choice of plan and elected coverage for spouse or SRDP, and dependent children.
MEDICAL FLEX SPENDING ACCOUNT (FSA) & DEPENDENT CARE ASSISTANCE PROGRAM (DCAP)
https://www.hca.wa.gov/employee-retiree-benefits/public-employees/medical-flexible-spending-arrangement-fsa
The FSA and DCAP plans are optional plans offered by the College and the State of Washington. They are calendar year, pre-tax, spending programs you can use to set aside money for eligible expenses. Both plans are offered as payroll deductions and are administered by Navia Benefit Solutions.
The FSA allows you to use pre-tax money to pay for certain out-of-pocket medical expenses. An FSA can be used to cover qualifying expenses such as: chiropractic care, over-the-counter medicine, first-aid supplies etc. For a full list of qualifying expenses visit: https://docs.naviabenefits.com/files/PEBB-Eligible-Expenses-2023.pdf .
RETIREMENT OPTIONS
Eligible employees participate in a Washington state-sponsored retirement plan through one of two administrators: the Washington State Department of Retirement Systems (DRS) or the Teachers Insurance & Annuity Association (TIAA). DRS administers the Public Employee Retirement System (PERS) and the Teachers Retirement System (TRS) plans. TIAA administers the State Board Retirement Plan (SBRP).
*Retirement plan options are determined by employee type and prior history in DRS-administered plans (PERS or TRS). Participation in a retirement plan is required.
For Administrative/Exempt PERS 3 or SBRP
VACATION, SICK, & PERSONAL LEAVE
Vacation leave accrues at the rate of 14.67 hours per month (22 days per year) and sick leave accrues at the rate of one (1) day per month.
REDUCED TUITION WAIVER PROGRAM
Employees can take most credit and non-credit classes at a reduced cost when space is available and certain conditions are met.

Credit classes
Permanent classified, faculty, adjunct faculty and administrative employees of WWCC may take almost any credit class on a space-available basis if requirements and prerequisites have been met. The basic cost is $5.00, plus any fees associated with that class. Hourly and probationary employees are not eligible for this reduced tuition.
??????? Please Note: All information above is subject to change based on, but not limited to, employment status, legislative mandates, or College policy changes. *If an employee is transferring from another Washington State public agency or institution of higher education, benefits and leave may be transferable.
01

Please provide an example of a data visualization you've created along with a brief explanation of why you chose to visualize data in the way you did, what questions you were trying to answer or insights you were hoping to gain, and what, if anything, you learned from the experience. Please take care not to share private or sensitive information. Requested documents may be attached. (up to 500 words)
Required Question