Data Analyst – Clustrex Data

Opportunity Overview

Data Governance & Analytics Operations Cycle

The Data Analyst at Clustrex balances core reporting deliverables with system-level data governance, master data management, and data warehouse integrity:

┌───────────────────────────────────────────┐
│ 1. Master Data Management & Governance    │ ➔ Manage user roles, dataset provisioning, master records (create/update/delete)
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 2. Data Cleansing & Quality Assurance     │ ➔ Validate imported feeds, execute data cleansing, ensure data integrity
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 3. Reporting Architecture & Warehousing   │ ➔ Design reporting environments, manage metadata, update data warehouse models
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 4. BI Dashboarding & End-User Enablement  │ ➔ Develop Tableau/Excel dashboards, troubleshoot reporting databases, train users
└───────────────────────────────────────────┘

Key Responsibilities

• Master Data Management (MDM): Maintain enterprise master datasets, manage record lifecycles (creation, updates, decommissioning), and enforce security/user permissions.

• Data Quality Assurance & Cleansing: Execute data cleansing, mining, and normalization procedures; collaborate with QA teams to validate raw data imports.

• Reporting Environment Design: Architect and maintain the BI environment, overseeing metadata standards, data source security, and warehouse integration.

• Dashboard & Insight Generation: Produce multi-system reports and interactive dashboards using Tableau and Advanced Excel for internal and client decision-making.

• System Upgrades & Technical Support: Test, assess, and implement new analytics software upgrades; troubleshoot database environments and train end-users.

Qualification Matrix & Technical Skill Stack

Core Requirements

Key Focus Areas for Interview Preparation

1. Master Data Management & Data Governance: Be prepared to discuss best practices for data validation, handling confidential information, and maintaining schema integrity across multi-tenant environments.

2. SQL & Data Cleansing Mechanics: Practice queries focused on identifying duplicate records, reconciling inconsistent data types, and handling null values in multi-source data warehouses.

3. Data Warehousing & BI Architecture: Review concepts related to metadata management, dimensional modeling, and troubleshooting reporting environment performance issues.