Familiarity with data analytics & visualization tools (PowerBI, SQL, Databricks/Snowflake, & Azure Cloud)
Experience with the Agile Software Development Lifecycle
CPG experience working with IS + Business partners across various business units
Must Haves (i.e., years of experience?) 3-5 years of experience:
Software Skills and Purpose (if applicable): Databricks, Snowflake, & Power BI
Industry Experience: CPG
Target companies you would like to see candidates from: None in particular, but other CPG Retailers or Manufacturers and/or consulting companies
Description:
Data Analytics Engineer to Support Commercial Data Store Team with Salty Shelf Analytics/Reporting
Job Description:
This role is responsible for completing the data visualization tasks necessary for the Salty Category Shelf Analytics in-house capability. This work will be completed in partnership with the existing team working on the existing Candy Mints and Gum (CMG) tool. This role will sit within the existing IS team working within the Agile software development lifecycle workstreams. This role is focused on standing up Salty in-house capabilities centered on co-developing the design for the Performance/Space Analytics dashboards, in partnership with the Business lead. This role will require an understanding of the business needs and partnership with a data engineer, who will support this role by developing data models to meet visualization & reporting needs. This will include the documentation of the process. The individual will work closely with U.S. Commercial functions – Category Management and IS partners. This role will also partner closely with Cleint’s Enterprise Data team to ensure projects are aligned with Client data & technology strategies.
What You’ll Do:
Maintain and optimize the multi-year strategic vision for Client’s space analytical platform
Refine the plan to account for changes in the long-term business strategy and new technological capabilities
Validate prioritization of enhancements are prioritized in alignment with business objectives
Identify solutions to address analytical gaps by working cross-functionally with groups such as Information Services (IS) including data architects and data scientists
Become the subject matter expert on the current toolset along with marketplace capabilities within this space
Troubleshoot issues with space analytic tools to ensure data is accurate and complete; maintain records of nuances with the data
Support peers with analytics to help influence the future of the category, including space acquisitions, fixture innovations, feature implementations, merchandising standards and beyond
Data mine Client’s data platforms to uncover new insights and answer business questions; present findings back to peers and leadership to drive business decisions
Influence internal clients decision-making and planning based on insights derived from working with peers and datamining
Partner with IS to optimize ways to mine the data for insights and support team members with data extracts from Client’s platforms
Create and maintain models to help influence optimal assortment, flow, location, etc.
Build and optimize clustering in alignment with customer strategies
Synthesize actionable insights using multiple data sources – Syndicated, customer, space etc.
Leverage analytical tools such as Space Planning (JDA/Blue Yonder), Alteryx, Tableau, and more
Question the status-quo and continually challenge yourself and the team with what is possible; develop test and learn opportunities to identify new ways to grow sales for the candy category
What You’ll Need to Succeed:
Intellectual Curiosity
Strong problem-solving capabilities
Prior experience working with data visualization tools such as Tableau or PowerBI
Prior experience working with data manipulation tools such as Alteryx
Strong knowledge of relational, dimensional, and semantic data modeling.
Proficiency in methodologies such as star schema, snowflake schema, and semantic models.
Knowledge and experience in working with relational/non-relational databases, e.g., Databricks, Snowflake.
3+ years of developing and maintaining the data modeling and reporting ecosystem, ensuring service level agreements and data quality.
Experience working in a high-performing agile delivery model, aligning with Scrum Masters, Product Owners, and other execution team members to deliver rapid and impactful solutions that align with business stakeholders' strategy.
Experience with coding languages such as Python, R, SQL
Foundational knowledge in statistical modeling
Project Management and organizational skills
Strong communication skills, including with technical and non-technical stakeholders
Ability to distill insights from data and explain key takeaways
3-5 years of experience in data analytics and analysis
About Us: Established in 2004, SPECTRAFORCE® is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams. We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 140 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation. SPECTRAFORCE is built on a concept of “human connection,” defined by our branding attitude of NEWJOBPHORIA®, which is the excitement of bringing joy and freedom to the work lifestyle so our people and clients can reach their highest potential. Learn more at: http://www.spectraforce.com
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation.
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAHR@spectraforce.com.
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE, your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer.
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $70.00/hr.
