Senior Data Quality & Finance BI Analyst

Remote; San Francisco (CA); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health and dental insurance

Meal allowance

Childcare assistance

Extended paternity leave

Wellness platform access

Job summary

CI&T is seeking a Data Analyst to join a major US mortgage lender project focused on Finance data platform modernization, data quality, and reporting. You will define data quality checks, validate migrated reports, and build Power BI dashboards to keep quality visible for Finance and delivery stakeholders.

Collaboration with Finance and Data Engineering is essential to ensure reconciliations tie out and meet acceptance criteria.

Qualifications

• 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).

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.

Skills

SQL

Data quality

Power BI

Data analysis

Tools

dbt tests

Great Expectations

Snowflake

Job description

CI&T is seeking a Data Analyst to join a major US mortgage lender project focused on Finance data platform modernization, data quality, and reporting. You will define data quality checks, validate migrated reports, and build Power BI dashboards to keep quality visible for Finance and delivery stakeholders.

Collaboration with Finance and Data Engineering is essential to ensure reconciliations tie out and meet acceptance criteria.