What are the responsibilities and job description for the Business Intelligence Analyst I position at Pyramid Healthcare?
Pyramid Healthcare is dedicated to offering the highest quality of care to those we serve. A focus on client-focused care establishes our family of brands as respected leaders in addiction treatment, mental health recovery and eating disorder treatment modalities.
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 role is responsible for designing, developing, implementing, and deploying dashboard solutions using PowerBI technologies across the full development cycle.
Essential Duties and Responsibilities:
- Develop and optimize complex SQL/Snowflake and Power BI queries to transform, join, and aggregate data.
- Generate and deliver production and ad hoc reports within established timeframes.
- Build advanced burst reporting and event studio alerts, leveraging the full capabilities of reporting technologies.
- Translate stakeholder requirements into clear, actionable reporting solutions.
- Collaborate with subject matter experts to research, validate, design, and troubleshoot reports as needed.
- Communicate technical concepts to non-technical audiences and provide full-cycle reporting guidance.
- Provide full-cycle guidance to business units allowing for effective decision making.
- Overcome complex programming and project-oriented roadblocks.
- Offer after-hours support as needed based on business requirements.
- Other duties as assigned.
Supervisory Responsibilities
None
Required Qualifications
Education, Licensure, & Experience
- Bachelor's degree in Computer Science, Management Information Systems, Analytics, or 4 years of 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 accommodation may be made to enable individuals with disabilities to perform the essential functions.
- Experience developing PowerBI reports required.
- Strong SSMS, and TSQL skills preferred, and PowerShell & SSRS considered 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.
Total Rewards for Full-Time Positions:
- Medical, Dental, and Vision Insurance
- Flexible Spending Accounts
- Life Insurance
- Paid Time Off
- 401(k) with Company Match
- Tuition Reimbursement
- Employee Recognition Programs
- Referral Bonus opportunities
- And More!
Want to know more?
To learn more about Pyramid Healthcare, and how you can achieve personal and professional growth, visit us at: https://bit.ly/Pyramid-Careers.
Pyramid Healthcare, Inc. is proud of its diverse workforce, and is an Equal Opportunity Employer.
