Finance Business Intelligence Analyst

Our Story:
Crisis Prevention Institute Inc. (CPI) is the worldwide leader in evidence-based de-escalation and crisis prevention training and dementia care services. Our programs teach professionals the skills to recognize, prevent, and respond to crises in the workplace. Since 1980, we’ve helped train more than 17 million people within service-oriented industries including education, health care, behavioral health, long-term care, human services, security, corporate, and retail.

At CPI, we are dedicated to changing behaviors and reducing conflict for the Care, Welfare, Safety, and Security of everyone. We believe the power of empathy, meaningful connections, personal safety, and security are the antidotes to fear and anxiety. It’s a philosophy that is central to everything we do, and traces back to our beginning.

As a member of the team, you can expect to:

• Make a difference through your work – You’ll be proud to tell your family and friends about what you do.
• Gain significant career experience only obtained within a fast-growing organization – Entry-level roles through executive leadership.
• Feel fulfilled and have fun – We work hard but make the time to build meaningful relationships and celebrate the wins.

The Role:

The Finance Business Intelligence Analyst will work with stakeholders and Product Owners to understand asks, document requirements, and build business intelligence (BI) solutions that generate valuable insights to drive business growth and optimize workflows. This role will oversee the overall data-hygiene governance, processes, and workflows based on business and technical requirements needed to channel data from multiple inputs, routing appropriately, and storing data using any combination of distributed (cloud) structures, local databases, and other applicable storage forms as required. CPI is a high-integrity organization, and successful team members, including this key role, will admit mistakes, take corrective action quickly (fail fast), and be diligent in providing the best solutions while meeting deadlines.

What You Get To Do Everyday:

• Build accurate and repeatable reporting deliverables with reporting and visualization tools such as PowerBI, Tableau, or Excel based on the business case.
• Collaborate with Technology Services and Finance teams to improve data models that feed business intelligence tools, increasing data accessibility, and fostering data-driven decision making across the organization.
• Perform data analysis required to troubleshoot data-related issues and assist in the resolution of data issues. A natural curiosity about reported data is critical.
• Create documentation for newly generated reports and update existing documentation for planned enhancements.
• Promote work-stream visibility by collaborating with team members.
• Utilize repositories to track versioned report enhancements.
• Perform other position-related duties as assigned.

You Need to Have:

• Bachelor’s degree in information science, data science, information technology, information systems, mathematics, or a related field
• Experience working with data wrangling in Microsoft Excel
• Experience working with BI tools such as PowerBI or Tableau
• Experience working with data analysis, data profiling, report writing and development, dashboards, and BI toolsets
• Experience working with Scrum and Agile frameworks
• Experience analyzing data from various sources and formats, and applying data insights to cleanse and transform data into a standardized format
• Knowledge of SQL writing, queries, and views

We'd Love to See:

• Experience working with Python, PowerShell, or equivalent scripting language
• Experience working with Microsoft Dynamics 365 Framework including Power Automate
• Experience working with Cloud Data platforms and concepts including Azure and Snowflake
• Knowledge of generally accepted accounting principles (GAAP) and processes
• Ability to multitask, prioritize and organize efficiently
• Ability to work independently and a member of a multi-function team
• Accountability for work produced
• Excellent analytical and problem-solving skills
• Strong attention to detail
• Strong verbal and written communication
• Well-developed interpersonal skills

What We Offer:

• $70,000 - $80,000 annual salary
• Annual company performance bonus
• Comprehensive benefits package
• 401k
• PTO
• Health & Wellness Days
• Paid Volunteer Time Off
• Continuing education and training
• Hybrid work schedule

Crisis Prevention Institute is an Equal Opportunity Employer that does not discriminate against any applicant or employee on the basis of age, race, color, ethnicity, national origin, citizenship, religion, diversity of thoughts and beliefs, creed, sex, sexual orientation, gender, gender identity, or expression (including against any individual that is transitioning, has transitioned, or is perceived to be transitioning), marital status or civil partnership/union status, physical or mental disability, medical condition, pregnancy, childbirth, genetic information, military and veteran status, or any other basis prohibited by applicable federal, state, or local law. The Company will consider for employment qualified applicants with criminal histories in a manner consistent with local and federal requirements. Our management team is dedicated to this policy with respect to recruitment, hiring, placement, promotion, transfer, training, compensation, benefits, employee activities, and general treatment during employment.