CX Data Insights Analyst II - Elevate Client Experience

Colonial Group; League City (TX); On-site; USD 65,000 - 85,000; Full time

Job summary

Colonial Group is seeking a Data Analyst II to join the Client Experience (CX) team in League City, TX. You will design, ingest, cleanse, and maintain client data systems and deliverables to support CX initiatives.

You will build reports and dashboards, validate data quality, document processes, and collaborate with stakeholders to ensure data accuracy and usability across marketing and brand programs.

Qualifications

• Bachelor's degree or equivalent work experience accepted.
• Experience with data from multiple sources and building reports.
• Strong data quality, cleansing, and transformation practices.
• Familiarity with testing methodologies and study documentation.
• Knowledge of business processes and client experience lifecycle.
• Experience with on-premises and cloud-based data systems.

Responsibilities

• Design, ingest, transform, and maintain data in client data systems and connected platforms.
• Support client identity resolution and data hygiene monitoring.
• Develop data flows between systems and VOC platform (Qualtrics) and reporting environments.
• Create reports, dashboards, and basic analytical models for CX, brand, and marketing.
• Perform QA/validation of data and analytical deliverables.
• Document data flows and business rules for reference.
• Respond to ad-hoc data and reporting requests from CX team and partners.
• Conduct tests and studies with data preparation and baseline analyses.
• Support research in brand and marketing analytics.
• Track work from inception to development, testing, and end-user communication.

Skills

Advanced Excel

SQL

Python

Data analysis

Data governance

Education

Bachelor's degree

Tools

Qualtrics

Power BI

Tableau

Job description

Colonial Group is seeking a Data Analyst II to join the Client Experience (CX) team in League City, TX. You will design, ingest, cleanse, and maintain client data systems and deliverables to support CX initiatives.

You will build reports and dashboards, validate data quality, document processes, and collaborate with stakeholders to ensure data accuracy and usability across marketing and brand programs.