Pay
Lower than most similar jobs
$70K–$110K against $95K–$145K, the middle half of what similar US postings state.
From 2,327 postings in the last year. Stated ranges, not salaries paid.
Chicago, IL
Open 3 months, first seen by us 94 days agoExempt Pay Range $70,000.00 - $110,000.00The included pay rate or range represents the University’s good faith estimate of the possible compensation offer for this role at the time of posting. Benefits EligibleRead the full posting
Employment type in the employer’s posting: Full timeFrom the employer’s posting
Design, build, test, and maintain ETL/ELT processes for enterprise reporting
Design dimensional data models and reporting data structures
Write and optimize SQL queries, stored procedures, and views
Translate business reporting requirements into technical solutions
Support BI reports, dashboards, and analytic applications
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.
Support BI reports, dashboards, and analytic applications.
Minimum requirements include a college or university degree in related field.
Minimum requirements include knowledge and skills developed through 2-5 years of work experience in a related job discipline.
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.
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.
Education: - Bachelor’s degree in computer science, information systems, data science, engineering, business analytics, healthcare analytics, or a related analytical or STEM field strongly preferred. Experience:
Open 3 monthsWe first saw this posting 94 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Lower than most similar jobs
$70K–$110K against $95K–$145K, the middle half of what similar US postings state.
From 2,327 postings in the last year. Stated ranges, not salaries paid.
Day 94
Up longer than most. Similar jobs usually come down between day 5 and day 43.
At University of Chicago, jobs usually come down by about day 58.
From 16,018 similar postings that came down, and 28 of University of Chicago’s. Coming down is not always a hire.
10 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- 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.
- 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.
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.
Complete your application on uchicago.wd5.myworkdayjobs.com. The employer’s form will show what is required.
Already applied? Track this application
Department
BSD BIS - Business Intelligence Services
About the Department
Job Summary
Responsibilities
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.
Minimum Qualifications
Education:
Minimum requirements include a college or university degree in related field.
Work Experience:
Certifications:
---
Preferred Qualifications
Education:
Bachelor’s degree in computer science, information systems, data science, engineering, business analytics, healthcare analytics, or a related analytical or STEM field strongly preferred.
Experience:
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.
Working Conditions
Office Environment.
Application Documents
Resume (required)
Cover Letter (required)
The University of Chicago uses AI-assisted tools to streamline and augment some recruitment processes; however, AI is not used to make hiring decisions.
When applying, the document(s) MUST be uploaded via the My Experience page, in the section titled Application Documents of the application.
Job Family
Role Impact
Scheduled Weekly Hours
Drug Test Required
Health Screen Required
Motor Vehicle Record Inquiry Required
Pay Rate Type
FLSA Status
Pay Range
The included pay rate or range represents the University’s good faith estimate of the possible compensation offer for this role at the time of posting.
Benefits Eligible
The University of Chicago offers a wide range of benefits programs and resources for eligible employees, including health, retirement, and paid time off. Information about the benefit offerings can be found in the Benefits Guidebook.
Posting Statement
The University of Chicago is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender, gender identity, or expression, national or ethnic origin, shared ancestry, age, status as an individual with a disability, military or veteran status, genetic information, or other protected classes under the law. For additional information please see the University's Notice of Nondiscrimination.
Job seekers in need of a reasonable accommodation to complete the application process should call 773-702-5800 or submit a request via Applicant Inquiry Form.
All offers of employment are contingent upon a background check that includes a review of conviction history. A conviction does not automatically preclude University employment. Rather, the University considers conviction information on a case-by-case basis and assesses the nature of the offense, the circumstances surrounding it, the proximity in time of the conviction, and its relevance to the position.
The University of Chicago's Annual Security & Fire Safety Report (Report) provides information about University offices and programs that provide safety support, crime and fire statistics, emergency response and communications plans, and other policies and information. The Report can be accessed online at: http://securityreport.uchicago.edu. Paper copies of the Report are available, upon request, from the University of Chicago Police Department, 850 E. 61st Street, Chicago, IL 60637.
New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Analyst, by the work the posting describes.
Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.
Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.
Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
Exempt Pay Range $70,000.00 - $110,000.00The included pay rate or range represents the University’s good faith estimate of the possible compensation offer for this role at the time of posting. Benefits Eligible
Chicago, IL
Working pattern and location restrictions need checking in the full posting.
No clear work-authorization passage found. Eligibility is unconfirmed.