Sr. Data Integrations Engineer

Job description

DescriptionUniversity of Colorado Denver l Anschutz Medical Campus
Office of Information Technology
Job Title: Sr. Data Integration Engineer 
Position #002109 – Requisition #19945

* Applications are accepted electronically ONLY at www.cu.edu/cu-careers *

The Office of Information Technology has an opening for a full-time University Staff (unclassified) Sr. Data Integrations Engineer position.

The University of Colorado Denver | Anschutz Medical Campus is a public research university serving more than 18,000 students. We award nearly 4,000 degrees each year, including more graduate and professional degrees than any other Colorado institution. With our solid academic reputation, award-winning faculty and renowned researchers, we offer more than 140 highly rated degree programs through 13 schools and colleges. The university receives over $400 million in research awards each year. In addition to the wide array of health-related programs and facilities offered at CU Anschutz in Aurora, Colo. a significant number of undergraduate and graduate degree programs are taught at CU Denver, our comprehensive campus in the heart of downtown Denver—one of America’s most vibrant urban centers. CU Denver is located steps from the Denver Center for Performing Arts and the LoDo District affording our students, faculty and staff access to a broad array of academic, professional, community, recreational and cultural outlets.

The Office of Information Technology works to advance the University mission by providing innovative technology solutions and services to the CU Denver | Anschutz Medical Campuses, their constituents and partners. Click here to find out more about the Office of Information Technology 

Through our six core values, Service, Professionalism, Leadership, Innovation, Community, and Excellence (SPLICE), we make a difference. Click here to find out more about OIT’s Culture. 

The Senior Data Integrations Engineer is a role on the Data Operations and Data Architecture (DODA) team in the Office of Information Technology at the University of Colorado Denver | Anschutz Medical Campus and is responsible for architecting, developing, and managing data integrations between disparate source systems and the central data warehouse as well as establishing stable and flexible end point for systems downstream of the warehouse.

This role is a highly technical job that also requires strong technology leadership and customer relationship skills. The Senior Data Integrations Engineer works with business analysts and directly with customers to evaluate needs, build and test solutions and ensure service delivery. These responsibilities require deep knowledge of higher education business process, contemporary data warehousing technologies and methods, as well as current ETL patterns, technologies, and methodologies. Day-to-day work includes evaluating data needs, designing data flows, ensuring security review, developing, deploying, and testing data integrations and working with the DODA team to ensure overall scalability and supportability of all solutions.

Jobs in this career family develop, maintain, and support computer systems, software and networks.  Functions include enterprise operations, distributed computing, academic computing, research computing, computer hardware and software management, computer networking, telecommunications, systems development, database administration, server administration, website management, programming, desktop support, and help desk operations.

Principal Professionals are responsible for exercising discretion, analytical skill, personal accountability and responsibility in a wide range of areas including academic, administrative, managerial and student services functions. Work involves creating, integrating, applying and sharing knowledge directly related to a professional field. Work is performed at an advanced or expert level. 
Principal Professionals are either work leads over others or are considered a subject matter expert in a particular area.                                                      

Responsibilities

  • Lead development projects and related project teams focused on sharing and integration of data between the central data warehouse and application and reporting end points.
  • Develop, test, and maintain large scale ingest and synchronization of data across a diverse set of upstream systems.
  • Provide advocacy for UIS integrations (including monitoring progress and communication with constituents).
  • Oversee data governance process, including developing efficient methods for seeking data steward approval, security, and procurement review in collaboration with the PSA processes (including project management and business analysis).
  • Build and document services related to enterprise service bus (REST API, ODBC connections, managed views, etc.).
  • Debug data flow and data integrity issues; working with downstream data consumers based on their data requirements.
  • Work with team to maintain quality data documentation (catalogs, glossaries, dictionaries and end points).
  • Deliver quality, scalable and cost-effective data solutions that meet business requirements and conform to architectural designs and technology strategies.
  • Build services related to data integration and sharing, leveraging utilities such as MuleSoft and Exasol.
  • Work with team on data roadmaps, services and product and technology strategy.
  • Work with security team to meet all data security requirements.
  • Collaborates closely with business partners across the organization on the design, delivery and maintenance of integration solutions.
  • Build strong relationships with stakeholders at multiple levels, from end users to senior executives, across the enterprise.
  • Develop and tune integrated datasets in support of operational workflow and analytics needs required by various initiatives across data warehouses, ERP, LMS, and other applications.
  • Cultivate understanding of business processes and priorities to consolidate and present data from various sources for business decisions.
  • Ensure that data quality is known and tracked by identifying duplicates and missing data.
  • Manage flow of data into warehouse and participate in the architecture design and modelling of data.
  • Train staff on ETL architecture, standards, and documentation.
Salary and Benefits:
The salary range for this position has been established at $98,000 - $112,533 and is commensurate with skills and experience.

The University of Colorado offers a full benefits package.  Information on University benefits programs, including eligibility, is located at https://www.cu.edu/employee-services.

Conditions of Employment:
Must be willing and able to travel between campuses (Denver Campus and Anschutz Medical Campus)

PLEASE NOTE: Candidates will be responsible for travel expenses related to the interview process and any relocation expenses, if applicable.

Parking expenses for employees are not covered by the university. To review parking options please visit the link below and select your appropriate campus: Facilities Management Permit Parking 

The University of Colorado Denver | Anschutz Medical Campus is dedicated to ensuring a safe and secure environment for our faculty, staff, students and visitors. To assist in achieving that goal, we conduct background investigations for all prospective employees. 

The University of Colorado Denver | Anschutz Medical Campus is committed to recruiting and supporting a diverse student body, faculty and administrative staff. The university strives to promote a culture of inclusiveness, respect, communication and understanding. We encourage applications from women, ethnic minorities, persons with disabilities and all veterans. The University of Colorado is committed to diversity and equality in education and employment.



QualificationsMinimum Qualifications:

  • Bachelor's degree or higher in Information Technology, Computer Science, or related field
  • Five years of SQL experience including complex database functions 
  • Substitution:  4 years of professional or high-level technical experience may be substituted for the bachelor’s degree.
Preferred Qualifications:

  • 5 years of experience building ETL workflows
  • 5 years of experience building and maintaining data solutions
  • Experience with wide variety of cloud and on prem data solutions
  • Experience with ETL tools
  • Experience with data catalog technologies
  • Proficiency in common data integration patterns and processes including: ETL, APIs, streaming, flat files
  • Experience with data security and compliance
  • Experience with agile software development and managing full SDLC
  • Demonstrated ability to architect complex ETL solutions
Knowledge, Skills and Abilities:

  • Ability to work with constituents in a consultative manner, understanding business needs and translating into software requirements
  • Self-starter who is able to balance working alone with more collaborative team efforts
  • Proven track record of execution--driving results and meeting commitments
  • Technically curious and a demonstrated lifelong learner


Job Category: Information Technology
Primary Location: Aurora
Schedule: Full-time
Posting Date: Jan 21, 2021
Unposting Date: Jan 29, 2021, 12:59:00 AM

 

 

 

Diversity Profile: University

 

AAUP COMPENSATION SURVEY DATA

View more

Learn more on Inside Higher Ed's College Page for University

Arrow pointing right
Job No:
Posted: 1/23/2021
Application Due: 1/30/2021
Work Type: Full Time
Salary: