Job Description

Responsibilities Create and maintain DX Shopper Analytics & Insights dashboards, focusing on capabilities driven by IRI and cDNA (Shopper Circuits, Shopper Profiles, Trip Missions) and shopper research (C-Store Segmentation, Value). Ensure data is maintained within each model per the update schedule and that visualizations are actionable for partner teams. Functional Responsibilities: Support Walmart Advanced Analytics team with adhoc analysis and creation of data visualizations Study, Analyze and understand business requirements in context to business intelligence. Design and map data models to map raw data into meaningful insights Utilize Power BI to build interactive and visually appealing dashboards and reports with a focus on storytelling and driving action Understand the different types of audiences to cater to each segment with relevant and easily accessible information Be and expert in SQL query writing, and know about data integration, modeling and be well versed in good UI design Be knowledgeable in methods required to build performant dashboards for very large data Lead the end-to-end development of reports from requirements to release Juggle multiple projects and be able to manage the workflow within the team, while adhering to good practices in dashboard design Provide critical thought leadership to enhance organizational capabilities by utilizing a variety of data sets work with business stakeholders to identify and execute on opportunities for enhancement Develop interactive visual reports, dashboards, charts, and measures with KPI scorecards using Microsoft Power BI desktop. Analyze, design, deploy, troubleshoot, and support Power BI solutions. Participate in user acceptance testing. Explore and implement ways to enhance data quality and reliability. Collaborate with data scientists and architects as needed. Develop & maintain relationships with the key end-user stakeholders in PepsiCo US HQ offices. Responsible for managing multiple priorities have strong ability to manage deadlines and deliverables. Deliver outputs in line with the agreed timelines and formats, leveraging existing project management tools. Flag and monitor any business risks related to delivering the requested outputs. Improve existing processes based on frequent Business Partner & end-user feedback loop Qualifications Bachelor\'s degree in computer science, information systems, informatics, statistics, engineering, or another quantitative field or equivalent from a college or university with IT focused specialization. 6+ years\' experience as a BI Developer or related experience in a global company with significant experience in hands-on technology delivery roles. Strong data analytics background with experience in developing use cases, deep understanding of managing data and generating insights through visualization. Background in custom build experience using Power BI Report Builder, Power BI Desktop, Power BI Service, Tabular Editor, DAX Studio designing Power BI data models including writing complex DAX, SQL queries and implementing role level security. Experience in working with large datasets (Billions of rows) to build data models for analysis. Ability to understand data modeling, data schemas (normalized, flat, star, snowflake, etc.), query optimization, query profiling and query performance monitoring tools and techniques. Basic Knowledge of programming in Python is an added advantage. Ability to build processes that support data transformation, workload management, data structures, dependency, and metadata. Hands-on experience with optimizing performance of SQL queries and applications Great numerical and analytical skills Demonstrated ability to effectively communicate with all levels of the organization CPG, Sales, Finance, Healthcare industry experience is a plus Language: English Fluent Essential: World-class stakeholder management skills. High degree of organizational savvy. Solution-oriented approach to problem solving. Ability to challenge requests in a constructive way that does not damage relationships or slow progress. Proven capability in creating compelling visual communication.

foundit