Revolution Supply Co.

Compensation

Full Description

Job Title: Sr Data Analyst Location: Hybrid (Santa Ana, CA) Type: Full-Time / Contract Department: Data & Analytics Position Summary: We are seeking a results-driven Sr Data Analyst to support both data lake creation and on going analytic needs. Your experience will include at least 8 years in a product rich environment analyzing e-commerce, forecasting and inventory data for key decision makers. This role is critical to ensuring data quality, business continuity, and analytic value throughout the migration lifecycle and beyond. The Data Analyst will work closely with Azure engineers, business stakeholders, and analytics teams to design, validate, and operationalize data workflows in a modern Azure based architecture. Key Responsibilities: Pre-Migration (Assessment and Transition Support): • Analyze and document current-state data sources (e.g., Dynamics 365 BC, SQL Server, Access, Magento, PIM, Repricer, APIs). • Conduct data profiling and quality assessments to inform migration strategies. • Collaborate with engineers and architects to support data mapping, transformation, and validation processes during migration. • Help define and document performance, compliance, and availability requirements for datasets being moved to AWS. • Support migration testing and cutover planning for reporting and analytic workloads. Post-Migration (Azure Data Warehouse Enablement): • Perform ongoing data validation, reconciliation, and quality monitoring across Fabric. • Translate business questions into data-driven analyses and deliver actionable insights across sales, operations, and e-commerce domains. • Support business stakeholders with ad hoc data needs and self-service analytics enablement. • Partner with teams to prepare and validate data sets for AI/ML models, and assist in measuring model outputs. • Document data dictionaries, business logic, and data lineage to ensure transparent and auditable reporting. • Contribute to ongoing data governance, security, and cost optimization practices in Azure. Required Qualifications: • Bachelor’s degree in Data Science, Computer Science, Information Systems, or related field. • 8+ years of experience in a Data Analyst or BI Analyst role supporting cloud-based data platforms. • Exposure with Amazon seller channel data, e-commerce analytics, or ERP reporting. • Experience in a product environment with a minimum of 1,000 SKU's • Experience with Inventory modeling and forecasting • Proficiency in SQL and data manipulation across relational and cloud-based data stores (SQL Server, Access). • Experience working with API-driven data sources and unstructured data. • Familiarity with Microsoft Fabric • Strong data profiling, visualization, and problem-solving skills. • Ability to translate business needs into technical data requirements and outputs. Preferred Qualifications: • Experience with data migration projects, data lake creation. • Knowledge of tools like Athena, Python (Pandas), or dbt for data transformation and exploration. • Understanding of data warehouse design, dimensional modeling, and cost-efficient architecture patterns. • Familiarity with GenAI or ML model support workflows is a plus. Tools & Technologies: • Microsoft Fabric • SQL: Microsoft SQL Server, Access, Jet Cubes • APIs: Reason Automation, Stackline, Sales Layer, Keepa • Data Wrangling: Excel, Python, Pandas • Collaboration: Jira, Confluence, Git