Data Analyst-II
Spectraforce
South San Francisco, California
16 hours ago
Job Description
Title: Data Analyst-II
Location: Remote – USA
Duration: 6 months
Description
We are seeking candidates with strong SQL and ETL experience to support merchant data onboarding and pipeline maintenance. This role is responsible for transforming, validating, and troubleshooting merchant data feeds to ensure accurate ingestion into downstream systems.
The ideal candidate is comfortable working with large datasets, data mapping, transformations, and production troubleshooting.
Responsibilities
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 34.10/hr.
Location: Remote – USA
Duration: 6 months
Description
We are seeking candidates with strong SQL and ETL experience to support merchant data onboarding and pipeline maintenance. This role is responsible for transforming, validating, and troubleshooting merchant data feeds to ensure accurate ingestion into downstream systems.
The ideal candidate is comfortable working with large datasets, data mapping, transformations, and production troubleshooting.
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 teams 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
- 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, CSV, and TXT data formats
- 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
- Experience supporting production systems and on-call troubleshooting
Applicant Notices & Disclaimers
- For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 34.10/hr.