Senior Business Analyst
Sesheng Company, Aurora, CO, United States
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.
#J-18808-Ljbffr
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.
#J-18808-Ljbffr