Data & Integration Analyst

University of Colorado System; Allenspark (CO); Ibrido; USD 100.000 - 110.000; Tempo pieno

Vantaggi offerti da questo lavoro

Medical, dental, and retirement plans

Generous paid time off

Tuition assistance for you and your-de

ECO Pass for local transit

Descrizione del lavoro

University of Colorado Boulder is seeking a Data & Integration Analyst to implement, validate, document, and support enterprise CRM data and integration solutions. You will partner with the CRM Data Architect, Salesforce DevOps, and business stakeholders across campus to enable data exchange and analytics.

The role focuses on data migration, mapping, quality, and governance for CRM data assets, with hybrid work arrangements and a strong emphasis on scalable data operations.

Competenze

• Bachelor’s degree or equivalent in a related field; substitution possible with experience.
• 3+ years in data analysis, data engineering, CRM administration or data migration.
• Experience with Salesforce platforms and CRM ecosystem concepts.
• Ability to write and troubleshoot SQL queries and work with relational data.

Mansioni

• Lead CRM data migration and integration support for enterprise systems.
• Develop source-to-target mappings and data reconciliation plans.
• Support ingestion and data model activities in Salesforce Data Cloud.
• Collaborate with Product Managers, DevOps, and Architects on data solutions.
• Document data lineage, mappings, and governance procedures.

Conoscenze

Data analysis

Data migration

Data quality management

CRM data concepts

SQL queries

ETL/ELT processes

Requirements gathering

Stakeholder collaboration

Formazione

Bachelor's degree in information systems / computer science / data analytics / information technology

Strumenti

Salesforce Data Cloud

Data Cloud 360

Boomi

MuleSoft

Informatica

Snowflake

ETL tooling

Descrizione del lavoro

Job Summary

The Office of Information Technology encourages applications for a Data & Integration Analyst ! This role is responsiblefor implementing, validating, documenting, and supportingenterprise CRM data and integration solutions that enableUniversity of Colorado Boulder business processes, reporting,analytics, and cross-system data exchange. This position serves asa key technical partner to the CRM Data Architect, the SalesforceDevOps team, product managers, business analysts, data stewards,campus partners, and enterprise integration teams.

The Analyst supports data migration, source-to-target mapping, dataquality management, integration implementation, testing,reconciliation, and Salesforce Data Cloud / Data 360 initiatives.The CRM Data & Integration Analyst translates business andtechnical requirements into executable solutions and ensures CRMdata assets remain accurate, reliable, well-documented, andscalable.

This role operates as an individual contributor with responsibilityfor implementing and supporting enterprise CRM data capabilitieswhile helping reduce single-person dependencies across CRM dataarchitecture, 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 allapplicable federal, state, and local laws governingnondiscrimination in employment. We are committed to creating aworkplace where all individuals are treated with respect anddignity, and we encourage individuals from all backgrounds toapply, including protected veterans and individuals withdisabilities.

Who We Are

Vision:

• The Office of Information Technology is a strategic, inclusiveand innovative partner in advancing learning and discoveryin order to enable CU Boulder to be a premier publicuniversity.

Mission:

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

Values:

• Trust, as a foundation for how we engage with oneanother and with campus partners, along with
• Avid curiosity in how to better support the campus andour partners while
• Fostering empowerment and authentic engagementamong ourselves and
• Celebrating inclusivity that promotes a sense ofbelonging while acknowledging that each person is unique andvalued.

Strategy:

• OIT will advance learning and discovery by deliveringhigh-value reliable IT services and solutions that:
• Provide a fluid and adaptable academic and studentexperience
• Enable research competitiveness and
• Deliver core infrastructure and enterprise IT services forbusiness effectiveness.

What Your Key Responsibilities Will Be

CRM Data Migration, Integration Support, and DataAnalysis

• Complete data migration activities supporting CRM platformimplementation and ongoing system enhancements.
• Develop and maintain source-to-target mappings for CRM andrelated enterprise systems.
• Support data extraction, transformation, loading, validation,and reconciliation activities.
• Assist with implementation and support of Salesforce Data Clouddata ingestion and data model activities.
• Coordinate with UIS Integration Services and Data Engineeringteams regarding enterprise integrations and data flows.
• Support integration implementation and operations throughanalysis, testing, monitoring, troubleshooting, validation, anddocumentation.
• Translate business requirements and solution designs intotechnical specifications, mapping documents, implementation plans.Participate in solution design discussions and providerecommendations regarding data quality, integration patterns, andsystem interoperability.

Data Quality, Validation, Testing, and OperationalSupport

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

Documentation, Knowledge Management, and Standards

• Develop and maintain source-to-target mappings, data migrationspecifications, integration documentation, business rules,transformation logic, data lineage artifacts, and technicaloperating procedures.
• Maintain documentation supporting data steward approvals andgovernance processes.
• Contribute to the development of standards, protocols, reusableassets, and operational procedures.
• Facilitate knowledge transfer across technical and businessteams.

Business Analysis and Stakeholder Collaboration

• Elicit and document technical and business requirements relatedto CRM data and integrations.
• Facilitate discussions with business partners to understandbusiness processes, data needs, and operational requirements.
• Assist with finding opportunities for process improvement anddata optimization.
• Partner with Product Managers, Business Analysts, DevOps, andArchitects to align technical solutions with businessobjectives.

Professional Development

• Maintain expertise in CRM technologies, enterpriseintegrations, data engineering practices, Data Cloud concepts, andhigher education technology trends.
• Participate in professional development activities,conferences, training, certifications, and peer networkingopportunities.

What You Should Know

• This position is working in a hybrid work situation, workingprimarily 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; tuitionassistance for you and your dependents; and an ECO Pass for localtransit. As one of Boulder County’s largest employers, CU Boulder offers an inspiring academic community and access to world-classoutdoor recreation. In fact, CU Boulder has been named one of Forbes' America's BestLarge Employers , ranking #4 among large employers in Colorado and #28 among universities nationwide. Explore additional perks andprograms through the CU Advantage program.

Be Statements

Be authentic. Be excited. Be Boulder.

What We Require

• Bachelor's degree from an accredited institution in informationsystems, computer science, data analytics, information technology,business analytics, or a related field. A combination of educationand relevant professional experience may substitute for the degreeon a year-for-year basis.
• Three (3) years of professional experience in one or more ofthe following: data analysis, data engineering, CRM administrationor support, systems integrations, business systems implementation,or enterprise application support. Including at least two years ofprofessional experience:
  • Working with enterprise data integrations, data migrationinitiatives, or ETL/ELT processes.
  • Working with Salesforce platforms (such as Education Cloud,Sales Cloud, Service Cloud, Marketing Cloud, etc.) and CRMecosystem concepts, including data models, integrations, reporting, and business process automation.
  • Experience writing and troubleshooting SQL queries and workingwith relational data structures.
  • Experience supporting or participating in data integration, ETL(Extract, Transform, Load), ELT (Extract, Load, Transform), or datamigration initiatives.

What You Will Need

• Strong verbal and written communication skills.
• Demonstrable ability to communicate proactively, collaborateacross teams, take ownership of assigned work, and provide timelytransparency into progress, risks, and issues.
• Experience facilitating requirements gathering and technicaldiscovery sessions.
• Knowledge of data migration methodologies and reconciliationpractices.
• Understanding of data quality management principles.
• Ability to analyze business processes and translaterequirements into technical solutions.
• Solid understanding of Salesforce platform concepts, includingCRM data models, integrations, reporting, security, and businessprocess automation.
• Knowledge of relational databases, data modeling concepts, anddata lineage practices.
• Understanding of API and system integration concepts.
• Experience with scripting or automation technologies such asPython 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 andvalidation plans.
• Strong analytical, troubleshooting, and problem-solvingskills.
• Ability to document technical processes, requirements,mappings, and operational procedures.
• Ability to manage multiple priorities in a complexorganizational environment.

What We Would Like You to Have

• Professional experience with Salesforce Education Cloud(configuration/testing/development).
• Professional experience with Salesforce Data Cloud / Data360.
• Experience supporting large-scale CRM implementations or datamigration efforts.
• Familiarity with enterprise integration tools such as Boomi,MuleSoft, Informatica, Prefect, Workato, or comparabletechnologies.
• Experience with Snowflake or enterprise data warehouseplatforms.
• Experience creating source-to-target mapping documents andintegration specifications.
• Experience supporting higher education business processes andsystems.
• Salesforce certifications (such as Salesforce Administrator,Platform App Builder, Data Cloud Consultant, or Platform DeveloperI) are preferred.
• Experience with business analysis, requirements management, orprocess improvement initiatives.
• Experience configuring or developing Salesforce solutionsincluding Flows, Apex, or Lightning Components.

In compliance with the Colorado Job Application Fairness Act, in any materials you submit, you may redact or remove age-identifyinginformation such as age, date of birth, or dates of schoolattendance or graduation. You will not be penalized for redactingor removing this information.