We are seeking a
Data Analyst
with strong technical skills and investigative mindset to join our team. This analyst will be responsible for reviewing table-level data discrepancies, identifying likely causes, and working with engineering teams to suggest and validate monitoring or logging improvements within upstream systems.
Key Responsibilities
Analyze reconciliation delta outputs (inserts, updates, deletes) per table to identify patterns and potential causes of data mismatches between source and target systems.
Reverse-engineer data flow issues by tracing potential data quality, process timing, or transformation problems in the upstream systems.
Collaborate with engineers to understand source systems (e.g., Java-based microservices) and how data is written, transformed, or synchronized downstream.
Identify candidate fields or metadata (e.g.,
last_updated
timestamps, missing keys) that could explain discrepancies.
Propose actions to improve traceability in source systems, including:
Instrumenting logs
Capturing audit fields
Implementing or enhancing existing data lineage
Prepare concise documentation and recommendations, including summary reports of analysis findings and proposals for corrective actions.
Optionally support data validation in both source and target environments to verify resolution of previously identified issues.
(inferred)
Required Qualifications
4+ years of experience in data analysis, business intelligence, or data engineering roles with strong investigative and reporting capabilities
Strong proficiency in
SQL
for querying large datasets
Hands-on experience analyzing data within
AWS environments
, including
Athena
,
S3
, and
Glue
Working knowledge of
Python
and/or
Java
to understand data generation paths and support collaboration with development teams
Familiarity with
microservices architectures
and their implications for data persistence and synchronization
Experience analyzing operational data for root cause and working with developers to close systemic gaps (e.g., missed updates, stale reads)
📌 Data Analyst (México)
🏢 Encora
📍 México