Senior Data Warehouse Developer
University of Chicago
IT Services collaborates with campus partners to support the mission of the University of Chicago through the consistent delivery of high-quality solutions and services.
About the Department
This position develops and implements analytic programs and supports the use of analytic platforms and administrative data across the University. Reviews administrative data for joint analyses across multiple domains. Partners with functional stewards, business units, and user partners to develop reporting and analytic solutions with appropriate data governance and secure access.
- Serves as senior OBIA developer related to the implementation of Oracle Business Information Applications/Student Information Analytics (OBIA/SIA).
- Develops dimensional hierarchies and adds multiple sources to business model objects.
- Creates and schedules in Oracle BI Delivers to provide real-time, personalized, and actionable intelligence data to subscribers.
- Develops Logical Data Model (Business Model), metadata, and reports including logical columns, aliases, hierarchies, and subject areas to support reporting.
- Translates business analyst requirements into analytics metadata.
- Designs and develops BI Physical Data Model.
- Writes complex queries, Stored Procedures in Oracle SQL and Oracle PL/SQL.
- Determines requirements for aggregate tables, hierarchies, level-based measures, etc.
- Works with ODI and BI report performance optimization.
- Designs and implements enterprise-scale Data Warehouse/Business Intelligence, preferably based on data from Oracle Campus Solutions.
- Implements both 'buy' and 'build' solutions for the enterprise data warehouse.
- Works with users to ensure deliverables are meeting or exceeding expectations. Provides support and communicates issues to users as defined by IT standards.
- Plans, tests and guides roll-out of patches and upgrades to the BI and analytic software. Solves problems in the development and interpretation of BI and analytics system standards and procedures.
- Performs other related work as needed.
Education:Minimum requirements include a college or university degree in related field.
- Bachelor's degree in computer science or other information technology.
- Advanced study or certification in DW, ETL, BI, or data management.
- Seven years of database and application development experience with a formal software development life cycle.
- Five years of data warehouse development experience including expert knowledge of data warehousing methodologies (e.g., Kimball).
- Four years of experience designing and building OBIEE RPD and OBIEE reports.
- Experience in gathering and business analysis.
- Two years of experience implementing OBIA systems, with one year on SIA.
- Two years of experience working within the ITIL framework including incident, service, problem, and change management processes and procedures.
Technical Skills or Knowledge:
- Expertise with data query, analysis, reporting techniques, and OLAP.
- Expertise to develop UNIX-based relational database architectures (ODBC, JDBC, Perl DBI, shell scripting, PL/SQL, SQL Developer, SQL Plus, SQL Loader, TOAD, Java).
- Expertise in SQL coding techniques, performance monitoring, and tuning.
- Working with Unix Server, and Windows Workstation and Server environments. Microsoft Office application suite, especially Excel. Joint design sessions, documenting the results using business process design tools.
- Knowledge of reporting and analytic systems based on Campus Solutions.
- Familiarity with higher education administrative systems and data.
- Excellent analytic skills to quickly synthesize technical, functional, and user inputs, and manage problem-solving to issue resolution.
- Expert skills in business analysis, requirement gathering, data profiling, RPD development, and report development.
- Strong oral and written communication skills, including developing standards and procedures, and presenting technical concepts to non-technical audiences.
- Commitment to working and sharing expertise in a collaborative team environment.
- Strong sense of accountability for completing work within defined scope and timeline, with the ability to multi-task effectively.
- Very high attention to detail and accuracy.
- Some evening/weekend work.
- Hybrid work schedule.
- Resume/CV (required)
- Cover Letter (required)
When applying, the document(s) MUST be uploaded via the My Experience page, in the section titled Application Documents of the application.
Scheduled Weekly Hours
Drug Test Required
Health Screen Required
Motor Vehicle Record Inquiry Required
The University of Chicago is an Affirmative Action/Equal Opportunity/Disabled/Veterans and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender, gender identity, national or ethnic origin, 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.
Staff 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.
We seek a diverse pool of applicants who wish to join an academic community that places the highest value on rigorous inquiry and encourages a diversity of perspectives, experiences, groups of individuals, and ideas to inform and stimulate intellectual challenge, engagement, and exchange.
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.