Business Intelligence Mgr

Company: Monster Beverage 1990 Corporation
Location: Corona
Posted on: June 25, 2022

Job Description:

Position Summary

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

o Azure resources, Azure Logic Apps, Azure Data Factory (JSON), Azure Database/Data Warehouse, Azure CLI (PowerShell)

* On Premise SQL administration and development

o SSMS (T-SQL), SSIS, SSAS - cubes and tabular models, SSRS

o Working with large data sets both in SQL and in SSAS Tabular

* Web UI/UX experience

o 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

o Power BI (DAX), PowerQuery (M), Power Apps, Power Automate, Power Virtual Agents

o Building PBI Dashboards and Tabular Reports (RDL)

o Data modeling in Excel/PowerPivot/PowerBI Desktop with large data datasets having multiple fact and dimension tables

o PBI Gateway (for on premise)

* 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.

Position Requirements:

* 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

a. Preferably experience with both Agile and Lean methodologies

b. SDL Documentation 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)

a. Data orchestration (Data Factory - AWS Data Pipeline)

b. Compute (Virtual Machines - EC2)

c. RDBS Database (SQL Database - MySQL - RDS)

d. 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

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.

Beneficial Skills:

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

Keywords: Monster Beverage 1990 Corporation, Corona , Business Intelligence Mgr, Other , Corona, California