Highlights
The ideal candidate is comfortable working with large datasets, data mapping, transformations, and production troubleshooting. This role is responsible for transforming, validating, and troubleshooting merchant data feeds to ensure accurate ingestion into downstream systems.
Numbers & Facts
| Location | USA, VA (Remote) |
| Industry | Staffing/Employment Agencies |
| Salary | $1 |
| Company Size | 2,000 to 2,499 employees |
| Year Founded | 2000 |
| Website | http://www.lancesoft.com/ |
Description
Job Title: Data Analyst
Location: Remote USA
Duration: 6 Months
Payrate: $30- $35 per hour on W2
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 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.
Required Qualifications
- 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 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.
- Preferred Qualifications Experience with Databricks.
- Experience integrating third-party or merchant data feeds.
- Experience with flat-file integrations.
- Experience supporting production systems and on-call troubleshooting.
About Company
We are a $125 Million, NMSDC-certified Minority & Woman owned Workforce Solutions Company headquartered in the DC metro area with presence across US with global presence - Canada, Mexico, India, UK, Malaysia, Indonasia, Hongkong, Singapore, UAE. We are specialized in providing Workforce Solutions, SOW project delivery, Engineering Solutions, Creative Services. We currently support 100+ Fortune companies globally and across multiple industry segments. We are currently supporting several massive programs across industry segment nationally/globally (Intel, Ally, AMD, QUALCOMM, Morgan Stanley, Kraft/ Mondelez, MNP, Amdocs, Dell, SanDisk, Medtronic, Becton Dickinson, GE, Lockheed Martin, UTC, L-3 Communications, Caterpillar, BMW, Mercedes Benz, National Grid, Dominion, Energy Future Holdings, PSEG, 3M, Fidelity, Aetna, Humana, Johnson & Johnson, Pfizer, Merck etc).
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, identity, national origin, disability, or protected veteran status.