Senior BI Developer PennDnA

DescriptionPenn Medicine is dedicated to our tripartite mission of providing the highest level of care to patients, conducting innovative research, and educating future leaders in the field of medicine. Working for this leading academic medical center means collaboration with top clinical, technical and business professionals across all disciplines.Today at Penn Medicine, someone will make a breakthrough. Someone will heal a heart, deliver hopeful news, and give comfort and reassurance. Our employees shape our future each day. Are you living your life's work?Entity : CorporateDepartment : PennDNA Data PlatformsLocation : 3600 Civic Center Blvd. Philadelphia, PAHours : M-F, Hybrid, 8hr DaysSummary : The Senior BI Developer will be responsible for providing advanced data and analytics support to facilitate PennDnA decision making, operational efficiency, and research initiatives. The ideal candidate will have a strong proficiency in data analysis, database development, and BI tools, with a passion for leveraging data to drive insights and improvements. This position applies software engineering, systems engineering and dev-ops principles to design comprehensive solutions that meet organizational goals.Responsibilities : BI Solution Design and Development : Under direction of reporting leadership, aids in the design and development of scalable and high-performance business intelligence solutions to meet the needs of stakeholders across clinical, operational, and administrative domains. Utilize BI tools and technologies (e.g., Power BI, Tableau) to create interactive and intuitive reports, dashboards, and data visualizations that enable users to derive actionable insights from complex healthcare data sets.Data Modeling and Extraction : Design and develop complex data models and SQL queries to extract and manipulate data from disparate sources.Performance Tuning : Act as subject matter expert to optimize SQL queries, data retrieval processes, and report rendering to improve the speed and efficiency of PennDnA’s BI solutions and ensure optimal performance for end-users.Quality Assurance : Responsible for oversight and standardization of testing and validation of PennDnA’s BI solutions to ensure accuracy, reliability, and consistency of data and reports.Collaboration : Collaborate with cross-functional teams to understand business requirements, translate them into technical specifications, and deliver BI solutions that address their needs. Provide recommendations, technical expertise, and guidance to leadership, business users and team members.Data Standards and Governance : Collaborate with data governance committees to establish and enforce BI standards, ensuring the accuracy and reliability of reports and underlying data models. Contribute to defining and maintaining sources of truth for critical metrics.Data Security and Privacy : Ensure the confidentiality and security of data by complying with security and privacy measures. Adhere to HIPAA regulations and safeguard Protected Health Information (PHI) throughout the BI development lifecycle.Continuous Improvement : Demonstrate a commitment to continuous learning and professional development. Stay current with industry trends, best practices, and emerging technologies in business intelligence, data modeling and analytics. Look for opportunities to optimize the team’s processes and workflows.Performs duties in accordance with Penn Medicine and entity values, policies, and proceduresOther duties as assigned to support the unit, department, entity, and health system organizationEducation or Equivalent Experience : Bachelor's degree. (Required)4 years of experience in business intelligence development, data modeling, and analytics, with significant experience in a healthcare or academic research environment. Proven track record of leading and executing moderately complex projects with minimal oversight. (Required)Epic Cogito / Cogito Tools Administration, Epic Clarity Data Model, Epic Caboodle Data Model, SlicerDicer Custom Build Badge. (Preferred)Skills / Abilities : Subject Matter Expertise – Strong knowledge of SQL, SSRS, Power BI, Visual Studio, EPIC Clarity, Caboodle, or Cogito and related coding languages (Python, R, SQL.) Applies knowledge to solve problems and contribute ideas to team strategy.Analytical thinking – Strong critical thinking and problem-solving skills with keen attention to detail.Communication & Interpersonal Skills- Excellent verbal and written communication skills. Ability to communicate complex concepts to a diversity of stakeholders.Relationship building - Collaborative. Develops credibility and trust. Ability to develop and maintain professional and collegial relationships. Mentors junior members of the team.Innovation - Applies creative approaches to problem solving and develops solutions to address issues. Is flexible and eager to learn new skills and technologies.Healthcare Knowledge- Knowledge of healthcare data, regulations, compliance requirements, and data privacy standards.We believe that the best care for our patients starts with the best care for our employees. Our employee benefits programs help our employees get healthy and stay healthy. We offer a comprehensive compensation and benefits program that includes one of the finest prepaid tuition assistance programs in the region. Penn Medicine employees are actively engaged and committed to our mission. Together we will continue to make medical advances that help people live longer, healthier lives.Live Your Life's WorkWe are an Equal Opportunity and Affirmative Action employer. Candidates are considered for employment without regard to race, ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, familial status, genetic information, domestic or sexual violence victim status, citizenship status, military status, status as a protected veteran or any other status protected by applicable law.REQNUMBER : 243333