CX Insights - Data Analyst II

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

We are seeking a Data Analyst II to join our Client Experience (CX) team in League City, TX. This position actively designs, integrates, and maintains client data systems and analytical deliverables within the Client Experience (CX) Analytics & Operations function. The Data Analyst II executes data ingestion, hygiene, and reporting activities; supports the operation of client data infrastructure and connected systems including the Voice of Client (VOC) platform; and contributes to test, brand, marketing, and client research analyses. The position works collaboratively with team members and stakeholders to ensure data accuracy, consistency, and usability across CX initiatives.

What You'll Do:

• Createsand executesplansfordata ingestion, transformation, and quality tasks within client data systems and connected platforms.
• Supports client identity resolution and unique client identifier maintenance, including monitoring of data hygiene rules and exception handling.
• Develops andmaintainsdata flows,inclcuingcomplex and newflows,between client data systems and downstream or upstream systems, including the VOC platform (Qualtrics) and reporting environments.
• Buildsa variety ofreports, dashboards, and basic analytical models to support CX, brand, and marketing initiatives,demonstratingcreativity andcustomization for the intended audience
• Performsin-depthquality assurance and validation of data and analytical deliverables for completeness and accuracy.
• Documents data flows, business rules, and analytical processes for ongoing reference.
• Responds toa variety ofad-hoc data and reporting requests from CX team members and business partners.
• Creates and conductstests and studies, including data preparation, baseline analyses, and documentation of study assumptions and limitations.
• Participates in research, brand, and marketing studies in a supporting analytical capacity.
• Tracks work frominceptionthrough development, testing, and end-user communication.

What You'll Bring:

• Bachelor's degree.
• Two to four years of experience.
• Additional Qualifications:
  • Equivalent work experience in a business, analytical, or technical environmentmaybeconsidered in lieu of aBachelor'sdegree.
  • Experience working with data from multiple sources, building reports, and supporting analytical solutions.
  • Experience with data quality, data cleansing, and data transformation best practices.
  • Familiarity with structured testing and study methodologies, including hypothesis development and study documentation.
  • Advanced Excel knowledge.
  • Intermediate understanding of data modeling, testing, data visualization, and reporting conceptsand tools.
  • Knowledge of basic business processes and the client experience lifecycle.
  • Familiarity with both on-premises and cloud-based data systems, tools, and services.

What Will Set You Apart:

• Exposure to client data platforms and connected systems, or comparable MDM/Client 360 platforms.
• Familiarity with Voice of Client (VOC) and survey platforms such as Qualtrics.
• Experience writing basic Structured Query Language (SQL) and/or Python for data analysis.
• Intermediate understanding of business intelligence and visualization tools such as Power BI or Tableau.
• Strong analytical, creative, and detail-oriented thinking skills.
• Interest in evolving and improving client data and analytics capabilities over time.