Sr. Business Intelligence Analyst – Administration

The mission of the Allen Institute is to unlock the complexities of bioscience and advance our knowledge to improve human health. Using an open science, multi-scale, team-oriented approach, the Allen Institute focuses on accelerating foundational research, developing standards and models, and cultivating new ideas to make a broad, transformational impact on science.

The mission of the Allen Institute administration team is to provide support and structure to the scientific divisions. Coinciding with the team science approach, administration helps facilitate team learning and the overall mission of the institute.

The Allen Institute Finance team is looking to add a strong customer focused Business Intelligence Analyst to join the team. This position will report to the Director of Finance and has responsibilities focused on partnering with executives and senior leaders in building and supporting centralized KPI’s and reports using data visualization tools for administrative functions enabling enhanced decision making.

This is an exciting time at the Allen Institute as we continue growing. The ideal candidate for this role will possess a strong entrepreneurial spirit to help enhance and establish new processes and tools and stretch what is possible as the institute continues to expand.

In all activities, the Business Intelligence Analyst will work toward building automated reporting solutions aimed at overall Efficiency/Productivity and Drive Business Results for the broader Allen Institute. Ideal candidates are solution-oriented, proactive problem solvers and require minimal supervision.

The Allen Institute believes that team science significantly benefits from the participation of diverse voices, experiences, and backgrounds. High-quality science can only be produced when it includes different perspectives. We are committed to increasing diversity across every team and encourage people from all backgrounds to apply for this role.

Essential Functions

• Design, develop and implement business intelligence solutions that provide actionable insights to administrative function stakeholders
• Partner with executive and senior leaders to gather and document requirements and then translate those requirements into an automated reporting solution using Power BI
• Collaborate with cross-functional teams to identify key performance indicators and metrics and develop into automated solutions
• Understand administrative and scientific functions to identify how data can be used for strategic planning, productivity measures and enhanced efficiency
• Produces high-quality output reports, analyses and automation products
• Implement standardized reporting formats, procedures & processes
• Possess in-depth knowledge of Power BI functionality and options
• Partner with Central IT around usage, deployment and other best practices for efficiency and effective measurements
• Partner with other Power BI users to develop and lead Power BI training sessions
• Will understand reporting within both a relational and a dimensional framework
• Develop, adopt and evangelize reporting guidelines and standards
• Meet required deadlines as outlined by business partners

Note: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. This description reflects management’s assignment of essential functions; it does not proscribe or restrict the tasks that may be assigned.

Required Education and Experience

• Bachelor’s Degree or equivalent combination of degree and experience
• Minimum of 5 years' experience in business intelligence, data analysis or a related field
• Advanced knowledge of Power BI, Tableau, or other major data visualization tools
• Advanced knowledge of Excel
• Strong communication and presentation skills, with the ability to explain technical information to non-technical stakeholders

Preferred Education and Experience

• Seven or more years of using Power BI, Power Query, Tableau or other data analysis/visualization tool
• Moderate knowledge of overall Power Platform
• Previous experience developing applications with tools such as PowerApps
• Ability to convey information easily between Scientific, IT and Administrative units
• Ability to balance competing priorities

Physical Demands

• Fine motor movements in fingers/hands to operate computers and other office equipment

Position Type/Expected Hours of Work

• This role is currently able to work both remotely and onsite in a hybrid work environment. We are a Washington State employer, and the primary work location for all Allen Institute employees is 615 Westlake Ave N.; any remote work must be performed in Washington State.

Additional Eligibility Qualifications

• In keeping with our focus on employee safety, all employees must be up to date with vaccinations against COVID-19 as a condition of employment unless a medical or religious accommodation is approved. All employees will be required to keep their vaccination status up to date according to CDC guidance.

Additional Comments

• **Please note, this opportunity does not offer relocation assistance**
• **Please note, this opportunity does not offer work visa sponsorship**

Annualized Salary Range

• $112,559 - $165,087*

• Final salary depends on required education for the role, experience, and level of skills relevant to the role, along with work location, where applicable.

Benefits

• Employees (and their families) are eligible to enroll in benefits per eligibility rules outline in the Allen Institute’s Benefits Guide. These benefits include medical, dental, vision, and basic life insurance. Employees are also eligible to enroll in the Allen Institute’s 401k plan. Paid time off is also available as outlined in the Allen Institutes Benefits Guide. Details on the Allen Institute’s benefits offering are located at the following link to the Benefits Guide: https://alleninstitute.org/careers/benefits.

It is the policy of the Allen Institute to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, the Allen Institute will provide reasonable accommodations or qualified individuals with disabilities.