> Markdown version of [/jobs/ext/2170604-business-intelligence-analytics-analyst](https://www.wearedevelopers.com/jobs/ext/2170604-business-intelligence-analytics-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Intelligence & Analytics Analyst - **Company:** The University of Chicago - **Location:** Chicago, IL, United States - **Experience:** Experienced - **Salary:** $70,000.0 - $110,000.0 - **Contract:** Permanent contract - **Skills:** Business Analytics Applications, Business Intelligence Development, Big Data, Health Informatics, Information Systems, Databases, Information Engineering, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Database Schema, Dimensional Modeling, Metadata, Microsoft SQL Server, SQL Stored Procedures, SQL Databases, Systems Integration, Information Technology, Tools for Reporting - **Published:** August 21, 2026 - **Apply:** https://uchicago.wd5.myworkdayjobs.com/External/job/Chicago-IL/Business-Intelligence---Analytics-Analyst_JR34911 ## About the Role Minimum requirements include a college or university degree in related field. Work Experience: Minimum requirements include knowledge and skills developed through 2-5 years of work experience in a related job discipline., * Bachelor's degree in computer science, information systems, data science, engineering, business analytics, healthcare analytics, or a related analytical or STEM field strongly preferred., * 2-5 years of professional experience in data engineering, analytics engineering, business intelligence, healthcare analytics, or related technical roles strongly preferred. * Demonstrated experience writing optimized SQL queries, stored procedures, and data transformation logic strongly preferred. * Demonstrated experience working with large and complex datasets across multiple enterprise systems strongly preferred. * Experience supporting analytics reporting, automated workflows, or ETL/data integration processes strongly preferred. Preferred Competencies * Proficient in Microsoft SQL, business analytics and reporting tools such as Power BI and Tableau, and ETL tools such as Microsoft Integration Services. * Familiar with data warehousing concepts, such as Kimballs' techniques regarding dimensional modeling. * Demonstrated ability to communicate effectively with both technical and non-technical stakeholders. * Ability to manage multiple projects and priorities in a fast-paced and evolving environment. * Ability to handle sensitive and confidential information in accordance with organizational privacy and security standards. * Strong verbal, written, and interpersonal communication skills. ## Description The Business Intelligence & Analytics Analyst designs, develops, and supports data integration, data modeling, and business intelligence solutions that enable enterprise reporting and analytics. This role is responsible for building and maintaining ETL processes, database objects, and reporting data structures; ensuring data quality and security; and supporting BI applications and users across academic, administrative, and clinical areas., * Design, develop, test, and maintain ETL/ELT processes for enterprise reporting and analytics. * Design and support dimensional data models, database objects, and reporting data structures. * Develop and optimize SQL queries, stored procedures, views, and related database components. * Gather and translate business and reporting requirements into technical solutions. * Create and maintain technical documentation, metadata, data definitions, and source-to-target mappings. * Support BI reports, dashboards, and analytic applications. * Monitor and troubleshoot ETL jobs, data issues, and BI application problems. * Ensure data quality, integrity, security, access control, and compliance. * Support software upgrades, testing, deployment activities, and continuous improvement efforts * Plans and executes requirements analysis, translating requirements into a scope document and developing reporting deliverables based on the design. * Works with users to ensure deliverables are meeting or exceeding expectations. Provides support and communicates issues to users as defined by IT standards. Monitors access control and troubleshoot BI and analytic applications. * Performs other related work as needed. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)