Lead BI Analyst Pop Health

Wellstar Health System•Marietta, GA

21h

About The Position

As a Lead BI Analyst on the Population Health Data Analytics team, you will work in a dynamic Data & Insights organization supporting analytics and reporting. Collaborating closely with business stakeholders, you will help define, design, and deliver business-critical analytics and operational reporting that enhances population health management initiatives.

Requirements

Bachelors Computer Science or Bachelors Statistics or Bachelors Business Informatics or Bachelors Other
Minimum 8 years Experience working with and building complex datasets in a relational database environment using tools such as SQL Server, MS Visual Studio, MS Excel, Python, R, Alteryx, Azure, and other third-party data tools.
Proven experience in creating highly effective data visualizations that meet business needs, demonstrating measurable impacts on business results using tools such as Tableau and Power BI.
Hands-on experience with data warehouse architectures, data modeling concepts, and ETL design processes. Familiarity with ETL tools and frameworks is essential.
Experience managing projects or leading initiatives related to data analytics or business intelligence, demonstrating the ability to drive projects from conception to completion.
Commitment to ongoing professional development and staying current with emerging technologies and best practices in data analytics and business intelligence.
Excellent verbal and written communication skills, with the ability to effectively convey complex data insights to both technical and non-technical stakeholders.
Experience in the healthcare sector, with familiarity with healthcare data systems such as EPIC, Clarity, or EPIC Caboodle.
Demonstrated expertise in writing efficient T-SQL queries and reports, with a strong ability to troubleshoot and optimize the performance of existing reports.
Utilize performance analysis tools such as Execution Plans, SQL Server Profiler, and Database Engine Tuning Advisor to identify performance bottlenecks and implement effective tuning strategies.
Work collaboratively with cross-functional teams to address performance issues and enhance reporting capabilities, ensuring that data-driven insights are delivered efficiently and effectively.
Stay updated on best practices for SQL performance tuning, including understanding execution plans and key performance metrics.
High Ability to identify complex problems, involve key parties, gather pertinent data, and consider various options in the decision-making process.
Skilled at applying problem solving skills in a logical, systematic way to resolve issues High
Advanced skills working with relational database structures and concepts.
Advanced skills working with data visualization tools including Tableau and Power BI, a certification would be preferred.
Familiarity with common statistically appropriate means of data and process analysis.
Experience in data mining, data quality and data security.
Ability to leverage critical thinking in all aspects of work product design and delivery.
Advanced skills working with relational database structures and concepts.
Strong attention to detail and accuracy and a sense of personal accountability
Advanced skills working with data visualization tools including Tableau and Power BI, a certification would be preferred.
Familiarity with common statistically appropriate means of data and process analysis
Experience in data mining, data quality and data security.
Self-motivated and well organized with strong time management skills and the ability to manage multiple priorities
Ability to work independently or in a team environment and act as a mentor to less experienced team members as well as to work collaboratively across the organization: interpret user requirements, identify the root cause, research possible solutions, identify most feasible solutions.
Strong interpersonal communication skills and the ability to work well with all levels of the organization
Personal desire for continuous knowledge and skill growth and development.

Nice To Haves

Strong understanding of statistical analysis techniques and methodologies, with the ability to apply these principles to derive insights from complex datasets.

Responsibilities

Design, develop, and implement data models and reporting solutions that meet business reporting and analytical objectives for population health management.
Serve as the BI expert by collaborating across the enterprise and developing relationships with executives, stakeholders, and analytics teams to understand the current and future data and analytics environment.
Lead the adoption of new tools and processes as they are rolled out, ensuring alignment with population health strategies.
Support the long-term analytics and reporting strategy by establishing best practices and templates for data preparation and visualization specific to population health metrics.
Manage the process for code reviews, including data and visualization reviews, fostering team collaboration.
Monitor and respond to enterprise reporting requests by applying healthcare expertise along with technical and analytic skills to develop and document data/business analytics requirements.
Recommend ways to improve data reliability, efficiency, and quality in the context of population health analytics
Support advanced analytics including predictive/prescriptive modeling to inform healthcare strategies.
Coach and develop other BI analysts to enhance their skills in population health analytics.
Serve as the primary liaison between customers and Data Integration (DI) teams to understand data analysis needs, governance requirements, and implementation strategies.
Communicate data structure and metric requirements to DI counterparts responsible for data warehouse and model development, ensuring alignment with business objectives.
Develop interim data solutions to address immediate business needs while long-term data models are being built.
Lead the design, development, and implementation of robust data models and reporting solutions that align with the organizations reporting and analytical objectives.
Ensure that data models are scalable, efficient, and meet the evolving needs of the business.
Proactively identify data quality issues that may impact analyses and reporting; escalate these issues to DI leadership and relevant stakeholders for resolution.
Collaborate with teams to implement corrective actions and enhance data integrity.
Utilize appropriate statistical and mathematical methodologies in all analyses to ensure accuracy and reliability of insights.
Conduct thorough benchmarking and comparative analyses to evaluate performance metrics effectively.
Develop a comprehensive understanding of the data managed and reported by the DI department, including areas such as cost accounting, operational benchmarking, quality benchmarking, and patient satisfaction metrics.
Stay informed about best practices in data transformation and reporting to enhance overall data management processes.
Maintain Expertise in Technology Tools: Develop and sustain a comprehensive understanding of a diverse range of technology tools utilized by Wellstar for data presentation and analytics, including SQL, Advanced MS Excel, Power BI, QuickSight, Snowflake, AWS, Azure and others.
Enhance Data Quality and Visualization: Proactively recommend strategies to improve data reliability, efficiency, quality, and visualization techniques to ensure impactful insights and reporting.
Commit to ongoing professional development by actively seeking opportunities to enhance knowledge and skills in relevant data analytics tools and technologies.
Guide the Analytics Delivery team in adhering to established data governance processes, ensuring that all analytics practices align with organizational standards and regulatory requirements.
Implement Process Improvement Techniques: Understand and apply process improvement methodologies utilized at Wellstar in your own work processes.
Act as a leader within the Data Integration (DI) department to drive initiatives aimed at enhancing productivity and quality of output.
Engage in departmental and cross-functional teams, representing the DI department as needed to contribute insights and support organizational goals.
Work independently while effectively managing multiple assignments and priorities to meet deadlines and deliver high-quality results.
Communicate effectively and appropriately with all levels of leadership and staff within the organization, ensuring that the DI department's objectives and contributions are clearly represented.
Undertake other responsibilities as assigned to support the overall mission and objectives of the organization.
Performs other duties as assigned
Complies with all Wellstar Health System policies, standards of work, and code of conduct.