Sr. BI Analyst

Position Summary:

We’re seeking a Sr. Analyst-BI who can both design scalable BI/data solutions and deliver actionable insights and dashboards. You’ll own the end‑to‑end path—from requirements and data modeling through visualization, performance optimization, and stakeholder enablement—so business teams get trustworthy, fast answers to the right questions. You’ll partner with Finance, Supply Chain, Sales, and Marketing, building a governed semantic layer and self‑service capabilities while tackling complex ad‑hoc analyses. 

If you are a curious data-minded individual that enjoys working closely with the business to gather and document requirements, create Power BI reports and dashboards to improve operational performance – this may be the perfect role for you. The ideal candidate has experience in consumer goods manufacturing and is passionate about new ideas, works effectively with cross-functional teams and thrives in a fast-paced setting.

Essential Functions:

Architecture, Data Modeling & Governance

• Design and build new BI products (e.g. datasets, reports, dashboards) following reference architecture (data sources → staging/ETL → warehouse/data lake → semantic models → reports) emphasizing security, lineage, and reusability.
• Design and build data models for reporting.
• Establish and enforce development standards (naming, versioning, code review, test/data validation, documentation).
• Optimize pipelines (SQL/ETL) and ensure reliable, well‑modeled datasets for reporting.
• Implement performance strategies (partitioning, aggregations, incremental refresh, caching, index tuning).

Solutions Delivery (Dashboards & Reporting)

• Translate business requirements into Microsoft Fabric solutions; iterate quickly with stakeholders.
• Create Business Requirements Documentation (BRDs) in partnership with stakeholders
• Write advanced T-SQL, Power Query, and DAX scripts; build reusable measures and shared data models
• Drive adoption: publish content, manage workspace/app security, and conduct training/office hours.

Analytics & Decision Support

• Perform descriptive/diagnostic analyses; run sensitivity/what‑if scenarios to inform inventory, pricing, and service trade‑offs.
• Build forecasts or simple statistical models where appropriate; validate results and quantify business impact.
• Create clear data stories—narratives that highlight drivers, risks, and recommended

Perform other duties assigned that support the overall success of the team, department, or organization. This may include participating in cross-functional initiatives, contributing to process improvements, or assisting with special projects as needed.

This list is intended to describe the general nature and level of work performed. This is not an exhaustive list of all responsibilities required for this role.

Regular, predictable, in-person attendance on the business days the Company requires in-person attendance at this facility.  (In-person attendance is optional on the other workdays.)  For non-required-in-person attendance days, employees are expected to be present and engaged during the designated work hours for this role.

Education/Experience/Qualifications/Certifications:

Required

• Bachelor’s degree in Analytics, Information Systems, Computer Science, Finance, Statistics, or related field or equivalent practical experience.
• 4 years in BI/Analytics with combined experience in data modeling and dashboard development.
• Strong proficiency with Microsoft BI tools (Power BI) and visualization best practices.
• 3 years of experience in the Consumer Packaged Goods (CPG) or food manufacturing industry.
• 1 years of experience with Dynamics 365 Finance & Operations (D365 F&O).
• 1 years of experience with Microsoft Fabric.

• Proficiency in T-SQL, Microsoft database technologies, and DevOps.

• Advanced SQL; working knowledge of ETL tooling and Python (e.g. PySpark, SemPy) for data wrangling/automation.
• Proven ability to gather requirements, define KPIs, and convert business questions into analytical outputs.
• Experience tuning dataset/report performance and implementing row‑level security.
• Excellent communication and stakeholder management skills.

• Strong skills in technical draftsmanship and working knowledge of standard software and database documentation artifacts.
• Excellent critical thinking, analytical, problem-solving, interpersonal, time management, multi-tasking and communication skills.

• Passion, humility, integrity, credibility, and commitment to values.
• Excellent people skills that generate respect and trust from stakeholders.
• Data-driven with an affinity for business process enhancement and automation.

Preferred

• Familiarity with Azure data services or equivalent cloud data platforms.
• Exposure to forecasting/statistical methods and data quality frameworks.

The annual base salary for this position ranges from $98,800 - $138,300.

 Compensation is based on a number of factors including market location and may vary depending on job-related knowledge, skills and experience. Short-Term Incentive and other forms of compensation may also be provided as part of a total compensation package.

 A full range of medical, dental, vision, 401K plus up-to-four percent (4%) match, profit sharing, wellness program, paid parental leave, long-term-care insurance, critical accident insurance, short- and long-term disability and education assistance are also available.

Salary : $98,800 - $138,300