Data & Integration Analyst

University of Colorado; Colorado; On-site; USD 85,000 - 110,000; Full time

Job summary

University of Colorado's Office of Information Technology seeks a Data & Integration Analyst to implement, validate, document, and support enterprise CRM data and integration solutions that enable CU Boulder business processes, reporting, analytics, and cross-system data exchange.

In this individual contributor role, you will partner with the CRM Data Architect, Salesforce DevOps, product managers, data stewards, and enterprise teams to translate requirements into scalable data solutions.

Responsibilities

• Complete data migration activities supporting CRM platform implementation and ongoing system enhancements.
• Develop and maintain source-to-target mappings for CRM and related enterprise systems.
• Support data extraction, transformation, loading, validation, and reconciliation activities.
• Assist with implementation and support of Salesforce Data Cloud data ingestion and data model activities.
• Coordinate with UIS Integration Services and Data Engineering teams regarding enterprise integrations and data flows.
• Support integration implementation and operations through analysis, testing, monitoring, troubleshooting, validation, and documentation.
• Translate business requirements and solution designs into technical specifications, mapping documents, implementation plans.
• Participate in solution design discussions and provide recommendations regarding data quality, integration patterns, and system interoperability.
• Develop and implement test plans related to data migration, integrations, and data quality initiatives.
• Perform reconciliation and validation activities to ensure data accuracy and completeness across systems.
• Perform root cause analysis and recommend improvements to resolve data incidents and strengthen data quality, automation, monitoring, and operational processes.
• Support CRM reporting, analytics, data quality, and governance initiatives in collaboration with business partners and data stewards.
• Develop and maintain source-to-target mappings, data migration specifications, integration documentation, business rules, transformation logic, data lineage artifacts, and technical operating procedures.
• Maintain documentation supporting data steward approvals and governance processes.
• Contribute to the development of standards, protocols, reusable assets, and operational procedures.
• Facilitate knowledge transfer across technical and business teams.
• Elicit and document technical and business requirements related to CRM data and integrations.
• Facilitate discussions with business partners to understand business processes, data needs, and operational requirements.
• Assist with finding opportunities for process improvement and data optimization.
• Partner with Product Managers, Business Analysts, DevOps, and Architects to align technical solutions with business objectives.
• Maintain expertise in CRM technologies, enterprise integrations, data engineering practices, Data Cloud concepts, and higher education technology trends.
• Participate in professional development activities, conferences, training, certifications, and peer networking opportunities.

Job description

The Office of Information Technology encourages applications for a Data & Integration Analyst! This role is responsible for implementing, validating, documenting, and supporting enterprise CRM data and integration solutions that enable University of Colorado Boulder business processes, reporting, analytics, and cross-system data exchange.

This position serves as a key technical partner to the CRM Data Architect, the Salesforce DevOps team, product managers, business analysts, data stewards, campus partners, and enterprise integration teams.The Analyst supports data migration, source-to-target mapping, data quality management, integration implementation, testing, reconciliation, and Salesforce Data Cloud / Data 360 initiatives.

The CRM Data & Integration Analyst translates business and technical requirements into executable solutions and ensures CRM data assets remain accurate, reliable, well-documented, and scalable.

This role operates as an individual contributor with responsibility for implementing and supporting enterprise CRM data capabilities while helping reduce single-person dependencies across CRM data architecture, integrations, and data operations.

Key Position CharacteristicsIndividual contributor role with campus-wide impact.Serves as an implementation partner and operational backup to the CRM Data Architect.Works across technical implementation, business analysis, testing, documentation, and operational support.

CU is an Equal Opportunity Employer and complies with all applicable federal, state, and local laws governing nondiscrimination in employment. We are committed to creating a workplace where all individuals are treated with respect and dignity, and we encourage individuals from all backgrounds to apply, including protected veterans and individuals with disabilities.

Who We AreWho We AreVision:

The Office of Information Technology is a strategic, inclusive and innovative partner in advancing learning and discovery in order to enable CU Boulder to be a premier public university.

Mission:

The Office of Information Technology enables campus priorities by providing high-value IT services and solutions.

Values:

Trust, as a foundation for how we engage with one another and with campus partners, along withAvid curiosity in how to better support the campus and our partners whileFostering empowerment and authentic engagement among ourselves andCelebrating inclusivity that promotes a sense of belonging while acknowledging that each person is unique and valued.

Strategy:

OIT will advance learning and discovery by delivering high-value reliable IT services and solutions that:Provide a fluid and adaptable academic and student experienceEnable research competitiveness andDeliver core infrastructure and enterprise IT services for business effectiveness.

What Your Key Responsibilities Will BeWhat Your Key Responsibilities Will Be

CRM Data Migration, Integration Support, and Data Analysis

• Complete data migration activities supporting CRM platform implementation and ongoing system enhancements.
• Develop and maintain source-to-target mappings for CRM and related enterprise systems.
• Support data extraction, transformation, loading, validation, and reconciliation activities.
• Assist with implementation and support of Salesforce Data Cloud data ingestion and data model activities.
• Coordinate with UIS Integration Services and Data Engineering teams regarding enterprise integrations and data flows.
• Support integration implementation and operations through analysis, testing, monitoring, troubleshooting, validation, and documentation.
• Translate business requirements and solution designs into technical specifications, mapping documents, implementation plans.
• Participate in solution design discussions and provide recommendations regarding data quality, integration patterns, and system interoperability.

Data Quality, Validation, Testing, and Operational Support

• Develop and implement test plans related to data migration, integrations, and data quality initiatives.
• Perform reconciliation and validation activities to ensure data accuracy and completeness across systems.
• Perform root cause analysis and recommend improvements to resolve data incidents and strengthen data quality, automation, monitoring, and operational processes.
• Support CRM reporting, analytics, data quality, and governance initiatives in collaboration with business partners and data stewards.

Documentation, Knowledge Management, and Standards

• Develop and maintain source-to-target mappings, data migration specifications, integration documentation, business rules, transformation logic, data lineage artifacts, and technical operating procedures.
• Maintain documentation supporting data steward approvals and governance processes.
• Contribute to the development of standards, protocols, reusable assets, and operational procedures.
• Facilitate knowledge transfer across technical and business teams.

Business Analysis and Stakeholder Collaboration

• Elicit and document technical and business requirements related to CRM data and integrations.
• Facilitate discussions with business partners to understand business processes, data needs, and operational requirements.
• Assist with finding opportunities for process improvement and data optimization.
• Partner with Product Managers, Business Analysts, DevOps, and Architects to align technical solutions with business objectives.

Professional Development

• Maintain expertise in CRM technologies, enterprise integrations, data engineering practices, Data Cloud concepts, and higher education technology trends.
• Participate in professional development activities, conferences, training, certifications, and peer networking opportunities.