
Data Operations Analyst
Upstack Studio
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Salary
💰 $80,000 - $90,000 per year
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