The Joint Commission

Lead BI Analyst / Data Modeler

Job ID
# of Openings
Information Technology


The Lead Data Analyst works with the business end-users to understand data and analysis needsdesigns, and presents technical Business Intelligence solutionsand recommends enterprise BI strategy and directions. Partners with development and data management roles to identify and capture data required from internal and external sources. Creates and maintains the semantic layer data models for ongoing and ad hoc review and analysis of data and coordinate team activities that are necessary for an accurate representation for specific business models.


Uses data visualization programs, tools and techniques to generate dashboards, reports, and presentations that aid in data storytelling, understanding, and interpretation of trends and patterns of business importance.


Provides Project Management and mentorship for the analysis of functional business processes, defines business analysis solutions, and development of business cases in the support of business projects. 


  • Designs, presents, and Implements Business Intelligence solutions for the Enterprise. 
  • Managers project teams, with all levels of staff, to prioritize projects, define requirements, and implement projects.
  • Analyzes business functions and applications, understands associated data environments, and defines specifications for reports and analysis based on business needs requirements.
  • Ensures the integrity and best practices for the Logical and Physical semantic layer data models.
  • Recommends or makes modifications to Tabular Models to accommodate new calculations, measures, facts, or dimensions, and enhance the Tabular model with appropriate measures and calculations.
  • Develops and presents prototypes and production visualizations using Business Intelligence Tools to represent specific business solution that gives value to the business. 
  • Engages with the project stakeholders, at all levels throughout the division and with other groups, lead bi-monthly and weekly meetings, and prioritize the tasks, while taking into consideration the varying degrees of requirements in coordination with the other teams to provide the highest quality work products.
  • Mentors the BI Data Analysts in the analysis and development of reporting and analytical requirements and Data Warehouse to be implemented for specific business segments or across the business enterprise.
  • Ensures the Dimensional attributes across the Enterprise and confirms that Data Quality and Data Governance are maintained.


  • Bachelor’s degree in Computer Science


  • At least 3 years’ experience in a senior or lead role as a data analyst, dba or equivalent.


  • Knowledge of RPI tools and holder of either (Yellow Belt, Green Belt, Change Agent) 


  • Excellent ability to write Microsoft Sql Server SQL. (> 3 years of Sql experience or equivalent). Knowledge of T-SQL programming (6+ years’ experience).


  • Knowledge of Reporting Services (SSRS). 


  • Strong knowledge of data modeling with emphasis in Dimensional data modeling.


  • Knowledge of DAX and its ability to generate measures and aggregations within a Tabular model.


  • Expertise in MS Power BI or other visualization tools. 


  • Understands Kimball methodology.


  • 2 years’ experience with the Microsoft platform of Analysis Services for developing Tabular data models or equivalent.


  • Experience with formulating requests from the Business community into a visualization requirement or other means of informative type of data report or list.


  • Excellent written and verbal communication skills and the ability to create excellent software development lifecycle documentation.


  • Possess insight and recommends optimum data solutions in support of achieving business data analysis and reporting needs.


Note:  Employees are required to be fully vaccinated against COVID -19 as a condition for employment.



This job description is intended to describe the general nature and level of work performed by an employee assigned to this position. The description is not an exhaustive list of all duties, responsibilities, knowledge, skills, and abilities, and working conditions associated with this position. All requirements are subject to possible modification and reasonably accommodate individuals with disabilities. 


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed