Data & Integration Analyst

University of Colorado Boulder; Boulder (CO); On-site; USD 90,000 - 130,000; Full time

Job summary

University of Colorado Boulder is seeking a Data & Integration Analyst within the Office of Information Technology. You will implement and support enterprise CRM data and integration solutions, enabling campus processes, reporting, analytics, and cross-system data exchange.

As an individual contributor, you will migrate data, map source-to-target schemas, validate quality, and collaborate with the CRM Data Architect, Salesforce DevOps, product managers, and data stewards to ensure scalable data

Qualifications

• No formal qualifications listed in the ad.

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.
• 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.
• Maintain documentation supporting data steward approvals and governance processes.
• 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

Job Summary

The Office of Information Technology encourages applications for a

Summary

Job Summary

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 Characteristics

• Individual 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.

Vision

Who We Are

• 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 with
• Avid curiosity in how to better support the campus and our partners while
• Fostering empowerment and authentic engagement among ourselves and
• Celebrating 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 experience
• Enable research competitiveness and
• Deliver core infrastructure and enterprise IT services for business effectiveness.

Responsibilities

What 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.

What You Should Know

• This position is working in