Monster Energy
Business Intelligence Analyst
Monster Energy, Corona, California, us, 92878
Position Summary:The Business Intelligence Analyst will help turn abstract information from data into appealing and understandable visualizations that improve business insights pertaining to sales, sales support, and overall field execution. He/she is responsible for designing, developing, implementing, and maintaining reporting for teams within the Monster sales organization as well as our bottling network. He/she requires a solid understanding of business analytics and strong communication skills to help stakeholders understand and leverage the insights hidden within their data.
Essential Job Functions:
Understand, develop, and maintain data visualization in Power BI to be used to product ongoing weekly/monthly/yearly reports including, but not limited to: Shipments, Depletions, Distribution, Nielsen, Survey data and more.Work with large datasets (SQL Server, Azure SQL, Google Analytics, SAP) as needed to drive analytic, graphical, and reporting solutionsUnderstanding of Sharepoint objects such as Lists, Folders, and Online ListsHelp drive business stakeholder adoption of insights-driven decision making and/or business process innovationBecome subject matter expert on all sales data and employ tools such as R and Python to find hidden insights within the dataWorking with IT and other departments with our metadata to maintain user access, hierarchy and securityData cleansing exercises, either through manual update or data load to address issue areasIdentify, analyze and interpret trends or patterns in complex data setsPresent interpretation and insight to senior management, sales operations and the entire North American sales forceDevelop and maintain all documentation for report development and enhancementsLocate and define new process improvement opportunitiesProvide specialized system/software training.Other related duties as assigned.Position Requirements:
A minimum of 1-5 years of experience in field or in a related area.Masters degree in applied mathematics, statistics, business analytics or computer science preferredExperience presenting data insights to sales forceExperience developing business requirements with cross-functional teams across the companyExperience with Power BI Desktop, the Power BI Service, and related best practices preferredDAX & M experience (filter context, row context, columns vs. measures, etc.)Experience managing table relationships and advanced custom queries in SQL ServerKnowledge of data modeling, data mining, data analysis, and data visualizationKnowledge of machine learning algorithms preferredFamiliar with standard concepts, practices and procedures within the DSD business process and an understanding in the three tier systemExperience mapping business objectives into actionable analyses, and explaining technical concepts, and implications to a broad audience
Base Pay Range = $76,000 - $89,100 (+)
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
Essential Job Functions:
Understand, develop, and maintain data visualization in Power BI to be used to product ongoing weekly/monthly/yearly reports including, but not limited to: Shipments, Depletions, Distribution, Nielsen, Survey data and more.Work with large datasets (SQL Server, Azure SQL, Google Analytics, SAP) as needed to drive analytic, graphical, and reporting solutionsUnderstanding of Sharepoint objects such as Lists, Folders, and Online ListsHelp drive business stakeholder adoption of insights-driven decision making and/or business process innovationBecome subject matter expert on all sales data and employ tools such as R and Python to find hidden insights within the dataWorking with IT and other departments with our metadata to maintain user access, hierarchy and securityData cleansing exercises, either through manual update or data load to address issue areasIdentify, analyze and interpret trends or patterns in complex data setsPresent interpretation and insight to senior management, sales operations and the entire North American sales forceDevelop and maintain all documentation for report development and enhancementsLocate and define new process improvement opportunitiesProvide specialized system/software training.Other related duties as assigned.Position Requirements:
A minimum of 1-5 years of experience in field or in a related area.Masters degree in applied mathematics, statistics, business analytics or computer science preferredExperience presenting data insights to sales forceExperience developing business requirements with cross-functional teams across the companyExperience with Power BI Desktop, the Power BI Service, and related best practices preferredDAX & M experience (filter context, row context, columns vs. measures, etc.)Experience managing table relationships and advanced custom queries in SQL ServerKnowledge of data modeling, data mining, data analysis, and data visualizationKnowledge of machine learning algorithms preferredFamiliar with standard concepts, practices and procedures within the DSD business process and an understanding in the three tier systemExperience mapping business objectives into actionable analyses, and explaining technical concepts, and implications to a broad audience
Base Pay Range = $76,000 - $89,100 (+)
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)