Data Analyst-II

Lancesoft

USA, VA(remote)

Apply

JOB DETAILS

SALARY

SKILLS

Analysis Skills, Data Analysis, Data Management, Data Mapping, Data Quality, Data Sets, Database Extract Transform and Load (ETL), Identify Issues, JSON, Multitasking, On Call, Onboarding, Operations Processes, Problem Solving Skills, Process Improvement, Product Engineering, Production Support, Production Systems, Project/Program Management, Reliability Engineering, Root Cause Analysis, SQL (Structured Query Language), Sales Management, Technical Leadership, Technical Writing, Time Management, XML (EXtensible Markup Language)

LOCATION

USA, VA

POSTED

1 day ago

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 the Company

Lancesoft

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.

COMPANY SIZE

2,000 to 2,499 employees

INDUSTRY

Staffing/Employment Agencies

FOUNDED

2000

WEBSITE

http://www.lancesoft.com/