DenverRecruiter Since 2001
the smart solution for Denver jobs

Principal Data Architect

Company: University of Colorado
Location: Denver
Posted on: May 27, 2023

Job Description:

Principal Data Architect
University of Colorado Denver
Principal Data Architect - 29267 University Staff Description
Who We Are:
System Administration, which also houses the Office of the President, is located in the uptown neighborhood of Denver with a few smaller offices located on the campuses. Many of our departments support the educational and research missions of the four University of Colorado campuses, but System Administration is not considered a campus. We provide diverse opportunities for professional development, innovation, and collaboration with talented staff and faculty. Learn more about CU System Administration ( .
University Information Services (UIS) provides technical services and enterprise applications to the University of Colorado campuses and the Office of the President. UIS is committed to excellence in customer service and technical expertise. Through the development of enterprise applications, UIS supports the University as a whole with systems used by students, faculty, human resources employees, finance employees, and others.
Position Summary:
The Principal Data Architect oversees data architecture primarily for the University's customer relationship management (CRM) instances that are part of our Transformation and Innovation Program (TIP). This position plays a key role in mapping and implementing data transformations from PeopleSoft and other enterprise system schemas into an Education Data Architecture (EDA). In addition to this, this position is involved in data aggregation, warehousing, integration, and archiving of data for our other data domains. The Principal Data Architect often operates as an internal consultant to assist project technical and functional leads in design, approach, and tool selection for data-oriented projects.
The Principal Data Architect reports to the Manager of Enterprise Data Architecture and is exempt from the State of Colorado Classified Staff system.
Where You Will Work:
This position has the ability to work remotely within the United States.
Diversity and Equity:
The University of Colorado System Administration Office is committed to recruiting and supporting a diverse workforce. The university strives to promote a culture of inclusiveness, respect, communication and understanding. We encourage applications from women, ethnic minorities, persons with disabilities, persons within the LGBTQ+ community and all veterans.
Duties & Responsibilities:
Duties and responsibilities of the position include, but are not limited to:
Primary Responsibilities:

  • Creates, maintains, and extends canonical data models across multiple CRM domains at the University.

  • Works and coordinates with stakeholders both within and without UIS to negotiate data architecture outcomes that satisfy customer needs and support CU's long-term business goals.

  • Manages end to end data analysis, modeling, and development.

  • Develops conceptual, logical, and physical data models; design data access layer specifications and communicate design for implementation.

  • Designs, creates, tests, and tunes database objects to be used by various applications, such as MuleSoft, neo4j, Heroku, and graphQL.

  • Analyze and tune database queries for performance and understand core database functions that support the data models, such as Golden Gate replication, triggers, and database security.

  • Support application developers and power users by utilizing MuleSoft, neo4j, graphQL, and Heroku to access data.

  • Acts as an expert in the issues and benefits that arise at the confluence of enterprise data, including data from student systems, HR systems, finance/grants systems, advancement operations, and University-wide CRM systems.

  • Designs and leads a multi-year CRM architecture roadmap, balancing short and long term goals and investments to scale and deliver our solutions globally and fulfill the organization's high-level reporting & analytics needs.

  • Builds out the company's CRM architecture framework for making data accessible to all roles at CU System Administration.

  • Integrates new data sources into CU System Administration's data infrastructure as the company iterates its toolsets.

  • Assist in the development of the CU's data governance policies.

  • Leads the development of data dictionaries and diagrams for CU stakeholders.

  • Manage and monitor requests to internal engineering teams for production data improvements and requests to internal tool admins for process improvements to generate better data.

  • Acts as the go-to source for data architecture knowledge throughout the CU System Administration.

  • Creates data models that support CRM instances and meets with end users to understand requirements.

  • Researches source systems to find data to build the data mart.

  • Models data to line up with CRM application objects.

  • Collaborates with the integrations team to create integrations to and from the source and target systems.

  • Creates views to support CRM objects.

  • Defines and enables a technology solution selection framework, including the framework principles such as modularization, standardization, a reuse of technologies.

  • Makes recommendations on integrations strategies, platforms, and application infrastructure required to implement solutions.

  • Develops metrics to measure data quality.

    Secondary Responsibilities:

    • Makes recommendations on integration strategies, enterprise architectures, platforms, and application infrastructure required to successfully implement a complete solution.

    • Executes proof-of-concept or innovation oriented technical efforts and projects to evaluate options, prove out the viability of new technologies or approaches, and the ability to articulate outcome to UIS and campus constituents.

    • Consults with campuses on any business glossary/data definitions work.

    • Designs a data mart from scratch, including:

    • Works with end users on requirements

    • Understands the data that exists in the course systems

    • Creates a data model of facts and dimensions in this mart

    • Tests the data mart

    • Works with data stage team to find out how to load data

    • Creates designs and documentations for the data mart

    • Works with end users to create queries to use and view data

      What We Offer:
      Salary: The anticipated hiring range has been established at $108,000.
      The salary of the finalist(s) selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training.
      The above salary range (or hiring range) represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.
      Benefits: The University of Colorado offers an excellent benefits package including:

      • Medical: Multiple plan options

      • Dental: Multiple plan options

      • Additional Insurance: Disability, Life, Vision and Wellness

      • Retirement 401(a) Plan: Employer contributes 10% of your gross pay

      • Paid Time Off: Accruals over the year

      • Vacation Days: 22

      • Sick Days: 15

      • Holiday Days: 10

      • Tuition Benefit: System employees have the benefit on all campuses

      • ECO Pass: RTD Bus and light rail service

      • Additional Perks & Programs: Click here to access a few more Perks and Programs (

        Click here to access our Total Compensation Calculator ( to see what your total rewards could be at CU. This position is a University Staff position.
        Additional taxable fringe benefits may be available.
        More information on benefits programs, including eligibility, is available at ( .
        Minimum Qualifications:
        Please ensure your resume includes any and all relevant experience to be accurately assessed against these qualifications. You must meet all minimum requirements listed at the time of application to be considered for this role.

        • Bachelor's degree from and accredited institution of higher education, or equivalent professional experience (professional experience may be substituted for the educational requirement on a year-for-year basis)

        • Four (4) years' database development and administration experience, which includes the following:

        • Experience leveraging delivered database schemas to achieve business goals with increasing levels of responsibility.

        • Experience with Oracle Databases, writing queries, working with views, etc.

        • Data modeling experience.

          Preferred Qualifications:

          • Six (6) years' database development and administration experience, including data modeling, as indicated above.

          • Experience with neo4j or graphQL.

          • Experience with one or more of the following:

          • Working in higher education

          • Integration architectures

          • Data analysis

          • Data quality and modeling tools

          • Building and administering data marts

            Knowledge, Skills, and Abilities:
            To be successful in this position, employees will need to know the following:

            • Ability to conceive and portray the big data picture.

            • Ability to perform detailed data analysis, find patterns, and coalesce different data sources.

            • Ability to design, create, test, and tune database objects to be used by various applications, such as MuleSoft, neo4j, and graphQL

            • Ability to create and maintain comprehensive data models

            • Ability to collect and document business needs and translate into technical specifications

            • Documentation skills to communicate data models, integration patterns, data dictionaries, and data lineage within CU System Administration as well as to customers

            • Ability to write technical documentation, reports, briefings, and specifications understood by a variety of technical and non-technical audiences

            • Ability to translate and explain technical concepts and vocabulary in common terms to non-technical audiences

            • Organizational skills, including the ability to set and meet goals and deadlines, manage appointments, create schedules, coordinate and facilitate meetings, and make decisions

            • Ability to work under pressure, manage multiple concurrent and competing tasks and responsibilities, and adapt to changing priorities while maintaining personal effectiveness, focusing on activities that have the greatest impact on meeting work commitments

            • Ability to work independently with minimal supervision and reliable professional judgment, as well as collaboratively with a team to achieve desired results

            • Ability to maintain a strong work ethic, positive problem-solving attitude, and enthusiasm for the work performed

            • Ability to self-start and take initiative in completing daily tasks and special projects

            • Ability to navigate a complex political environment

            • Knowledge of the business and organizational structure of CU

            • Ability to communicate and work effectively with individuals from diverse backgrounds, cultures, and ages

            • Interpersonal skills, including the ability establish and maintain partnerships with internal and external constituencies and the ability to facilitate interaction, communication, and teamwork between others

            • Oral, written, and listening communication skills, including the ability to accurately interpret what others are saying and convey messages, information, concepts, and details accurately and clearly

            • Technical Computer skills - including the ability to utilize Microsoft Office programs, the knowledge of common computer operating systems and networking fundamentals, and the ability to assess complex data

            • Computer programming skills - including the ability to evaluate and solve problems, stay organized, be cognizant of and address details, and utilize common database tools such as TOAD or SQL Developer

            • Knowledge of information technology service management (ITSM) principles and best practices

            • Ability to learn and apply new technologies

              How to Apply:
              For full consideration, please attach the following as separate documents to your application:

              • A cover letter identifying the job specific minimum qualifications you possess

              • A resume including any and all relevant experience to be accurately assessed against the qualifications listed in the posting.

                Please ensure you check the "Job Specific Attachments" box next to each document on the "Required Documents" page of the application for the appropriate documents to be attached.
                When to Apply:
                For full consideration completed applications must be submitted by March 31, 2023. Reference checking is a standard step in our hiring process. You may be asked to provide contact information, including email addresses, for up to five references as part of the search process for this position. Please note: All application materials must be submitted through CU Careers; emailed materials will not be considered.
                Background Check Statement:
                The University of Colorado is committed to providing a safe and productive learning and living community. To achieve that goal, we conduct background investigations for all final applicants being considered for employment. Background investigations include a criminal history record check, and when appropriate, a financial and/or motor vehicle history. The Immigration Reform and Control Act requires that a verification of employment eligibility be documented for all new employees by the end of the third day of work. The University of Colorado is committed to diversity and equality in education and employment.
                ADA Statement:
                We are committed to an inclusive and barrier-free search process. We provide accommodations for applicants requesting accommodation through the search process such as alternative formats of this posting. Individuals with disabilities in need of accommodations throughout the search process should contact the ADA Coordinator at: ( .
                Application Materials Required: Cover Letter, Resume/CV Job Category
                : Information Technology Primary Location
                : Denver Department: S0001 -- System Administration - 50119 - University InformationServices Schedule
                : Full-time Posting Date
                : Mar 21, 2023 Unposting Date
                : Ongoing Posting Contact Name: System HR Posting Contact Email: ( Position Number: 00785697
                To apply, please visit: (
                Copyright 2022 Inc. All rights reserved.
                Posted by the FREE value-added recruitment advertising agency (

Keywords: University of Colorado, Denver , Principal Data Architect, Education / Teaching , Denver, Colorado

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Colorado jobs by following @recnetCO on Twitter!

Denver RSS job feeds