Responsibilities

• Collect, analyze, create, and interpret complex data sets to identify trends, patterns, and insights that drive digital and brand marketing decisions in MS Fabric using Power BI.
• Maintain One Lake data, including data ingestion from new data sources and monitor, implement automated data pipeline monitoring and validation routines to ensure ongoing data integrity, accuracy and reliability.
• Create accurate forecasts using statistical methods and historical data to support brand and digital marketing planning.
• Leverage advanced analytical and statistical methods to predict future trends collecting and analyzing large amounts of internal and external data utilizing statistical algorithms.
• Create data models that help measure performance, identify gaps, provides insights into marketing campaigns based on different objectives and overall business reviews at brand level.
• Utilize advanced planning systems and tools to support data-driven decision-making and maintain data integrity.
• Make data-driven decisions with greater confidence, minimizing risks and maximizing opportunities for digital marketing channels and brand health.
• Generate and present detailed reports on marketing, highlighting key metrics and areas for improvement.
• Work closely with cross-functional teams, including different brands, digital marketing channels and shopper marketing to ensure cohesive and accurate data reporting for all our stakeholders.
• Design, develop, and maintain advanced Power BI dashboards by integrating and modeling data from multiple digital marketing channels using SQL queries and Python scripts for data extraction, transformation, and automation using the Medallion architecture in MS Fabric.

Requirements

• Bachelor's Degree preferred in the field of Data Analytics, Marketing, Statistics, Economics, or related field of study
• Proficient in Microsoft Office suite, SQL, Python, DAX, Power BI
• Certifications & Licenses: Data Modeling, MS Fabric , Power BI desired
• 5+ years of experience in data modeling, data analysis, marketing analysis
• 5+ years of experience in forecasting or predictive analytics

Preferred

• Experience with MS Fabric and Power BI
• Strong business acumen, deductive reasoning, and problem solving skills