Senior Data Analyst (Data Quality & Reporting), Colombia

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.