[Job-31838] Senior Data Analyst (Data Quality & Reporting), Colombia

Ciandt; Colombia; Remote; COP 100,440,000 - 156,240,000; Full time

Benefits offered by this job

Premium Healthcare

Meal voucher

Maternity and Parental leaves

Mobile services subsidy

Sick pay-Life insurance

CI&T University

Colombian Holidays

Paid Vacations

Job summary

CI&T seeks a Data Analyst focused on data quality and reporting for a major Finance data platform modernization with a US mortgage lender. You will ensure data accuracy and tie-out to benchmarks, supporting parallel-run comparisons during cutover.

You will build data quality dashboards in Power BI, apply dbt/Great Expectations style checks, and document findings for client stakeholders at delivery gates.

Qualifications

• Solid experience as a data analyst or BI analyst.
• Hands-on SQL for querying, validating, and reconciling data.

Responsibilities

• Define and run data quality checks and reconciliation logic against the curated data layer.
• Validate migrated and re-pointed reports and dashboards for parity with prior outputs.
• Profile and investigate data quality issues and reconciliation variances with Data Engineering.
• Build and maintain data quality dashboards/reports in Power BI or equivalent BI tool.
• Partner with Finance and stakeholders to define acceptance criteria and quality thresholds for reports.
• Produce acceptance evidence at each delivery gate, including cutover.
• Document data quality rules and known issues for post-handoff maintenance.

Skills

SQL querying

Power BI

Data quality

Accounting data

Detail-oriented

English B2

Snowflake

Tools

dbt

Great Expectations

Snowflake

Job description

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.

#LI-TO1

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.