About the role
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.