Data Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

Ampstek ยท 8 hours ago

Data Analyst

positionNew York, United States
timeContract
remoteOnsite
seniorityEntry, Mid Level

Ampstek is seeking a Data Analyst to design and implement data workflows that bridge revenue lifecycle data and pricing optimization models. The role involves mapping and transforming data between systems, creating invoice datasets, and enabling machine learning models for price recommendations.

IT Management
check
Growth Opportunities
Hiring Manager
Sangeetha Salem Viswanathan
linkedin

Responsibilities

Understand data structures (Cart, Quote, Invoice, Line Items) and Pros SPOM schema
Design mapping logic to transform data into SPOM-compatible formats for pricing models
Build and maintain ETL pipelines for extracting, transforming, and loading data from to SPOM
Develop custom APIs where ETL is insufficient for real-time or complex transformations
Create invoice datasets from cart-level transactional data for downstream analytics and ML training
Validate data integrity and completeness across multiple sources
Prepare datasets for machine learning models to generate price recommendations
Collaborate with data science teams to ensure feature engineering aligns with pricing objectives
Implement data validation, error handling, and reconciliation processes
Ensure compliance with security and privacy standards for sensitive pricing and customer data
Work closely with engineering, product, and data science teams to define requirements
Document data flows, mapping logic, and transformation rules for audit and future enhancements

Qualification

SQLETL toolsData visualizationPythonAPI developmentData modelingCollaborationDocumentation

Required

Strong knowledge of SQL and relational database design
Proficiency in Python or R for data manipulation and transformation
Experience with ETL tools (e.g., Talend, Informatica, Azure Data Factory) and API development
Understanding of pricing strategies, revenue lifecycle, and transactional data flows
Expertise in data visualization (Power BI, Tableau) for reporting and insights

Company

Ampstek

twittertwittertwitter
company-logo
Ampstek supplies thousands of tech and digital professionals annually to a range of clients through its offices which spread across in 42 countries.
dateFounded in 2003
location
Princeton, New Jersey, USA
people-size1001-5000 employees
web-link
https://www.ampstek.com

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Rekha Pathy
CEO
linkedin
Company data provided by crunchbase