Product Data Analyst - SKU

Aston Carter•Kirkland, WA

21h•$40 - $40•Remote

About The Position

Responsibilities Support SKU analysis by sourcing base data from multiple systems and dashboards, including RCR and self-reporting tools. Clean and standardize SKU base data for critical specifications such as family name, memory, storage, screen size, and processor details, including identifying and filling in missing information based on product descriptions. Develop comprehensive SKU lists and map silicon family and generation data using web sources and processor details. Manually scrape and validate MSRP data from web sources and internal tools for top SKUs by volume. Manually map masked Circana data in RCR to Open Brand and ensure accurate linkage across datasets. Collaborate with cross-functional teams (including FD&E) to identify HERO SKUs, silicon family and generation, and MSRP mapping in RCR. Review data quality and identify inconsistencies in Circana and related datasets, working with partners to clean, align, and standardize data. Drive overall database cleanup efforts with relevant teams to enable SKU report automation through RCR. Design and build Power BI dashboards and reports for SKU and financial analysis in partnership with cross-functional stakeholders. Use data visualization best practices to present complex financial and SKU insights in a clear, concise, and actionable format. Manage time and priorities effectively to deliver high-quality analysis and reports within agreed timelines. Communicate findings, trends, and recommendations clearly to both technical and non-technical stakeholders, supporting decision-making across the business. Essential Skills 2–4 years of product analysis experience. Bachelor's degree. Proficiency in Microsoft Excel, including working with large datasets and complex data structures. Hands-on experience building dashboards, with strong preference for Power BI. Experience with data visualization and creating dashboards for business stakeholders. Experience working with large data sets and database structures. Financial and data analytics experience, operating at the intersection of finance and data. Strong verbal and written communication skills. High attention to detail and strong critical thinking skills. Ability to work independently and manage time effectively. Ability to analyze business trends and project future revenues and expenses. Knowledge of economic and accounting principles, financial markets, and financial data reporting. Knowledge of relevant policies, procedures, and regulations as they relate to accounting. Experience with Microsoft Word, Excel, PowerPoint, and related financial software. Proficiency with Power BI, dashboards, data visualization, and working with large datasets (required; candidates lacking these skills will not be eligible). Additional Skills & Qualifications Experience with SKU-level analysis and SKU reporting. Experience sourcing and cleaning data from multiple systems and dashboards. Familiarity with mapping product attributes such as family, memory, storage, screen size, and processor details. Experience scraping and validating pricing or MSRP data from web sources. Experience collaborating with cross-functional teams to define key metrics, such as HERO SKUs and product hierarchies. Strong teamwork skills and ability to partner effectively with technical and business stakeholders. Experience building automated reports and supporting data quality initiatives. Interest in influencing competitive strategy within a consumer-focused business environment. Work Environment This is a fully remote role with a standard Monday–Friday schedule, approximately 40 hours per week. The position is open to candidates across U.S. time zones, with a preference for those able to align with Pacific Time working hours. You will work extensively with digital tools and platforms, including Excel, Power BI, and other data and financial applications, in a collaborative virtual environment. The role offers the opportunity to contribute directly to the competitive strategy of a major consumer business and may be extended based on performance and business needs.

Requirements

2–4 years of product analysis experience.
Bachelor's degree.
Proficiency in Microsoft Excel, including working with large datasets and complex data structures.
Hands-on experience building dashboards, with strong preference for Power BI.
Experience with data visualization and creating dashboards for business stakeholders.
Experience working with large data sets and database structures.
Financial and data analytics experience, operating at the intersection of finance and data.
Strong verbal and written communication skills.
High attention to detail and strong critical thinking skills.
Ability to work independently and manage time effectively.
Ability to analyze business trends and project future revenues and expenses.
Knowledge of economic and accounting principles, financial markets, and financial data reporting.
Knowledge of relevant policies, procedures, and regulations as they relate to accounting.
Experience with Microsoft Word, Excel, PowerPoint, and related financial software.
Proficiency with Power BI, dashboards, data visualization, and working with large datasets (required; candidates lacking these skills will not be eligible).

Nice To Haves

Experience with SKU-level analysis and SKU reporting.
Experience sourcing and cleaning data from multiple systems and dashboards.
Familiarity with mapping product attributes such as family, memory, storage, screen size, and processor details.
Experience scraping and validating pricing or MSRP data from web sources.
Experience collaborating with cross-functional teams to define key metrics, such as HERO SKUs and product hierarchies.
Strong teamwork skills and ability to partner effectively with technical and business stakeholders.
Experience building automated reports and supporting data quality initiatives.
Interest in influencing competitive strategy within a consumer-focused business environment.

Responsibilities

Support SKU analysis by sourcing base data from multiple systems and dashboards, including RCR and self-reporting tools.
Clean and standardize SKU base data for critical specifications such as family name, memory, storage, screen size, and processor details, including identifying and filling in missing information based on product descriptions.
Develop comprehensive SKU lists and map silicon family and generation data using web sources and processor details.
Manually scrape and validate MSRP data from web sources and internal tools for top SKUs by volume.
Manually map masked Circana data in RCR to Open Brand and ensure accurate linkage across datasets.
Collaborate with cross-functional teams (including FD&E) to identify HERO SKUs, silicon family and generation, and MSRP mapping in RCR.
Review data quality and identify inconsistencies in Circana and related datasets, working with partners to clean, align, and standardize data.
Drive overall database cleanup efforts with relevant teams to enable SKU report automation through RCR.
Design and build Power BI dashboards and reports for SKU and financial analysis in partnership with cross-functional stakeholders.
Use data visualization best practices to present complex financial and SKU insights in a clear, concise, and actionable format.
Manage time and priorities effectively to deliver high-quality analysis and reports within agreed timelines.
Communicate findings, trends, and recommendations clearly to both technical and non-technical stakeholders, supporting decision-making across the business.