Data & Integration Analyst 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. 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 Are Vision: 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. What Your Key Responsibilities Will Be CRM Data Migration, Integration Support, and Data AnalysisComplete 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 SupportDevelop 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 StandardsDevelop 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 CollaborationElicit 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 DevelopmentMaintain 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 a hybrid work situation, working primarily remotely. Visa sponsorship is not available for this position.
What We Can Offer: The annual salary range is $99,700 - $109,660.
Benefits:
At the University of Colorado Boulder, we are committed to supporting the holistic health and well-being of our employees. Our comprehensive benefits package includes medical, dental, and retirement plans; generous paid time off; tuition assistance for you and your dependents; and an ECO Pass for local transit. As one of Boulder County's largest employers, CU Boulder offers an inspiring academic community and access to world-class outdoor recreation. In fact, CU Boulder has been named one of Forbes' America's Best Large Employers, ranking #4 among large employers in Colorado and #28 among universities nationwide. Explore additional perks and programs through the CU Advantage program. Be Statements Be authentic. Be excited. Be Boulder. What We Require Bachelor's degree from an accredited institution in information systems, computer science, data analytics, information technology, business analytics, or a related field. A combination of education and relevant professional experience may substitute for the degree on a year-for-year basis. Three (3) years of professional experience in one or more of the following: data analysis, data engineering, CRM administration or support, systems integrations, business systems implementation, or enterprise application support. Including at least two years of professional experience: Working with enterprise data integrations, data migration initiatives, or ETL/ELT processes. Working with Salesforce platforms (such as Education Cloud, Sales Cloud, Service Cloud, Marketing Cloud, etc.) and CRM ecosystem concepts, including data models, integrations, reporting, and business process automation. Experience writing and troubleshooting SQL queries and working with relational data structures. Experience supporting or participating in data integration, ETL (Extract, Transform, Load), ELT (Extract, Load, Transform), or data migration initiatives.
What You Will Need:
Strong verbal and written communication skills. Demonstrable ability to communicate proactively, collaborate across teams, take ownership of assigned work, and provide timely transparency into progress, risks, and issues. Experience facilitating requirements gathering and technical discovery sessions. Knowledge of data migration methodologies and reconciliation practices. Understanding of data quality management principles. Ability to analyze business processes and translate requirements into technical solutions. Solid understanding of Salesforce platform concepts, including CRM data models, integrations, reporting, security, and business process automation. Knowledge of relational databases, data modeling concepts, and data lineage practices. Understanding of API and system integration concepts. Experience with scripting or automation technologies such as Python or similar languages. Knowledge of ETL/ELT processes, data ingestion patterns, transformation logic, and enterprise data pipeline concepts. Ability to design and implement testing strategies and validation plans. Strong analytical, troubleshooting, and problem-solving skills. Ability to document technical