UPSTACK · 23 hours ago
Data Operations Analyst
United States
Full-time
Remote
Entry, Mid Level
$80K/yr - $90K/yrUPSTACK is the leading full-service technology advisory firm, transforming how businesses design, source, implement, support, and optimize IT infrastructure. The Data Operations Analyst supports the accuracy, integrity, and operational flow of data across enterprise systems, focusing on data migrations, quality monitoring, and operational analysis.
Cloud ComputingInformation TechnologyCloud InfrastructureData CenterPrivate Cloud
No H1B
Responsibilities
Responsible for migrating and processing acquisition data from their system into UPSTACK Salesforce system
Partner with key stakeholders and the integration team; manage expectations, and provide consistent and key updates
Conduct thorough data and source system analysis to the structure and format of acquired CRM data and define mapping and transformation requirements
Utilize declarative ETL (Extract, Transform, Load) tools to migrate data into Salesforce using repeatable processes while ensuring a high degree of data integrity and accuracy
Execute comprehensive audit and testing procedures to validate data loads, leveraging both custom and existing reporting functionalities
Ad-Hoc Analysis: Respond to rapid-turnaround data requests to support immediate business decision-making
Data Integrity Audits: Run regular checks for data anomalies (e.g., duplicates, unexpected nulls, volume spikes/drops) and validate data against source systems
Data Management: Assist in maintaining reference data, mapping tables, and standardized metrics definitions to ensure consistency across the platform
Automation: Identify repetitive manual tasks (like manual data patches or file uploads) and write scripts or workflows to automate them
Business Logic Translation: Collaborate directly with business stakeholders to define ambiguous metrics (e.g., "Churn Rate," "Gross Margin") and translate those definitions into precise, version-controlled SQL transformations
Qualification
Required
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
Preferred
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
Company
UPSTACK
Upstack provides a team of cloud infrastructure advisors to architect customized solutions for businesses of all sizes.
Founded in 2017
201-500 employees
Funding
Current Stage
Growth StageTotal Funding
$186.8MKey Investors
MidCap Financial,Morgan Stanley Private CreditBerkshire PartnersBurch Creative Capital,Montage Ventures
2021-11-02Debt Financing· $100M
2021-04-14Private Equity· $50M
2019-01-01Series Unknown· $35M
Leadership Team
Benjamin Smoot
COO, Head of Product
Recent News
2025-10-09
Company data provided by crunchbase