Lead BI Analyst / Data Modeler at The Joint Commission in Villa Park, IL
Overview The Lead Data Analyst works with the business end-users to understand data and analysis needs, designs, and presents technical Business Intelligence solutions, and 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. Responsibilities 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. Qualifications 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.
Salary Range:
$80K -- $100K
Minimum Qualification
Business Intelligence & AnalyticsEstimated Salary: $20 to $28 per hour based on qualifications.
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.
Salary Range:
$80K -- $100K
Minimum Qualification
Business Intelligence & AnalyticsEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
