Business Intelligence Manager @ Monster Energy - Corona, CA

Position Summary

The ideal candidate maintains authenticity and has the highest integrity in the work assigned. This candidate embraces change, is willing to share knowledge and gain knowledge from others. An entrepreneurial spirit, the drive to take ownership and move the business forward is imperative to succeed in this role. The role requires the ambition to “Get Stuff Done”, a penchant for problem solving, critical thinking and a thirst for achievement. Trust, respect of differences and commitment are Monster Family prerequisites that are pivotal the role. The ideal candidate must be adept at working cross functionally and not susceptible to a data silo mindset.

Be Authentic | Teach & Be Taught | Own It | GSD | The Monster Family

The Business Intelligence Manager is responsible for the design, development, deployment, and system administration of business intelligence solutions using the Microsoft Business Intelligence stack and related technologies. Most solutions will incorporate PowerBI reports and/or tabular reporting. Some solutions will include web hosted CRUD application development. The role is responsible for the management and maintenance of various structured data. The role demands heavy ETL, lift & shift routines and mapping of data from raw form into pristine data. The role requires pristine data is swiftly made available for distribution and ingestion by cross-functional teams thought out the organization, e.g., Business Development, Data Science, Sales Analysis, Category Management, Enterprise Data Warehouse & Reporting, and others.
The role shares joint administrative responsibilities and must be tightly aligned with the IT department, and strictly follow the IT department’s prescribed policies and procedures for all technologies under the role’s stewardship.

Essential Job Functions:

• Azure Cloud Services (PaaS) administration and development
• Stand up and manage Azure resources, Logic Apps, ADF, Azure Database/Data Warehouse, Azure CLI (PowerShell)
• On Premise SQL administration and development
• SSMS (T-SQL), SSIS, SSAS - cubes and tabular models, SSRS
• Working with large data sets both in SQL and in SSAS Tabular
• Web UI/UX experience: ASP.NET Core, PowerApps, ASP.NET MVC (Razor), Angular, React, PHP/HTML5/
  JavaScript/jQuery/JSON and or similar technologies required for CRUD operations
• Microsoft Power Stack administration and development, PBI Gateway (for on premise)
• Power BI Datamarts, dataflows, Shared Datasets
• Power BI (DAX), PowerQuery (M), Power Apps, Power Automate, Power Virtual Agents
• Building PBI Dashboards and Tabular Reports (RDL)
• Data modeling in Excel/PowerPivot/PowerBI Desktop with large data datasets having multiple fact and dimension
  tables
• Strong communication and presentation skills – able to present to executive leadership and peers alike,
  both in technical and layman terms
• Collaboration skills
• Critical thinking, problem solving, and deep troubleshooting
• Preferred Skills:
• SAP
• C#/VB.NET
• Experience with or/ability to quickly learn effective use 3rd party proprietary data mining and
  reporting tools e.g., Nielsen Connect, IRI Liquid Data, Numerator, RetailLink, SPINs, VIP, Dimensional
  Insight Diver, etc.

Position Requirements:

Beneficial Skills

• R language, Python, Jupyter Notebooks, Dynamics 365, Google Analytics
• SharePoint

Qualifications

• Undergraduate degree BS, BA in business related field, Bachelor’s degree in technical field
  or 7+ years working experience in essential skills/hands-on qualifications
• Strong project and process management background
• Preferably experience with both Agile and Lean methodologies
• SDL documentation experience including ERDs, data flow diagrams and misc. flow charts
• 5+ years of requirements engineering experience (Technical and Functional)
• 5+ years DBA experience (SSMS or MySQL workbench)
• 5+ years cloud computing experience (Azure | AWS)
• Data orchestration (Data Factory | AWS Data Pipeline)
• Compute (Virtual Machines | EC2)
• RDBS Database (SQL Database | MySQL | RDS)
• Visualization (PowerBI | QuickSight)
• Proficient with various API implementations (JSON, REST, jQuery, JavaScript, Google Maps, etc.)
• Competence in Data Modeling
• Track record of taking projects from concept to release
• Experience leading product training efforts

Pay Range : $99,600 - $117,200k