• Design and develop interactive Power BI dashboards and reports. • Create DAX measures and Power Query transformations for optimized data modeling. • Perform ETL operations using SQL, Power Query, and data connectors. • Implement row-level security (RLS) and other data security measures. • Collaborate with business users to define KPIs and reporting requirements.

• Build, enhance, and maintain dashboards in Tableau and/or Power BI • Support and modify existing dashboards, including working with underlying SQL and calculations • Translate business requirements and wireframes into effective visualizations • Develop and optimize DAX measures (Power BI) • Use SQL for data validation, profiling, and troubleshooting • Own work from requirements through development and quality checks • Collaborate with consultants and stakeholders to iterate on reporting solutions

• Gains a thorough understanding of the database structure and business intelligence tools to create required analytical solutions • Serves as first point of contact for data analytics and process improvement • Performs data analysis and creates queries, programs and automation under direction of an experienced analyst • Gathers requirements and prepares analysis based on information from internal and external sources to evaluate and demonstrate enterprise effectiveness and efficiency • Uses basic analytical methods to ensure reported data is meaningful and accurate • Develops technical ability in data analytics using various systems and tools such as Tableau, Microsoft Office Suite, and SAP products • Attends courses in performance improvement activities, system design, technical training, statistical analysis, and other appropriate subjects • Provides assistance in problem identification, resolution, and solution design for a variety of business needs under the direction of an experienced analyst • Project Coordination- Reviews, identifies and documents any issues, barriers, or risks and brings them to management’s attention • Manages workload and balances quality of work with deadlines to fulfill user expectations and project goals • Manages expectations and engages management to review/resolve any potential changes to project scope, expected deliverables, etc. • Implements changes while adhering to the change control policy and procedures for the project in order to deliver a successful solution to the customer • Communicates to all parties the natures, significance and risk factors of corresponding projects • Participates in post implementation review of projects • Assists team with customer requirements gathering • Team Building- Participates in training and professional development sessions • Offers assistance and support to co-workers • Contributes to building positive team spirit and cohesiveness • Balances team and individual responsibilities • Works cooperatively in group problem-solving situations

Impact Advisors, LLC is a nationally recognized healthcare management consulting firm delivering Best in KLAS advisory, implementation, and optimization services. We are driven by a commitment to exceed client expectations and are proud to be a trusted partner to many of the nation's leading healthcare organizations. Our mission to drive patient-centered, value-driven outcomes has earned us prestigious industry accolades. To learn more about us, visit www.impact-advisors.com Job Overview The BI Developer will work closely with a multidisciplinary agile team to build high quality data products as part of driving analytical solutions. These data products will generate insights from the organization’s connected data, enabling the advancement of data-driven decision-making capabilities of the enterprise. This role will function as the data and reporting expert for their specific domain areas as they support key stakeholders across the organization. The BI Developer will understand their stakeholder’s data and information needs, will provide expert consultation on available tools, design options, and relevant data elements, and in the end provide high quality and reliable data products. Responsibilities - Demonstrates knowledge specific not only to his / her respective data domain and module(s) but across the broader spectrum of EHR data models; demonstrates the proven ability to accurately and independently apply knowledge in the design and build of reporting, information, and analytic solutions. - High intermediate to advanced / expert level user of technical tools for the role. - Proven SQL coding experience at an advanced to master coder level; with specific facility in performing SQL tuning. - Responsible for delivering data warehouse and analytic solutions by writing ETL packages, developing visualizations, and performing data and statistical analyses. - Develop metadata for structure in the enterprise data warehouse (EDW). - Performs and coordinates simple to complex projects with minimal direction. - Optimizes internal resources to maximize team capabilities. - Leads peers to resolve complex issues consistent with organizational goals. - Serve as technical resource for discipline in cross-functional teams. - Collaborates as a member of a self-organizing team, in which bundles of work are scheduled, designed, built and delivered on a defined schedule. - Ability to be effective in a fast-paced environment; able to communicate with teammates clearly and at the right times; ready to give and receive help to ensure the team’s overall success. - Able to excel in a matrixed environment, both as a member of a home team with shared functional skills and as a member of time-delimited multidisciplinary project teams spinning up as needed and dissolving upon project completion. - Effective at identifying an approach to information delivery that will prove successful, and skilled at selling that approach to project team members and the sponsor/customer. Qualifications - Solid experience and knowledge developing complex SQL scripts (intermediate to high intermediate, advanced/expert SQL programmer) - Strong hands-on working knowledge of analytical & BI tools (MS SQL Server, SAP, Tableau) (knowledge of statistical packages a plus) - Experience with data visualization tools such as: Tableau, SSRS, Microsoft Power BI, Qlik, etc. - Excellent analytical, problem-solving, and report troubleshooting ability. - Impeccable presentation skills and the proven ability to tailor messages appropriately dependent on the specific audience. - Exceptional written, interpersonal, and oral communication skills. - Proven ability to describe technical solutions to non-technical audiences. - Able to produce data flow diagrams that can easily show data lineage. - Strong organizational skills with attention to detail. - Competent in the skill to plan and facilitate meetings with diverse participants. - Skilled in requirements gathering, gap analysis, and data analysis. - Data sourcing, data mapping and managing metadata strongly preferred. - Proven ability to create data solutions to support business processes. - Proven ability to translate business requirements into data and information deliverables using relevant business intelligence tools. - Proven ability to self-manage time and execute fundamental PM skills to execute project leadership to deliver desired outcomes. The following is required for an Epic BI Developer: - Epic Cogito certification (current). - Epic Data Model certification – clinical, revenue cycle or patient access (current). - 3+ years experience in use of multiple Cogito tools (Reporting Workbench, SlicerDicer, Cogito SQL, Radar). - Strong SQL experience. - 2+ years Power BI or Tableau data visualization experience. - Passionate about data-driven development, reliability, and experimentation. - Experience working on a collaborative agile product team. - Passionate and curious about data. - Self-motivated with strong problem-solving and learning skills. - Flexibility to changes in work direction with excellent communication, listening, and influencing skills - Travel Required based upon client needs. For salaried positions, this role may also be eligible for an annual performance bonus. Additional benefits and perks may also be available, depending on the position and employment terms. This range reflects consideration of several factors, including skills, experience, training, certifications, and organizational needs. Our People and Culture At Impact Advisors, we cultivate a caring, fun, honest, and autonomous work environment. Our success stems from our associates' dedication and a shared mission to create a “Positive Impact.” We embrace diversity and inclusion, fostering an environment where all employees feel valued and empowered. Join Impact Advisors and make a real difference in healthcare.