Summary
eTeam is seeking a Data Analyst-II to support merchant data onboarding and pipeline maintenance. The role involves transforming, validating, and troubleshooting merchant data feeds to ensure accurate ingestion into downstream systems.
Responsibilities
- Build, maintain, and troubleshoot ETL/data pipelines supporting merchant onboarding and integrations
- Analyze merchant data feeds (JSON, XML, CSV, TXT) and transform them into standardized schemas
- Develop and maintain SQL transformations in Databricks (Spark SQL preferred)
- Create and maintain data mapping logic and transformation rules
- Validate data quality, completeness, and accuracy across ingestion pipelines
- Investigate and resolve data issues, including root cause analysis and remediation
- Collaborate with Technical Account Managers, Product, and Engineering to onboard new merchants and implement data solutions
- Support multiple concurrent merchant implementations while meeting delivery timelines
- Document transformation logic, mapping specifications, and operational procedures
- Identify opportunities to automate manual processes and improve pipeline reliability
Skills
- 2 years of experience in data engineering, ETL development, or data integration
- Strong SQL skills (Databricks/Spark SQL preferred)
- Experience building or maintaining ETL/data pipelines
- Experience working with JSON, XML, and CSV
- Strong understanding of data transformation, schema mapping, and validation
- Experience troubleshooting production data pipelines
- Ability to read and understand technical documentation and data specifications
- Strong analytical and problem-solving skills
- Ability to manage multiple projects simultaneously
- Experience with Databricks
- Experience integrating third-party or merchant data feeds
- Experience with flat-file integrations
Qualifications
Must Haves
- 2 years of experience in data engineering, ETL development, or data integration
- Strong SQL skills (Databricks/Spark SQL preferred)
- Experience building or maintaining ETL/data pipelines
- Experience working with JSON, XML, and CSV
- Strong understanding of data transformation, schema mapping, and validation
- Experience troubleshooting production data pipelines
- Ability to read and understand technical documentation and data specifications
- Strong analytical and problem-solving skills
- Ability to manage multiple projects simultaneously
Nice to Haves
- Experience with Databricks
- Experience integrating third-party or merchant data feeds
- Experience with flat-file integrations