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
Click
here to apply!
|