Principal Data Architect

$116,000 - $120,000/Yr

University of Colorado - Denver, CO

Full-time - Senior

Denver, CO

Educational Services

About the position

The Principal Data Architect is responsible for data architecture primarily for the University's customer relationship management (CRM) instances and GraphQL APIs maintained by our Integration Platform team. This position plays a key role in mapping and implementing data transformations from PeopleSoft and other enterprise system schemas into a Salesforce Education Cloud Data Architecture. 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 Integration Platform Manager and is exempt from the State of Colorado Classified Staff system.

Responsibilities

• Creates, maintain, and extends University canonical data models for UIS and campus partners to access enterprise data.
• Works and coordinates with key partners both within and without UIS to collaborate closely and secure data architecture outcomes that satisfy customer needs and support CU's long-term business goals.
• Handles 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, Snowflake, and GraphQL.
• Analyze and tune database queries for performance and understand core database functions that support the data models, such as GoldenGate replication, triggers, and database security.
• Support application developers and power users by using MuleSoft, Neo4j, Snowflake, and GraphQL 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.
• Contributes to the organization's canonical data 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 University iterates its toolsets.
• Assist in the development of the CU's data governance policies.
• Leads the development of data dictionaries and diagrams for CU partners.
• Supervise requests to internal engineering teams for production data improvements and requests to internal tool admins for process improvements to generate better data.
• Acts as a resource for data architecture knowledge throughout the CU System Administration.
• Researches source systems and leverages domain experts and business analysts to find data to build the data mart.
• Collaborates with the integrations team to create integrations to and from the source and target systems.
• Creates and maintains complex data transformation views to support canonical 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.
• Crafts evaluation methods to measure data quality.

Requirements

• Bachelor's degree from an accredited institution of higher education, or equivalent professional experience.
• Four (4) years' database development experience, including experience leveraging delivered database schemas to achieve business goals.
• Experience with relational databases, writing queries, working with views, writing stored procedures, etc.
• Data modeling experience.

Nice-to-haves

• Six (6) years' relational database development experience, including data modeling.
• Experience with Snowflake cloud-based data platform.
• Experience with Neo4j or GraphQL.
• Experience with Liquibase data schema deployment automation.
• Experience with software development lifecycle and deployment tools such as git, GitLab or GitHub, and Continuous Development/Continuous Integration (CI/CD) tools and concepts.
• Experience with working in higher education, integration architectures, data analysis, data quality and modeling tools, and building and administering data marts.

Benefits

• No-cost or low-cost medical & dental plan options, some inclusive of IVF assistance.
• Disability, Life, Vision Insurance options.
• Multiple retirement planning options including a mandatory 401(a) plan where CU contributes 10% of your gross pay, a 401k or 403b plan and a 457 deferred compensation plan.
• Pre-tax savings plans, such as Health care and Dependent care flexible spending accounts.
• Ample sick and vacation leave, along with at least 12 paid holidays, including a dedicated week off for winter break.
• 6 weeks of parental leave.
• A tuition benefit program for you and/or your dependents.
• Free RTD EcoPass and Free Onsite Parking at our 1800 Grant Street Office.