Since 1999, Pyramid Healthcare has been dedicated to offering the highest quality of care to those we serve. A focus on client-centered care establishes our family of brands as respected leaders in addiction treatment, mental health recovery and eating disorder treatment. Under a passionate leadership team, Pyramid Healthcare offers comprehensive behavioral healthcare defined by supportive environments that offer patients the strength they need to overcome life’s challenges. We offer behavioral healthcare services – psychiatry, addiction recovery, mental disorder treatment, etc. – that allow clients at all stages of recovery or rehabilitation to reclaim health and well-being!

Summary: This business intelligence manager role is responsible for designing, developing, implementing, and deploying dashboard solutions using SQL, Snowflake, and PowerBI technologies across the full development cycle, along with supervisory responsibilities within the data team.

Essential Duties and Responsibilities:

·         Generate complex SQL (TSQL and Snowflake) & Power BI queries to transform, join, and aggregate data.

·         Utilize ETL/IPaaS tools in order to assist with data warehouse construction.

·         Manage a small team of analysts and effectively delegate and oversee projects.

·         Deliver production and ad hoc reports within agreed upon timeframe.

·         Translate stakeholders’ requirements into reporting deliverables.

·         Work with SME’s to research, validate, design, and troubleshoot reports as needed.

·         Translate technical information to non-technical audiences as required.

·         Provide full-cycle guidance to business units allowing for effective decision making.

·         Overcome complex programming and project-oriented roadblocks.

·         Available to provide any needed support outside of standard business hours as needed, situation dependent.

Supervisory Responsibilities

·         The manager will oversee a small team of analysts and will delegate projects as needed, as well as oversee progress and communicate progress to stakeholders.  May also oversee vendor/consultant relationships.

Required Qualifications

Education, Licensure, & Experience

·         Bachelor’s degree in Computer Science, Management Information Systems, Analytics, or 4 years related field/ system experience.

Job Knowledge, Skills, and Abilities

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.  The requirements listed below are representative of the knowledge, skill, and/or ability required.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 

·         Experience developing PowerBI reports required.

·         Strong SSMS, and TSQL skills required, and PowerShell & SSRS considered a plus.

·         Experience in implementing and managing ETL Tools.  Boomi experience a plus.

·         Documentation and requirement gathering skills required as part of full cycle development.

·         Excellent oral and written communication skills.

Physical Demands While performing the duties of this job, the employee is frequently required to talk or hear. The employee is regularly required to sit, stand, use hands to finger, handle, or feel, and reach with hands and arms. The employee is required at moderate levels to walk, stoop, twist, kneel, or crouch. The employee must lift and/ or move up to 20 pounds.

Specific vision levels required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.

Work Environment

Remote

Pyramid CORE Values:

We are committed and proud to live our CORE values and use them to inspire those around us. Our employees are expected to align with these values, behaviors and standards. We are held accountable for upholding these CORE Values: INTEGRITY is striving to be honest, transparent and ethical when dealing with clients, staff and the community. DEDICATION is demonstrating an unwavering commitment to always provide exceptional care and support to those we serve is needed daily. COLLABORATION is a steadfast, team-focused approach; working together to achieve excellence. PASSION is genuine, compelling and relentless desire to improve lives and support Pyramid Healthcare’s mission.  Positive attitude and team before self-mindset required.