Ampstek ยท 15 hours ago
Data Analyst
New York, United States
Contract
Onsite
Entry, Mid LevelAmpstek 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
Hiring Manager
Sangeetha Salem Viswanathan
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
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
Ampstek supplies thousands of tech and digital professionals annually to a range of clients through its offices which spread across in 42 countries.
Founded in 2003
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Rekha Pathy
CEO
Company data provided by crunchbase