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: • AWS: Redshift, S3, Glue, Athena, QuickSight • SQL: Microsoft SQL Server, Access, Jet Cubes • APIs: Reason Automation, Stackline, Sales Layer, Keepa • Data Wrangling: Excel, Python, Pandas • Collaboration: Jira, Confluence, Git