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
(https://apptrkr.com/get_redirect.php?id=4024512&targetURL=https://www.cu.edu/cu-careers/cu-system)
.
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
(https://apptrkr.com/get_redirect.php?id=4024512&targetURL=https://www.cu.edu/cu-careers/perks/cu-system)
Click here to access our Total Compensation Calculator
(https://apptrkr.com/get_redirect.php?id=4024512&targetURL=https://www.cu.edu/node/153125)
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 www.cu.edu/employee-services/
(https://apptrkr.com/get_redirect.php?id=4024512&targetURL=http://www.cu.edu/employee-services/)
.
Qualifications:
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: systemhr@cu.edu
(https://apptrkr.com/get_redirect.php?id=4024512&targetURL=systemhr@cu.edu)
.
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:
SystemHR@cu.edu
(https://apptrkr.com/get_redirect.php?id=4024512&targetURL=SystemHR@cu.edu)
Position Number: 00785697
To apply, please visit:
https://cu.taleo.net/careersection/2/jobdetail.ftl?job=29267&lang=en
(https://apptrkr.com/4024512)
Copyright 2022 Jobelephant.com Inc. All rights reserved.
Posted by the FREE value-added recruitment advertising agency
(https://www.jobelephant.com/)
jeid-abc3a6f7f168e64699f84be1fb7d047c
Keywords: University of Colorado, Denver , Principal Data Architect, Education / Teaching , Denver, Colorado
|
Click
here to apply!
|
