Data Analyst

Data Analyst – Conga & Pros SPOM Integration

Data Modeling & Mapping

Understand Conga’s data structures (Cart, Quote, Invoice, Line Items) and Pros SPOM

schema.

Design mapping logic to transform Conga data into SPOM-compatible formats for pricing

models.

ETL & Data Integration

Build and maintain ETL pipelines for extracting, transforming, and loading data from Conga

to SPOM.

Develop custom APIs where ETL is insufficient for real-time or complex transformations.

Invoice Data Generation

Create invoice datasets from cart-level transactional data for downstream analytics and

ML training.

Validate data integrity and completeness across multiple sources.

Pricing Analytics

Prepare datasets for machine learning models to generate price recommendations.

Collaborate with data science teams to ensure feature engineering aligns with pricing

objectives.

Data Quality & Governance

Implement data validation, error handling, and reconciliation processes.

Ensure compliance with security and privacy standards for sensitive pricing and customer

data.

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.

Solid grasp of data governance, security, and compliance practices.

Experience with machine learning pipelines for pricing optimization.

Knowledge of RESTful APIs, JSON/XML transformations, and integration patterns.

Familiarity with Salesforce ecosystem and Conga platform extensions.

Exposure to cloud platforms (Azure, AWS) and data lake architectures.

Strong analytical and problem-solving skills with attention to detail.