Business Intelligence Analyst - On Lok

On Lok Inc.

Dedicated to The Care of Elders:

On Lok, Inc. is a not-for-profit organization founded in the early 1970s by a group of citizens concerned about the plight of elders and the lack of long term options in the community. On Lok, Inc. serves as the administrative arm of a group of five affiliated non-profit organizations. Its functions include research and development, human resources, fundraising and management information systems.

We understand the importance of a system that works together. Your expertise, drive and passion can help us carry out our mission to improve lives and advance healthcare.

Join our team of leaders to begin a rewarding career!

POSITION SUMMARY:

Reporting to the Director of Business Intelligence, the Business Intelligence Analyst will be responsible for the design, implementation, and support of On Lok's information delivery systems. As the primary customer-facing member of the BI team, the incumbent will work closely with business users, including senior leadership, to identify business requirements and data needs. They will inform and support data infrastructure, modeling, and quality efforts in the ongoing development of enterprise-wide BI platform. They will design and implement the tools and processes needed to provide reports, dashboards, and ad-hoc / self-service BI in support of data-driven decision making.

PRIMARY RESPONSIBILITIES

1. Build relationships with key business partners.
2. Lead requirements-gathering sessions, analyze requirements and data needs, and work with end-users in designing the ideal BI solution to any given business problem.
3. Architect data visualization/self-service BI projects from end to end.
4. Create and monitor KPIs and metrics for all of On Lok's business lines.
5. Train and assist users to transform data into action-oriented information and to use that information.
6. Support users in answering complex business questions via BI tools and ad-hoc SQL queries.
7. Document new and existing models, solutions, and implementations.
8. Lead root cause analysis efforts for operational BI tool issues; resolve them independently or with other team members.
9. Contribute to and support data aggregation strategy for reporting, dashboards, and self-service analytics.

QUALIFICATIONS:

1. Experience working directly with business users to build reports and dashboards, and solve business questions with data.
2. Ability to lead projects from start to finish: identifying user requirements, developing prototype ETLs, aggregating data, crafting dashboards/reports, ensuring user adoption, and supporting ongoing improvement.
3. Advanced data visualization skills; the ability to tell stories and make dashboards actionable.
4. At least 3 years of experience as a data analyst/developer.
5. At least 2 years of experience developing/reporting in enterprise BI platforms (Prefer Periscope or similar).
6. Advanced SQL skills and experience writing complex queries.
7. Bachelor's degree, or equivalent experience, in quantitative field (e.g., engineering, computer science, finance). 
8. Excellent written and verbal communication skills.
9. Versatility, flexibility, enthusiasm, and a willingness to work with frequently-changing priorities.
10. Knowledge of the healthcare industry, particularly PACE and/or MAOs, a plus.

On Lok's Employee Benefits include (eligible for any regular position for 20 hr/wk or more):

• Medical, Dental, and Vision coverage
• Retirement Savings Plan 403(b) and Term Life/AD&D Insurance
• Flexible Spending Account, Commuter Checks, MLA scholarships, Employee Assistance Program (EAP)
• Pet Insurance and additional discounts
• Holidays (10 per year), vacation time, sick leave, and long-term disability insurance

Your final compensation offer will be determined based on factors such as skills, experience, education, and licenses/certifications. The pay range is expressed as an hourly rate regardless of FLSA status. Exempt positions are paid salaried and are not subject to overtime.

Pursuant to the San Francisco Fair Chance Ordinance, and state and federal laws (including federal PACE requirements at 42 CFR 460.64(a); 460.68(a), we will consider for employment qualified applicants with arrest and conviction records.

On Lok is an equal opportunity employer committed to a diverse and inclusive workforce. All applicants will receive consideration for employment without regard to sex (including pregnancy), race, religion, color, gender, gender identity, gender expression, sexual orientation, national origin, ancestry, disability, medical condition, genetic information, marital status, age, military or veteran status, or any other legally protected status.

If you require reasonable accommodation to participate in the job application or interview process, to perform essential job functions and/or to receive other terms, privileges or benefits of employment please contact Recruitment (recruitment@onlok.org).