Senior Analyst, Business Intelligence

This is a fully remote position, open to applicants in Ohio.

📋 Description

• Design, develop, and sustain curated data models and reporting objects within the Databricks Platinum layer.

• Create, support, and enhance Tableau dashboards by optimizing underlying data structures for better performance and usability.

• Construct scalable and reusable data assets for Tableau dashboards and self-service reporting.

• Develop, maintain, enhance, and analyze CAS/Trade Funds and consumption reporting dashboards using both internal and external syndicated data.

• Convert Commercial stakeholder business inquiries and requirements into reporting, analytics, and data visualization solutions.

• Collaborate with Information Services, data engineering, business analysts, and data partners to create data models, reporting objects, and semantic definitions.

• Analyze, design, code, test, and implement reporting and data visualization solutions.

• Act as a subject matter expert for best practices in BI development, data modeling, and reporting enablement.

• Contribute to data governance, naming standards, and development lifecycle practices.

• Share knowledge within the analytics team to enhance efficiency and effectiveness.

• Coordinate with external data vendors regarding Commercial data delivery priorities and reporting requirements.

• Analyze metrics related to consumption, shipments, trade spending, profitability, forecasting, pricing, promotions, and market share trends.

• Communicate actionable insights and provide informal coaching and project leadership to colleagues.

⛳️ Requirements

• Bachelor’s Degree in a relevant field.

• Over 3 years of professional experience in BI development.

• Proficient in developing with BI tools such as Tableau, including data preparation for visualization.

• Strong experience with Databricks or similar cloud data platforms, encompassing data transformation and pipeline development.

• Familiarity with SQL-based languages (e.g., SQL Server, Oracle SQL, or MySQL) for data extraction, transformation, and analysis across complex datasets.

• Exceptional analytical, interpretive, and problem-solving abilities.

• A creative thinker capable of generating, communicating, and promoting ideas.

• Experience utilizing syndicated data and business reporting systems.

• Excellent communication skills, including the ability to influence management decisions and engage with sales managers.

• Capability to convey complex quantitative analyses in a clear, precise, and actionable manner.

• Self-driven and adept at managing multiple and diverse tasks.

• Team-oriented with the ability to build relationships throughout the organization.

• Occasional travel required (approximately 1 trip per year).

• Experience with generative AI tools, knowledge of the CPG industry, and retail/CPG sales-report analysis are additional, non-mandatory qualifications.

🏝️ Benefits

• The employer expresses commitment to supporting employees' physical, emotional, and financial well-being.

• Offers equal opportunity employment.