Revolution Supply Co. is hiring: Sr Data Analyst in Santa Ana

Get AI-powered advice on this job and more exclusive features.

Job Title: Sr Data Analyst – AWS Migration & Cloud Data Warehouse

Location: Remote / [Client Location]

Type: Full-Time / Contract

Department: Data & Analytics

Position Summary:

We are seeking a results-driven Sr Data Analyst to support both the migration of data infrastructure from Microsoft Azure to AWS and the ongoing analytics and reporting needs in the post-migration cloud environment. Your experience will include at least 5 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 AWS engineers, business stakeholders, and analytics teams to design, validate, and operationalize data workflows in a modern AWS-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 (AWS Data Warehouse Enablement):

• Perform ongoing data validation, reconciliation, and quality monitoring across S3, Redshift, Glue, and other AWS data services.
• Develop and maintain dashboards, visualizations, and reports using Amazon QuickSight or equivalent BI tools.
• 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 ML/GenAI 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 AWS.

Required Qualifications:

• Bachelor’s degree in Data Science, Computer Science, Information Systems, or related field.
• 3+ years of experience in a Data Analyst or BI Analyst role supporting cloud-based data platforms.
• Proficiency in SQL and data manipulation across relational and cloud-based data stores (e.g., Redshift, SQL Server, Access).
• Experience working with API-driven data sources and unstructured data.
• Familiarity with AWS data services such as S3, Glue, Redshift, and QuickSight.
• 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, particularly from Azure to AWS.
• 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.
• Exposure to Amazon seller channel data, e-commerce analytics, or ERP reporting.
• Familiarity with GenAI or ML model support workflows is a plus.

Tools & Technologies:

• SQL: Microsoft SQL Server, Access, Jet Cubes
• APIs: Reason Automation, Stackline, Sales Layer, Keepa
• Data Wrangling: Excel, Python, Pandas

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Automotive

Referrals increase your chances of interviewing at Revolution Supply Co. by 2x

Sign in to set job alerts for “Senior Data Analyst” roles.

Senior Business Analyst - Actuarial Data

Newport Beach, CA $121,770.00-$148,830.00 2 weeks ago

Sr. Business Systems Analyst - Data Governance

Irvine, CA $111,000.00-$136,500.00 2 months ago

Irvine, CA $147,900.00-$184,900.00 6 days ago

(USA) Senior Analyst, Business Development

Irvine, CA $84,000.00-$156,000.00 1 week ago

Irvine, CA $65,000.00-$75,000.00 1 week ago

Senior Business Immigration Analyst (Paralegal)

Orange, CA $149,882.00-$224,823.00 2 weeks ago

Apartments.com - Senior Technical Business Analyst

Irvine, CA $99,000.00-$170,000.00 4 days ago

Irvine, CA $70,694.00-$81,492.00 2 weeks ago

Senior Level Data Scientist / Sports Entertainment / Python & BigQuery

Long Beach, CA $127,000.00-$163,000.00 1 week ago

Long Beach, CA $90,000.00-$145,000.00 1 week ago

Irvine, CA $91,000.00-$136,000.00 5 days ago

Data Analyst, Sr. (Finance - Encounter Data)

Orange, CA $84,092.00-$134,548.00 4 days ago

SAP iXp Intern - Data Scientist, Customer and Competitive Market Intelligence

Irvine, CA $60,000.00-$70,000.00 1 week ago

Irvine, CA $111,800.00-$139,800.00 3 weeks ago

Senior Data Scientist, Specialist Senior - SFL Scientific

Santa Ana, CA $100,000.00-$150,000.00 19 hours ago

Irvine, CA $186,000.00-$232,500.00 2 weeks ago

Senior Business Operations Analyst (Hybrid)

Irvine, CA $87,208.00-$104,502.00 1 week ago

Whittier, CA $76,481.60-$126,193.60 1 week ago

Sr. Data Scientist – AI/ML & LLM Specialist

Irvine, CA $124,900.00-$228,900.00 5 days ago

Ontario, CA $111,800.00-$139,800.00 3 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.