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)