What are the responsibilities and job description for the BI Data Analyst position at Lensa?
Lensa is a career site that helps job seekers find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these jobs, but promotes jobs on LinkedIn on behalf of its direct clients, recruitment ad agencies, and marketing partners. Lensa partners with DirectEmployers to promote this job for The Joint Commission. Clicking "Apply Now" or "Read more" on Lensa redirects you to the job board/employer site. Any information collected there is subject to their terms and privacy notice.
Overview
The BI Data Analyst performs analysis of structured and unstructured datasets to develop metrics, reports, and visualizations of trends and patterns. Works with technology organization and business end-users to understand data and analysis needs and develops technical requirements. Partners with development and data management roles to identify and capture data required from internal and external sources. Creates and maintains data models for ongoing and ad hoc review and analysis of data. 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. Participates in the Application Development Life Cycle from initial requirements to final implementation. Develops requirements, and defines and implements quality assurance test plans, anddesigns implantation and ongoing support plans.
Responsibilities
We offer a comprehensive benefit package. For a complete overview of our benefits package, please visit ourJoint Commission Career Page (https://www.jointcommission.org/careers/#434f5b531a144a35906939ce76ce893c_cf7b457e1e9842329663d569f5c839cb)
Min
USD $76,000.00/year
Max
USD $97,500.00/year
Job Locations US-IL-Oak Brook
Job ID 2026-7116
# of Openings 1
Category Information Technology
Overview
The BI Data Analyst performs analysis of structured and unstructured datasets to develop metrics, reports, and visualizations of trends and patterns. Works with technology organization and business end-users to understand data and analysis needs and develops technical requirements. Partners with development and data management roles to identify and capture data required from internal and external sources. Creates and maintains data models for ongoing and ad hoc review and analysis of data. 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. Participates in the Application Development Life Cycle from initial requirements to final implementation. Develops requirements, and defines and implements quality assurance test plans, anddesigns implantation and ongoing support plans.
Responsibilities
- Analyzes business functions, business applications, and associated data environments.
- Implements and documents reporting and Business Intelligence solutions for the Enterprise.
- Writes SQL to satisfy reporting requirements for lists or reports.
- Defines table relationships and writes Sql from the relationships.
- Participants in the Application Development Life Cycle from initial requirements to final implementation.
- Develops requirements, defines and implements quality assurance test plans, and designs implementation and ongoing support plans.
- Bachelor’s degree in computer science, Information Systems, or related field.
- Strong SQL skills with experience in Microsoft SQL Server and T-SQL (2 years).
- Python experience for data manipulation, automation, or integration (2 years).
- Proficiency in Power BI for data visualization and dashboard development.
- Familiarity with Azure Data Services such as:
- Azure Synapse Analytics for data warehousing.
- Azure Data Factory for ETL and data integration.
- Azure Data Lake for storage and analytics.
- Azure Analysis Services or Power BI Tabular Models for semantic modeling.
- Understanding of data modeling principles (Kimball methodology preferred).
- Experience creating and maintaining semantic models and implementing measures/calculations.
- Knowledge of data storytelling and translating business requirements into BI solutions.
- Exposure to data governance tools like Microsoft Purview is a plus.
- Excellent communication skills for documenting requirements and presenting insights.
We offer a comprehensive benefit package. For a complete overview of our benefits package, please visit ourJoint Commission Career Page (https://www.jointcommission.org/careers/#434f5b531a144a35906939ce76ce893c_cf7b457e1e9842329663d569f5c839cb)
Min
USD $76,000.00/year
Max
USD $97,500.00/year
Job Locations US-IL-Oak Brook
Job ID 2026-7116
# of Openings 1
Category Information Technology
- Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.
- Please view Equal Employment Opportunity Posters provided by OFCCP here.
- The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.
- This Organization Participates in E-Verify. Click here for more information.
Salary : $76,000 - $97,500