[Job-31838] Senior Data Analyst (Data Quality & Reporting), Colombia
Summary
Senior data analyst at CI&T working on data quality and reporting for a large finance data platform modernization at a major US mortgage lender. Day to day: running SQL-based quality checks and reconciliations against Finance benchmarks, validating migrated Power BI reports via parallel runs, and producing acceptance evidence for delivery gates.
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).
• Comfortable working with financial/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.
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 with a cloud data warehouse (Snowflake preferred).
• Experience in mortgage, lending, or financial-services reporting.
#LI-TO1
Skills
As published by lever · 19 questions · 1 written answer
Basics
Resume/CV, Full name, Pronouns, Email, Phone, Current location, Current company, LinkedIn URL
Short answers (5)
- How comfortable do you feel working in an English-speaking environment?
- Please, confirm country and city where you are currently living
- When will you be available to start working with us? (DD/MM/AAAA)
- If the previous answer is Yes, please share the name(s) of these individuals. optional
- Confirm the name of the company where you work/ Confirme o nome da empresa em que você trabalha atualmente
Pick from a list (13)
- [EN] What is your level of confidence when communicating and collaborating in an English-speaking work environment? optional
- [ES] What is your level of confidence when communicating and collaborating in an Spanish-speaking work environment? optional
- How did you hear about our job opening? optional
- Do you have any relatives (such as parents, siblings, in-laws, spouses, or children, stepchildren, stepfather/stepmother, son-in-law/daughter-in-law), close friends, or acquaintances (with whom you have a significant and ongoing relationship) who currently work at CI&T?
- Are you legally authorized to work in Colombia?
- Do you require any type of accessibility for the selection process and/or in your daily life??
- Will you now or in the future require sponsorship for Colombia's employment visa status?
- Would you like to tell us your gender identity? We ask about gender identity to better understand and support the diverse identities of our employees and to ensure our workplace is inclusive. optional
- Are you part of the LGBTQIAP+ community? optional
- How would you self-declare? Collecting information on ethnic backgrounds allows us to ensure our diversity and inclusion efforts are effective and to address any potential disparities. optional
- To understand better your necessities or any accommodations you need for our process & interviews, we would like to know if you are a person with disabilities? optional
- If applicable, please tell us what type of disability you have: (Edit to include options:) optional
- By selecting the option below, I declare that I have read, understood, and agree to the terms of this document, and I consent to the processing of my personal data by CI&T and Lever for the purposes described herein. Read the document here: https://drive.google.com/file/d/1dMaskYl2VD1AtN9MfiHrZiA-YFYwq8aI/view optional
Written answers (1)
- What is your salary expectation? (please inform the gross amount in Colombian Pesos)