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 Engineer will work with stakeholders and product owners to understand business needs, document requirements, and build business intelligence solutions that generate valuable insights to drive business growth and optimize workflows. CPI is a high-integrity organization, and successful team members, including those in this key role, will admit mistakes, take corrective action quickly (fail fast), and be diligent in providing the best solutions while meeting deadlines.In addition, this role will establish and maintain data governance, modeling standards, and reporting workflows by applying business and technical requirements to curate, govern, and deliver trusted datasets and semantic models across Business Intelligence tools.
What You Get To Do Everyday:
- Collaborate with data engineering, technology, and finance stakeholders to improve data models that feed business intelligence tools, increase data accessibility, and foster data-driven decision making across the organization.
- Build accurate and repeatable deliverables in reporting and visualization tools such as PowerBI, Tableau, or Excel, based on the business case.
- Write complex queries and views using aggregations and window functions to prepare data for downstream reports.
- Be creative in deliverable design approaches, options, and solutions, as well as create proofs-of-concept that align with project requirements.
- Implement role-based access controls for specific data and reports, maintaining data security and integrity.
- Conduct root-cause analysis on product performance, customer behavior, and market trends.
- Analyze and troubleshoot data-related issues and assist in the resolution of data issues.
- Create documentation for reports and update existing documentation for planned enhancement.
- 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 relevant work experience
- Three years or more of work experience in data analysis, data modeling, reporting writing/development, dashboard, and/or business intelligence toolsets
- Experience working with data wrangling in Microsoft Excel
- Experience with Business Intelligence tools such as PowerBI or Tableau
- Experience working with Cloud Data platforms and concepts, including Azure and Snowflake
- Experience writing complex SQL queries using aggregations and window functions
- Experience in analyzing data from various sources and formats, and applying data insights
- Knowledge of coding with DAX, Python, PowerShell, or equivalent scripting language
- Knowledge of Scrum and Agile Framework
- Strong attention to detail
- Strong verbal and written communication
- Accountable for work produced
- Excellent analytical and problem-solving skills
- Continuous learner
- Ability to multitask, prioritize, and organize efficiently
- Ability to work independently and be a member of a multi-function team
- Well-developed interpersonal skills
We'd Love to See:
- Experience working with automating tasks using Power Automate
- Experience working with Microsoft Fabric
- Professional certifications such as SnowPro Core, Microsoft PL-300, etc
- Knowledge of accounting principles and processes
What We Offer:
- Annual company performance bonus
- Comprehensive benefits package
- 401k
- PTO
- Health & Wellness Days
- Paid Volunteer Time Off
- Continuing education and training
- Hybrid work schedule
- Paid Parental Leave
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, 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.
Top Skills
What We Do
Since 1980, the Crisis Prevention Institute has helped millions of individuals begin a journey of positive, supportive, and empathic caring for people of all ages.
• We believe in the power of empathy, compassion, and meaningful connections.
• We consider personal safety and security the antidotes to fear and anxiety; and that listening leads to understanding.
• We know when those who care for others feel prepared and confident in their abilities, they can make the world a better place.
CPI’s crisis prevention training gives professionals the confidence to prevent and respond to workplace violence. With a focus on healthcare, education, human services, and dementia care, CPI sets the standard for best practices in evidence-based workplace violence prevention. Our training is designed to support the safety and well-being of both staff and those in their care. We teach the skills that help professionals de-escalate verbal and physical crises in the workplace, with an array of solutions that address the full spectrum of risk levels.
Solutions
Nonviolent Crisis Intervention® Training:
Nonviolent Crisis Intervention Training focuses on verbal de-escalation and early intervention, giving staff an effective framework for decision making and problem solving, as well as teaching safe disengagements and physical interventions that can be implemented with the least use of force, providing the safest environment for all parties involved.
Verbal Intervention™ Training:
This program is ideal for organizations that have a hands-off policy, and for staff members who don’t experience higher risk situations requiring physical interventions, instilling the confidence and skills to verbally respond to disruptive behaviors, and prevent further escalation.
To learn more about CPI and our full offering of industry-leading solutions, visit us today at crisisprevention.com.
