Senior Business Analyst

Sesheng Company; Aurora (CO); Hybrid; USD 100,000 - 130,000; Full time

Job summary

A leading consumer goods company in Aurora, CO, is seeking a Senior Business Analyst focused on data analytics within the Consumer Packaged Goods (CPG) sector. This role involves strategic partnership with senior leaders and ownership of complex data projects, ensuring alignment with business needs. Candidates should have extensive experience in CPG, exceptional SQL skills, and proficiency in data visualization tools like Tableau or Power BI. The position offers a flexible remote work model after the initial two weeks.

Qualifications

• 10+ years of experience as a Business Analyst or Data Analyst.
• 7+ years of experience in CPG industry, focusing on Sales or Supply Chain.
• Expert-level proficiency in SQL and experience with Snowflake.

Responsibilities

• Serve as strategic data liaison for executive leaders.
• Own the requirements lifecycle for complex data projects.
• Define data quality rules and governance standards for analytical datasets.
• Identify and address data integrity and quality issues.

Skills

Strategic Business Partnering

Data Analysis

SQL Proficiency

Data Visualization (Tableau, Power BI)

Tools

Snowflake

ERP (SAP/Oracle)

Tableau

Power BI

Job description

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

Contract Role: 6‑Month Contract (potential extension). Location: Aurora, CO (Remote after the initial Two Weeks).

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 translate complex business questions into clear, prioritized, and technical data requirements, 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, defining data quality rules, governance standards, and lineage for high‑priority analytical datasets.
• Advise on data architecture decisions 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 hands‑on experience with data housed in Snowflake (or a similar cloud data warehouse such as 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.