Senior Business Analyst

Business Analyst, CPG Data & Analytics (Senior Leadership Focus)

Contract Role

Location: Aurora, CO (Remote after the initial Two Weeks)

Department: Enterprise Data & Analytics / Business Intelligence

6-Month Contract (with potential for extension)

Job Summary

We are seeking an experienced and highly strategic Specialist Business Analyst with deep domain expertise in the Consumer Packaged Goods (CPG) industry and a proven track record in a data-intensive environment. This contract role is a critical link between our executive leadership, business functions (Sales, Marketing, Supply Chain), and the Data Engineering team. The successful candidate will be responsible for translating complex business questions into clear, prioritized, and technical data requirements, ultimately driving significant strategic insights and operational efficiency across the enterprise. Direct, high-level interaction with Senior-Level Leaders (VPs, SVPs) is a daily requirement.

Key Responsibilities

1. Strategic Business Partnering & Executive Communication

• Serve as the primary strategic data liaison for VP and SVP-level business leaders (e.g., Head of Sales, Chief Supply Chain Officer), translating their strategic goals and challenges into specific, measurable, achievable, relevant, and time-bound (SMART) analytical requirements.
• Structure and lead discovery sessions with senior stakeholders to clearly define business outcomes, current state gaps, and future state requirements for data solutions (e.g., next-generation Trade Promotion Management insights, advanced Demand Forecasting).
• Develop and present compelling, data-driven narratives, dashboards, and reports to senior leadership, distilling complex data findings into clear, actionable recommendations that influence multi-million dollar decisions.

2. Data Requirements & Solution Design

• Own the end-to-end requirements lifecycle for complex data projects, including defining business requirements documents (BRDs), functional specifications (FSDs), and data mapping documents.
• Apply deep CPG knowledge to define critical data entities and metrics related to Category Management, Trade Promotion Optimization (TPO), syndicated data (Nielsen/Circana/IRI), Supply Chain/Logistics, and Retail Execution.
• Collaborate directly with Data Engineers to design logical and physical data models that leverage the capabilities of the Snowflake Data Cloud, ensuring data structures are scalable, performant, and aligned with business consumption needs.

3. Data Platform & Governance Expertise

• Act as the Subject Matter Expert (SME) for CPG business processes within the Snowflake environment. This includes defining data quality rules, governance standards, and lineage for high-priority analytical datasets.
• Advise on data architecture decisions, specifically related to data ingestion, data transformation (ELT/ETL), and data warehousing best practices within the modern cloud data ecosystem.
• Proactively identify and address data integrity and data quality issues that impact executive reporting and decision-making accuracy.

Required Qualifications

• 10 years of progressive experience as a Business Analyst, Data Analyst, or Functional Consultant.
• 7 years of dedicated experience within the Consumer Packaged Goods (CPG) industry, focusing on core business domains such as Sales, Trade Marketing, Demand Planning, or Supply Chain/Logistics.
• Expert-level proficiency in SQL (writing complex queries, stored procedures) and demonstrated hands-on experience working with data housed in Snowflake (or a similar cloud data warehouse like Azure Synapse or Google BigQuery).
• Proven ability to work directly with executive and senior-level business stakeholders to define strategy and translate ambiguous needs into technical requirements.
• Extensive experience with data visualization tools such as Tableau, Power BI, or Looker, including the ability to design and govern enterprise-level dashboards.
• Familiarity with foundational CPG systems such as ERP (SAP/Oracle), Trade Promotion Management (TPM) software, and syndicated data feeds.

Preferred Skills

• Experience with dbt (Data Build Tool) for data transformation within Snowflake.
• Familiarity with Python or R for advanced analytics and statistical modeling.
• Certification or formal training in business analysis ( IIBA, CBAP).
• Prior experience in a consulting role interfacing with Fortune 500 CPG clients.

We are an Equal Opportunity Employer. We are committed to creating a diverse and inclusive environment for all employees and contractors, and we prohibit discrimination and harassment of any kind based on race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.