Senior Business Intelligence Developer

At SCP Health, what you do matters

As part of the SCP Health team, you have an opportunity to make a difference. At our core, we work to bring hospitals and healers together in the pursuit of clinical effectiveness. With a portfolio of over 8 million patients, 7500 providers, 30 states, and 400 healthcare facilities, SCP Health is a leader in clinical practice management spanning the entire continuum of care, including emergency medicine, hospital medicine, wellness, telemedicine, intensive care, and ambulatory care.

Why you will love working here:

- Strong track record of providing excellent work/life balance.

- Comprehensive benefits package and competitive compensation.

- Commitment to fostering an inclusive culture of belonging and empowerment through our core values - collaboration, courage, agility, and respect.

Responsibilities:

• Translate Business Needs: Work closely with stakeholders to understand business requirements and translate them into technical specifications for Power BI solutions.
• Advanced Report and Dashboard Development: Design, develop, test, and deploy advanced Power BI reports and dashboards that provide actionable insights and support strategic decision-making.
• Custom Visualizations: Create custom visualizations and integrate Power BI reports into other applications to enhance user experience and functionality.
• Complex Data Modeling: Build and maintain complex data models using Power BI Desktop, ensuring scalability and performance optimization.
• Unit Testing and Troubleshooting: Conduct thorough unit testing and troubleshooting for Power BI models to ensure accuracy and reliability.
• Data Analytics Platform Maintenance: Maintain and support data analytics platforms, ensuring efficient data integration, processing, and performance.
• Data Pipeline Implementation: Design and implement ETL and ELT pipelines, optimizing queries and managing data integration processes.
• Cross-Functional Collaboration: Collaborate with cross-functional teams to drive data-driven initiatives and ensure alignment with business goals.
• CI/CD Pipeline Design: Design and maintain CI/CD pipelines for automated code integration and deployment, ensuring efficient development workflows.
• Data Quality and Security: Ensure data quality, integrity, and security compliance in all BI solutions.
• Technical Support and Documentation: Provide technical support and create comprehensive documentation for BI solutions to facilitate knowledge sharing and maintenance.
• Mentorship: Mentor and provide guidance to junior Power BI developers, fostering their professional growth and development.
• Project Leadership: Lead BI projects, managing timelines, resources, and deliverables to ensure successful project completion.
• Strategic Focus: Drive strategic BI initiatives, contributing to the overall BI strategy and aligning solutions with organizational objectives.
• Advanced Data Analysis: Perform advanced data analysis and provide insights to support business decisions, leveraging statistical analysis and predictive modeling techniques.
• Best Practices Development: Develop and enforce best practices for BI development, data governance, and data management.
• Innovation and Improvement: Encourage innovation and continuous improvement in BI processes and methodologies, adopting new technologies and best practices.

Knowledge, Skills, and Abilities:

• Bachelor’s degree (BA/BS) in MIS, Computer Science, or a related field; or equivalent combination of education and experience.
• Minimum of five years of experience practicing core principles of business intelligence.
• Proven experience leading BI projects and mentoring junior developers.
• Advanced Proficiency in Power BI: Extensive experience in creating complex data visualizations, reports, and dashboards.
• Data Warehousing Expertise: Hands-on experience with cloud-based data warehousing solutions such as Snowflake, Databricks, or Microsoft Fabric.
• Data Integration and ETL: Strong skills in designing and implementing ETL/ELT pipelines, optimizing queries, and managing data integration processes.
• SQL/T-SQL Development: 5+ years of experience in SQL/T-SQL development related to SQL Server, with the ability to write complex queries and optimize database performance.
• Data Modeling: In-depth knowledge of data modeling techniques and best practices for building efficient and scalable data models.
• Advanced Data Analysis: Proficiency in advanced data analysis techniques and tools, including statistical analysis and predictive modeling.
• Software Development Life Cycle (SDLC): Thorough understanding of the SDLC and the roles and responsibilities of BI developers within it.
• Regulatory Compliance: Experience with regulatory controls such as HIPAA, SOX, and similar, ensuring data security and compliance.
• Project Leadership: Proven experience leading BI projects, managing timelines, and delivering high-quality solutions.
• Mentorship and Team Leadership: Ability to mentor junior developers, provide guidance, and foster a collaborative team environment.
• Strategic Thinking: Strong strategic thinking and problem-solving abilities, with the capacity to drive BI initiatives and contribute to the overall BI strategy.
• Communication Skills: Excellent written and verbal communication skills, with the ability to effectively communicate complex technical concepts to non-technical stakeholders.
• Collaboration: Effective collaboration and interpersonal skills to work with cross-functional teams and ensure timely delivery of projects.
• Organizational Skills: Solid organizational skills, including attention to detail and multitasking abilities.
• Customer-Oriented Mindset: Commitment to providing solutions that meet the needs of the business and enhance user experience.
• Agile and Waterfall Methodologies: Working knowledge of agile and waterfall software engineering processes and methodologies.
• Data Governance: Experience in developing and enforcing data governance policies and best practices.
• Relevant certification or license in BI, Data, or Analytics is a plus.

To learn more about SCP Health, please visit:

www.scphealth.com

SCP Health is an Equal Opportunity Employer.

• Check out our LinkedIn Page 
• Like us on Facebook 
• Follow us on Twitter