Data Analyst
Share
Job Location:
Mexico City - Mexico
Monthly Salary:
Not Disclosed
Posted on:
20 hours ago
Vacancies:
1 Vacancy
Job Summary
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.
lastupdatedtimestamps 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)
Required Experience:
IC
Key Skills
- Data Analytics
- Microsoft Access
- SQL
- Power BI
- R
- Data Visualization
- Tableau
- Data Management
- Data Mining
- SAS
- Data Analysis Skills
- Analytics
About Company
As Encora Inc. expands its footprint in Latin America, its acquisition of Nearsoft provides our clients with a unique chance to Nearshore on a global scale.
