Upstack Studio

Data Operations Analyst

Upstack Studio

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $80,000 - $90,000 per year

Tech Stack

About the role

  • Supports the accuracy, integrity, and operational flow of data across enterprise systems.
  • Focuses on acquisition data migrations, ongoing data quality monitoring, and operational analysis to ensure data is reliable and ready for reporting and decision-making.
  • Partners with Integration, Business Systems, and business stakeholders to analyze source data, execute repeatable data migrations, validate data loads, and respond to ad-hoc data needs.
  • Helps automate manual processes and translates business definitions into clear, well-documented data logic.
  • Responsible for migrating and processing acquisition data from their system into UPSTACK Salesforce system.
  • Partners with key stakeholders and the integration team; manages expectations, and provides consistent and key updates.
  • Conducts thorough data and source system analysis to the structure and format of acquired CRM data and defines mapping and transformation requirements.
  • Utilizes declarative ETL tools to migrate data into Salesforce using repeatable processes.
  • Executes comprehensive audit and testing procedures to validate data loads, leveraging both custom and existing reporting functionalities.
  • Responds to rapid-turnaround data requests to support immediate business decision-making.
  • Runs regular checks for data anomalies and validates data against source systems.
  • Assists in maintaining reference data, mapping tables, and standardized metrics definitions.

Requirements

  • Bachelor’s degree in Information Systems, Data Analytics/ Data Science, Computer Science, Business Analytics or something similar.
  • Knowledge of data integration and migration concepts, including source system analysis, field mapping, and transformation logic.
  • Experience working with CRM data structures (Salesforce or similar) and downstream reporting systems.
  • Familiarity with ETL concepts and declarative data migration tools.
  • Proficiency in SQL for data validation, auditing, reconciliation, and analysis.
  • Strong analytical skills with high attention to data quality, accuracy, and consistency.
  • Ability to translate ambiguous business requirements into clear, testable data logic.
  • Experience performing data audits and executing repeatable data processes.
  • Strong written and verbal communication skills and ability to document data logic and processes.
  • Ability to manage multiple data initiatives in a fast-paced environment.
  • Experience with Salesforce integrations or post-acquisition data migrations.
  • Familiarity with common business metrics (e.g., revenue, churn, margin, commissions).
  • Knowledge of data governance, version control, and documentation standards.
  • Experience automating manual data tasks using scripts, workflows, or ETL tools.
  • Ability to identify data risks, escalate issues, and adapt to changing requirements.
  • Comfortable working independently and collaboratively across teams.
Benefits
  • Participation in our annual bonus incentive
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data migrationdata quality monitoringdata analysisETLSQLdata validationdata auditingdata reconciliationdata transformationCRM data structures
Soft Skills
analytical skillsattention to detailcommunication skillsdocumentation skillsproject managementcollaborationadaptabilityproblem-solvingtime managementstakeholder management
Certifications
Bachelor’s degree in Information SystemsBachelor’s degree in Data AnalyticsBachelor’s degree in Data ScienceBachelor’s degree in Computer ScienceBachelor’s degree in Business Analytics