This company is committed to hiring Veterans

Senior Data Warehouse Developer for OBIA

This job is no longer active. View similar jobs.

POST DATE 8/31/2016
END DATE 10/26/2016

The University of Chicago Campus - Hyde Park, IL

Campus - Hyde Park, IL
AJE Ref #
Job Classification
Full Time
Job Type
Company Ref #


Senior Data Warehouse Developer: Serve as Lead Data Warehouse designer and developer related to the implementation of Oracle Business Information Applications/Student Information Analytics (OBIA/SIA) and Endeca. This position requires prior experience designing and implementing enterprise-scale Data Warehouse/Business Intelligence implementations, preferably based on data from Campus Solutions. The candidate must demonstrate a proven background in dimensional modeling, ETL design, ETL development, data extraction and scheduling, testing, incorporation of audit and data validation processes, and detailed technical planning. This role will have experience implementing both 'buy' and 'build' solutions for the enterprise data warehouse. The position requires strong technical design, development, and leadership skills with accountability for meeting timeline and scope agreements with project sponsors.

Essential Functions:

Serve as technical lead on projects to design, develop, and QA Data Warehouse (DW) and extract/transform/load (ETL) environments, and other database environments including Endeca Data Discovery systems that enable analytics.
Following prescribed project and development methodology under the direction of a Project Manager, will work closely with the Lead, BI Lead, DW/ETL developers, source application developers, and subject matter experts (SMEs).
Work closely with business analysts and subject matter experts to understand data analysis requirements, data definitions, and security/access requirements.
Review in detail, profile, and document the delivered data models in SIA and fit-gap to source system and data requirements. Define, design, and implement required customizations and extensions to the delivered dimensional models. Document and communicate model design to project team.
Lead implementation of physical databases including index definitions, partitioning, parallelism, tuning, and space management.
Review and document delivered data mappings, data rules, and data transformations for reporting. Define, design, and implement required changes and enhancements to delivered ETL and extend ETL as needed based on transformation rules, mapping rules, processing requirements and the database model.
Lead the design of ETL auditing steps to ensure data integrity and completeness of the ETL process.
Lead the design of ETL process flow including module dependencies and parallel processing opportunities.
Provide documentation for and work with job scheduling team to automate ETL processing.
Lead the design of programming specifications for each ETL component.
Lead the design of testing plans for each phase of the development process. Plans must ensure accuracy and quality of program code as well as thorough data validation procedures.
Develop efficient code that meets analysis and design criteria.
Coordinate with ETL development resources to ensure that workflow and project timelines are addressed efficiently.
Utilize database design and documentation tools to document, analyze, and communicate database information.
Design DW security to support functional requirements for row and column security for analytic users in various roles.
Design and implement detailed test and QA strategies, including assuring end-to-end data validation and integrity.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran status or status as an individual with disability.

The University of Chicago is an Affirmative Action / Equal Opportunity / Disabled / Veterans Employer.

Job seekers in need of a reasonable accommodation to complete the application process may contact Human Resources by calling 773-834-1841 or by emailing with their request.

Additional Benefits