Build and maintain data views, ETL processes, and advanced reports. Monitor data integrity, document data dictionaries, support power users, enable visualizations, and assist Information Services with integrations and ticketed support.
About the Role
The Reporting Analyst will partner with key stakeholders to build data structures and processes to produce meaningful and actionable organizational reporting. This person will need to be able to extract and manipulate data from many different sources to provide a standardized and cohesive view of data to institutional leadership. This position will monitor data sources to enforce best practices and business rules to promote data integrity for all reports. The Reporting Analyst will play a critical role in defining and enabling the organizational data strategy.
Location: Chicago (Loop) with ability to work remotely part of each week
Department: Shared Services — Information Services
Reports To: Vice President of Information Services
FLSA Status: Exempt
Primary Responsibilities:
- Design and maintain data views needed for requested reports.
- Assist power users with utilization of data views to produce their own ad-hoc reports.
- Build and maintain advanced reports as requested by end-users.
- Create and monitor extract/transform/load processes used in database population and application integrations.
- Document all data structures, relationships, and attributes in organizational data dictionaries.
- Identify and report data integrity issues across data sources to promote ongoing data quality.
- Assist Information Services staff with making data visualizations available on other platforms such as the organization’s intranet.
- Utilize the department ticketing system to obtain position-related end-user support requests, and work with the users to resolve their issues.
- Perform other duties as assigned.
Required Qualifications:
- Intermediate knowledge of MS Power BI.
- Excellent structured query language skills.
- Ability to create and maintain basic ETL scripts.
- Working knowledge of MS SQL Server management studio environment.
- Ability to create thorough documentation for maintenance and end-user training.
- Advanced knowledge of MS Excel and various delimited text file formats for data movement.
- Demonstrates a collaborative spirit and values team goals above personal contributions.
- Ability to be self-motivated for constant improvement/optimization of existing processes.
- Demonstrates passion for showcasing advanced capabilities of existing tools.
- Ability to perform the role with the utmost integrity including maintaining the privacy and protection of institutional data.
- Excellent verbal and written communication skills, and comfortable communicating in-person as well as through video conferencing.
Preferred Qualifications:
- Experience using Power BI to design high impact visualizations on board-level reports.
- Knowledge of SharePoint integrations with Power BI.
- Advanced knowledge of MS SQL Server table/query optimization and complex ETL scripting.
- Experience with accessing data from a variety of cloud hosted applications.
- Knowledge of reporting tool utilization in an MS Azure environment.
- Industry or role-related certifications.
- Prior experience working in health care or academic settings.
Physical Requirements:
- Prolonged periods of sitting at a desk and working on a computer.
Education/Experience:
- Bachelor’s Degree in Computer Science, Business, Management or other related fields, or equivalent work experience preferred.
- 2 years of work experience performing similar duties.
Similar Jobs
Automotive • Professional Services • Software • Consulting • Energy • Chemical • Renewable Energy
Build enterprise financial and operational reporting capabilities, including executive dashboards, KPI frameworks, scorecards, self-service analytics, and trusted reporting datasets. Analyze complex data to identify trends and performance drivers, standardize metrics, improve data quality and automation, and partner with Finance, IT, and business leaders. Present actionable insights, support governance, document reporting methodologies, and coach analysts and stakeholders.
Top Skills:
Data ModelingEpmErpExcelMicrosoft Power BiSQL
Healthtech
Drives KPI reporting, dashboard and scorecard development, forecasting, trend analysis, data collection, and executive presentations. Partners with cross-functional teams and leadership to identify analytical needs, improve data quality and reporting processes, investigate metric fluctuations, and support operational decision-making. Builds standardized tools and templates, automates reporting, maintains data integrity, communicates findings, and develops work plans to meet deadlines.
Top Skills:
DataikuGCPMicrosoft AccessExcelMicrosoft PowerpointMicrosoft WordPythonSQLTableau
Information Technology • Consulting
Supports regulatory reporting by defining data requirements, developing repeatable data flows, performing data cleansing and analysis, monitoring data quality, troubleshooting reporting issues, and creating reports, templates, documentation, and quality controls. Collaborates with actuarial data teams and business process owners to improve reporting scalability, accuracy, and compliance.
Top Skills:
Business Intelligence ToolsData Visualization ToolsDatabasesMicrosoft AccessExcelMicrosoft Office SuiteMicrosoft Word
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
