Senior Data Engineer

Updated: 3 months ago
Location: Chicago, ILLINOIS


Posted: 07-Feb-24

Location: Chicago, Illinois

Type: Full-time

Salary: Open


Information Technology

Internal Number: JR22783

Location: Chicago, IL

Job Description:

  • Works closely with business analysts and subject matter experts to understand data analysis requirements, data definitions, and to develop data mappings, data rules, and data transformations for reporting related to a particular data warehouse and/or analytic subject area.
  • Finalizes the conceptual data models developed by the BI Lead, most often a dimensional model with facts and dimensions. Documents and communicates model design to project team.
  • Leads development of logical data models.  Documents, communicates, and maintains model design for the project team.
  • Leads design and implementation of physical databases including index definitions, partitioning, parallelism, tuning, and space management. 
  • Utilizes database design and documentation tools to document, analyze, and communicate database information.
  • Designs DW security.
  • Implements test and QA strategies and prepares for rollout, including assuring data validation and integrity.
  • Coordinates development resources to ensure that project timelines are met.
  • Leads the design of ETL processing modules based on transformation rules, mapping rules, processing requirements and database model.
  • Leads the design of ETL auditing steps to ensure data integrity and completeness of the ETL process.
  • Leads the design of ETL process flow including module dependencies and parallel processing opportunities.
  • Provides documentation for and works with job scheduling team to automate ETL processing.
  • Leads the design of programming specifications for each ETL component.
  • Leads 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.
  • Develops efficient code that meets analysis and design criteria.
  • Coordinates ETL development resources to ensure that project timelines are met.
  • Provides break/fix support and communicates outages as defined by IT Services standards.
  • Troubleshoots and tunes DW and analytic systems.
  • Coordinates testing of software patches and upgrades.
  • Works closely with BIS colleagues to implement DW best practices, supporting integration of information from different subject areas.
  • Promulgates DW, ETL and related development standards, processes, and best practices throughout BIS.
  • Participates in the selection of DW, ETL and related enabling tools, including software and consulting.
  • Deep expertise in DW, ETL and analytic systems best practices and emerging trends is imperative
  • 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.

Preferred Qualifications


  • Bachelor's degree.
  • Advanced study or professional certifications in database, data management, DW, or ETL disciplines.


  • Four years experience designing and building ETL using ODI.
  • Four years experience designing and building Data Warehouse systems using Oracle and VPD.
  • One year of experience building MuleSoft applications.
  • Five to seven years of database and application development experience with a formal software development life cycle.
  • Three years Hadoop experience with Cloudera Apache Hadoop Ecosystem (Nifi, Zeppelin, Oozie, Spark, Impala, Kafka, et al).
  • A minimum of five years of data warehouse development experience including expert knowledge of data warehousing methodologies (e.g. Kimball).
  • A minimum of four years of experience designing and building dimensional data warehouses with Oracle db, Oracle Stored Procedures and Packages.
  • A minimum of four years or more designing and developing ETL processes for data warehouse implementations using Oracle OWB or equivalent ETL tools.
  • Experience as lead DW/ETL designer on two successful enterprise data warehouse initiatives, using both formal software lifecycle development and project management.
  • Two years experience working within the ITIL framework including incident, service, problem, and change management processes and procedures.

Technical Skills or Knowledge:

  • Programming environments, languages, and systems built using (Java, Python, R).
  • AI/ML and predictive analytic algorithms.
  • Knowledge of reporting and analytic systems based on current-generation ERP systems.
  • Familiarity with Business Objects, Tableau or OBIA/OBIEE.
  • Oracle Cloud Financials.
  • Familiarity with higher education administrative systems and data.
  • Working knowledge of Java Applications.
  • Expertise with data query, analysis, reporting techniques, and OLAP.
  • Expertise in Database Design and tools (e.g. Power Designer or Erwin).          
  • Expertise to develop and administer UNIX-based relational database architectures (ODBC, JDBC, Perl DBI, shell scripting, PL/SQL, SQL Developer, SQL Plus, SQL Loader, TOAD, Java).
  • Expert skills in data profiling, source-target mapping, implementation of transformations and business rules.
  • Superior ETL design and development skills including maps, process flows, auditing, and scheduling using vendor tools (OWB, ODI, Data Stage, or Informatica).
  • 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.

Preferred Competencies

  • Excellent analytic skills to quickly synthesize technical, functional, and user inputs, and manage problem-solving to issue resolution.
  • Leads joint design sessions, documenting the results using business process design tools.
  • 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 ability to multi-task effectively.
  • Very high attention to detail and accuracy.

Working Conditions

  • Standard office environment.
  • On-call responsibilities.

Application Documents

  • Resume/CV (required)
  • Cover Letter (required)

The University of Chicago is an Affirmative Action/Equal Opportunity/Disabled/Veterans Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national or ethnic origin, age, status as an individual with a disability, protected 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 the Applicant Inquiry Form.

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: Paper copies of the Report are available, upon request, from the University of Chicago Police Department, 850 E. 61st Street, Chicago, IL 60637.

Create a Job Alert for Similar Jobs
About University of Chicago (UC)
One of the world's premier academic and research institutions, the University of Chicago has driven new ways of thinking since our 1890 founding. Today, UChicago is an intellectual destination that draws inspired scholars to our Hyde Park and international campuses, keeping UChicago at the nexus of ideas that challenge and change the world.
Connections working at University of Chicago (UC)
More Jobs from This Employer
Return to Search Results

Similar Positions