Position Summary / Career Interest:

The BI Developer Lead plays a crucial role within the centralized Analytics and Business Intelligence department, bridging the gap between technical expertise and strategic leadership. These individuals leverage their deep understanding of data warehousing, cloud-based analytics (Azure), and the capabilities of Power BI and DAX to guide a team of BI Developers in fulfilling complex analytical requests across the health system. The Lead BI Developer ensures the efficient and effective delivery of actionable insights that drive organizational performance and decision-making. This includes overseeing the development and implementation of advanced BI solutions, fostering collaboration between technical and business stakeholders, and mentoring team members in their professional growth. Ideal candidates possess a strong blend of technical expertise, leadership qualities, and a passion for mentoring and developing others. They thrive in fast-paced environments, are effective communicators, and possess a strong understanding of business objectives and how data-driven insights can support organizational success. A solid understanding of Power BI, DAX, and Azure services is essential, enough to effectively communicate with technical teams, translate business needs into technical requirements, and guide the team in delivering effective solutions. They should be able to articulate the value and potential of these technologies to stakeholders across the organization.


Responsibilities and Essential Job Functions

• Manage a portfolio of BI projects associated with onboarding BI team members.
• Onboard new BI Developers from the technical perspective (development environment overview, available data models and associated tools, development best practices, etc.).
• Provide ongoing technical training, support, and mentorship to BI Developers to enhance their competencies and build their expertise in the analytics and business intelligence space.
• Write clean, maintainable, and well-documented code with focus on reliability embedded in development standards to support data processes.
• Engage with Application Analysts and Clinical Informatics Analysts during design and build stages to align content development with operational workflows and validate requirements that define success as part of the implementation within the integrated data platform
• Engage with Data Analytics Engineers to profile existing data models and develop recommendations for improvement that foster scalability and sustainability.
• Conduct code reviews to provide guidance on engineering best practices and compliance with development procedures.
• Lead specific BI projects, manage timelines, deliverables, and stakeholder communication.
• Communication of upgrade documentation release notes and high-level impact on the analytical environment.
• Create, analyze, modify, configure, and distribute content using information technologies to support clinical and operational processes and organizational initiatives in the integrated data platform.
• Perform all steps of product development stages when designing new data models (requirements collection, research, development, testing, deployment, monitoring, and configuration) that meet health system development standards based on assigned domains.
• Responsible for integrity of the outputs including validation of the data in analytical solutions, systems, and data domains.
• Monitor the performance of existing analytical solutions and take corrective action to optimize or improve their performance for assigned domains and associated data models.
• Detect data discrepancies and data quality issues and work with other content development members and subject matter experts to ensure data consistency and integrity within systems, data models, and applications.
• Demonstrate a strong understanding of how data analysis contributes to overall business goals.
• Understand workflows, data collection methods, and reporting solutions to present advantages/disadvantages of analytical options available to the customer.
• Translate analytical business requirements within request and design solutions that meet the needs of the customers.
• Work closely with analytics and business intelligence managers to identify, recommend, develop/modify and support data and business intelligence strategies resulting from system changes, upgrades, implementations, etc.
• Review tasks critically and ensure they are appropriately prioritized and sized for incremental delivery.
• Anticipate and communicate request and project roadblocks and delays before they require escalation.
• Actively participate in training sessions and workshops.
• Identify new data sources necessary to achieve desired clinical and/or business outcomes and engage with content development support teams to integrate data into a consistent and usable format in the integrated data platform.
• Discover opportunities for an organization to improve its systems and processes through the use of data analytics.
• Assist with efforts to develop and maintain documentation related to datasets and data models in the integrated data platform, ensuring that everyone on the content development teams uses the same language, definitions, version control, and change management guidelines.
• Recommend Data Management process, governance, organizational and platform models, tool selections and application integration options to clients.
• Comply with all policies and standards.
• Must be able to perform the professional, clinical and or technical competencies of the assigned unit or department.
• These statements are intended to describe the essential functions of the job and are not intended to be an exhaustive list of all responsibilities. Skills and duties may vary dependent upon your department or unit. Other duties may be assigned as required.

Required Education and Experience

• Bachelors Degree Computer Science, Bioinformatics, Information Management, Engineering, or related field (or equivalent years in experience)
• 5 or more years experience developing applications with one or more business intelligence tools such as Power BI, Qlik, SAP Business Objects, Tableau, etc.
• 4 or more years SQL experience in a relational database or an equivalent combination of education and experience.
• 3 or more years experience in healthcare environment.

Preferred Education and Experience

• Master's Degree in Business/ Health Administration, Computer Science/ or related field
• 1 or more years experience leading a team, mentoring staff, or successfully managing large projects with multi-function team coordination.
• experience with Microsoft Azure data services, particularly Azure Synapse Analytics, Azure Data Factory, and Azure SQL Database.
• Experience with database management technologies.
• Experience using data mining/analytical methods and associated tools such as Python, R, etc.
• Experience working with Caboodle.

Required Licensure and Certification

• Epic certification in 5+ data model(s). If not certified, certification is required within 12 months from employment within 1 Year
• MS Certifications: Power BI Data Analyst Associate, MCSA: BI Reporting, MCSA: SQL 2016 BI Development within 1 Year

Preferred Licensure and Certification

• Project Management Professional (PMP) - Project Management Institute (PMI) Project management, Lean, Six Sigma, Agile certification ​

Knowledge Requirements

• Proficiency with MS Office products.

We are an equal employment opportunity employer without regard to a person’s race, color, religion, sex (including pregnancy, gender identity and sexual orientation), national origin, ancestry, age (40 or older), disability, veteran status or genetic information.