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)
- 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)
Top Skills
What We Do
Headquartered in Santa Clara, California, and backed by renowned private equity firms Advent International and Warburg Pincus, Encora is the preferred technology modernization and innovation partner to some of the world’s leading enterprise companies. It provides award-winning digital engineering services including Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering. Encora's deep cluster vertical capabilities extend across diverse industries, including HiTech, Healthcare & Life Sciences, Retail & CPG, Energy & Utilities, Banking Financial Services & Insurance, Travel, Hospitality & Logistics, Telecom & Media, Automotive, and other specialized industries.
With over 9,000 associates in 47+ offices and delivery centers across the U.S., Canada, Latin America, Europe, India, and Southeast Asia, Encora delivers nearshore agility to clients anywhere in the world, coupled with expertise at scale in India. Encora’s Cloud-first, Data-first, AI-first approach enables clients to create differentiated enterprise value through technology
