Senior Data Analyst (Data Quality & Reporting), Colombia

Ciandt; Colombia; Hybrid; COP 90,000,000 - 140,000,000; Full time

Benefits offered by this job

Premium Healthcare

Meal Voucher

Maternity Leave

Parental Leave

Mobile Subsidy

Sick Pay

Life Insurance

CI&T University

Colombian Holidays

Paid Vacations

Job summary

A CI&T busca um(a) Senior Data Analyst com foco em qualidade de dados e reporting para modernizar uma grande plataforma financeira em colaboração com um grande mutuário dos EUA. O papel envolve validar dados, reconciliações e dashboards de finanças, assegurando alinhamento com benchmarks.

Você trabalhará com equipes de finanças e entrega, definindo critérios de aceitação, executando validações e gerando evidências de entrega com documentação clara para handoffs bem-sucedidos.

Qualifications

• Experiência como analista de dados ou BI analista; forte SQL.
• Experiência prática em criar/validar relatórios/dashboards em Power BI ou ferramenta equivalente.
• Experiência com framework de qualidade de dados ou reconciliação (ex.: dbt tests, Great Expectations).
• Experiência com dados contábeis e reconciliação de períodos fechados.
• Atenção aos detalhes e documentação clara de achados de qualidade de dados.
• Inglês fluente (Nível B2) para coordenação com clientes.
• Experiência com data warehouse na nuvem (Snowflake preferencial).

Responsibilities

• Definir e executar checagens de qualidade de dados e lógica de reconciliação contra a camada de dados curada.
• Validar relatórios e dashboards migrados para paridade com saídas de fontes legadas.
• Investigar problemas de qualidade de dados e variâncias com Data Engineering.
• Construir e manter dashboards de qualidade de dados em Power BI ou ferramenta equivalente.
• Definir critérios de aceitação e limiares de qualidade com stakeholders de finanças e entrega.
• Produzir evidências de aceitação (reconciliação, comparações paralelas, pacotes de assinatura).
• Documentar regras de qualidade de dados para o time do cliente manter após a entrega.

Skills

SQL

Power BI

Data quality

Data reconciliation

Attention to detail

Documentation

Fluent English

Tools

dbt tests

Great Expectations

Snowflake

Job description

Este site está equipado com recursos de acessibilidade. Pressione option+c para ativar o perfil cego ou option+p para acessar o menu de acessibilidade e ajuste a experiência de navegação de acordo com suas necessidades. Skip to main content

Senior Data Analyst (Data Quality & Reporting), Colombia

At CI&T, we help large enterprises transform the potential of AI into real business impact with AI Deployment, AI-native execution, and tech-integrated business solutions.

With 30 years of experience in technological transformation, we accelerate innovation with expertise in Agentic SDLC, Application modernization, Data & AI, Martech and Business strategy.

We are 8,000 CI&Ters across more than 25 countries, collaborating to build solutions with real impact. AI is already part of how we work, evolve, and innovate every day.

About Us:

At CI&T, our rapid growth is fueled by the innovative solutions we create for our global clients. We are seeking a Data Analyst with a focus on data quality and reporting for a large-scale Finance data platform modernization at a major US mortgage lender — making sure the curated data and reports built on the new platform are correct and tie out to trusted Finance benchmarks. Pipeline-level monitoring and CI/CD are owned by the DataOps Engineer; this role is about the data and the numbers, not the pipeline mechanics.

Responsibilities:

• Define and run data quality checks and reconciliation logic against the curated data layer, comparing results to approved Finance benchmarks and closed accounting periods.
• Validate migrated and re-pointed reports and dashboards for parity against their prior legacy-source output, including parallel-run comparisons during cutover — running old and new side by side and confirming they tie out within agreed tolerance.
• Profile and investigate data quality issues and reconciliation variances, working with Data Engineering to identify and document root cause.
• Build and maintain data quality dashboards/reports in Power BI (or the equivalent BI tool) so quality status and known variances stay visible to Finance and delivery stakeholders on an ongoing basis.
• Partner with Finance and business stakeholders to define acceptance criteria and quality thresholds for each reporting deliverable.
• Produce the acceptance evidence — reconciliation results, parallel-run comparisons, sign-off packages — required at each delivery gate, including the cutover gate.
• Document data quality rules and known issues in a form the client's own team can maintain post-handoff.

Requirements:

• Solid experience as a data analyst or BI analyst, with strong hands‑on SQL for querying, validating, and reconciling data.
• Hands‑on experience building or validating reports/dashboards in Power BI or a comparable enterprise BI tool.
• Experience with a data‑quality or reconciliation framework or methodology (e.g. dbt tests, Great Expectations, or a structured manual reconciliation practice).
• Experience working with accounting data and closed‑period reconciliation constraints.
• Strong attention to detail and clear written documentation of data quality findings.
• Fluent English (B2) — coordinates quality findings and evidence directly with client stakeholders at delivery gates.
• Experience with a cloud data warehouse (Snowflake preferred).

Nice to Have:

• Experience with financial/GL reporting domains (chart of accounts, dimensions, close process).
• Experience validating report or dashboard migrations off a legacy source system onto a new platform.
• Experience in mortgage, lending, or financial‑services reporting.

Our benefits include:

• Premium Healthcare
• Meal voucher
• Maternity and Parental leaves
• Mobile services subsidy
• Sick pay-Life insurance
• CI&T University
• Colombian Holidays
• Paid Vacations And many others.

Collaboration is our superpower, diversity unites us, and excellence is our standard. We value diverse identities and life experiences, fostering a diverse, inclusive, and safe work environment. We encourage applications from diverse and underrepresented groups to our job positions.