Data Engineer, Orbit
University of Chicago
ITS 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
• We provide secure, stable, and reliable infrastructure and applications to support the mission of the University.
• We support and enable faculty research and teaching with the effective use of technology.
• We simplify the technology experience for faculty, students, alumni, and staff, and we ensure technology is mobile-friendly and accessible.
• We identify, manage, and mitigate the technology risks of the University.
As the technical lead for projects involving the design, development, and quality assurance of Data Warehouse (DW) and extract/transform/load (ETL) environments, alongside other database environments, this role is pivotal in enabling robust analytics. Operating within established project and development frameworks, under the guidance of a Project Manager, the Data Engineer collaborates closely with the Lead Architect, BI Lead, DW developers, source application developers, and subject matter experts (SMEs).
The responsibilities extend to the upkeep, augmentation, and optimization of these environments, all geared towards establishing an integrated, cross-functional platform for reporting and analysis that caters to the needs of the University's user community.
- Works closely with business analysts and subject matter experts to understand data analysis requirements, data definitions, 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.
- Develops Business Intelligence (BI) and other analytical applications. Works to achieve an integrated reporting and analysis environment, effectively leveraging analytical systems and tools.
- Guides requirements analysis, translating requirements into a scope document and developing reporting deliverables based on the design.
- Performs other related work as needed.
Education:Minimum requirements include a college or university degree in related field.
- Bachelor's degree.
- 4 years experience designing and building ETL using SQL.
- 4 years experience designing and building Data Warehouse systems using Oracle and VPD.
- Experience with Orbit Analytics.
- 7 years of database and application development experience with a formal software development life cycle.
- A minimum of 5 years of data warehouse development experience including expert knowledge of data warehousing methodologies (e.g. Kimball).
- 4+ years of experience designing and building dimensional data marts sourced from Oracle Cloud Financials using Oracle Business Intelligence Cloud Connector Console and PVO offerings.
- 4+ years of experience designing, developing and troubleshooting ETL processes for data warehouse implementations using AirQuery, Oracle materialized views, stored procedures and packages.
- 2+ years of experience working within the ITIL framework including incident, service, problem, and change management processes and procedures.
- Experience with Oracle Cloud Financials Reporting including OTBI, BI Publisher, RTF Templates, FR Studio and Smartview.
- Advanced study or professional certifications in database, data management, DW, or ETL disciplines.
Technical Skills or Knowledge:
- Expertise with data query, analysis, and reporting techniques.
- 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.
- 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.
- Programming environments, languages, and systems built using (Java, Python, R).
- Experience with 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, Orbit Analytics.
- Excellent analytic skills to quickly synthesize technical, functional, and user inputs, and manage problem-solving to issue resolution.
- Joint design sessions, documenting the results using business process design tools.
- Strong oral and written communication skills, including the ability to develop standards and procedures, and present 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.
- Familiarity with higher education administrative systems and data.
- Hybrid work schedule.
- Resume/CV (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.