Business Intelligence System Architect

| Greater LA Area

We are UMG, the Universal Music Group. We are the world's leading music company. In everything we do, we are committed to artistry, innovation and entrepreneurship. We own and operate a broad array of businesses engaged in recorded music, music publishing, merchandising, and audiovisual content in more than 60 countries. We identify and develop recording artists and songwriters, and we produce, distribute and promote the most critically acclaimed and commercially successful music to delight and entertain fans around the world.

We have opportunities for Business Intelligence System Architect in Data & Analytics group to join our growing tech team at Universal's offices and contribute to the development of our innovative approach to finding new and impactful insights to grow UMG's business.

The architect should have experience in architecting, managing and supporting Business Intelligence systems on various OLTP and Data Warehouse databases in on-prem data center, AWS and Google cloud platforms handling multi terabytes of Bigdata.

Job Functions:

  • Architect and Deploy Enterprise Reporting BI applications with MicroStrategy, SAP Business objects, DOMO and Tableau
  • Serve as primary MicroStrategy professional for the full life cycle of the MicroStrategy projects from requirement gathering to roll out
  • Architect MicroStrategy Schema Objects for the BI applications including schema/data modelling, dashboards, documents, reports and mobile applications
  • Assess and recommend data warehousing strategies including data transformation and load frameworks
  • Define data architectures for large scale solutions including integration with existing enterprise systems
  • Develop and manage BI application scheduled jobs, supports production job SLA compliance
  • Architect and develop real-time ETL processes that integrate data from multiple sources
  • Design and build complex queries for multiple databases/data warehouses, principally Google Big Query, AWS RedShift, Aurora, Oracle and Microsoft SQL Server
  • Develop custom Business intelligence applications using MicroStrategy web SDK
  • Design efficient Business Intelligence Dynamic Dashboards for the business users with dynamic prompt answers and multiple data sets in both MicroStrategy Desktop and MicroStrategy Web
  • Setting up MicroStrategy very large scale database properties for performance tuning and SQL optimization.
  • Create Hierarchies, Attributes, Facts, Custom groups, Consolidations and Relationships between various attributes and develop perfect logical models for reporting environments.
  • Develop Intelligent cubes based on the business specifications to increase BI reports performance
  • MicroStrategy Administration that includes Intelligence Server Administration, configuration of Memory settings, objects migration and maintain data integrity using integrity manager
  • Implement and manage single-sign on to allow seamless login to MicroStrategy and other enterprise applications
  • Develop transaction services enabled BI reports in web and mobile
  • Configure Narrowcast Server/Distribution Services for delivering reports and dashboards
  • Automating regular MicroStrategy maintenance activities using command manager scripts
  • Upgrade the existing MicroStrategy platform to newer versions and apply hot fixes in a timely manner
  • Develop statistical reports and dashboards to monitor BI applications providing insight on usage patterns and recommend application/system improvements
  • User provisioning; create security roles and data security filters to comply with business data security requirements
  • Create MicroStrategy narrow cast information objects, Question objects, publication control documents, event-based schedules
  • Design Flash enabled Interactive Dashboards, KPIs and scorecards using panels, selectors, widgets and deliver the files using narrow cast server
  • Provide BI technical and architectural guidance to projects and teams, ensuring new initiatives enable effective data reporting
  • Works closely with and directs the work of technical ETL and Data Engineering teams.
  • Directs the work of staff BI developers both onsite and offshore.

Job Requirements:

Skills/Abilities:

  • Strong ability to Architect Enterprise reporting applications, complex data models, BigData solutions, scripts, user defined functions, views and triggers for business logic implementation.
  • Experience in Google BigData Technologies BigQuery, DataFlow, BigTable, Cloud services and Amazon cloud web services.
  • Data architecture experience, with expertise in both OLTP and data warehouse modelling.
  • Architect the complete end-end to design of enterprise wide big data reporting solutions.
  • Experience in setup, software installation and maintenance of MicroStrategy web servers, Intelligence Servers and Narrowcast servers.
  • Experience in Architecture of SAP Business Objects Universes and Administration activities.
  • MicroStrategy and all of its components including Command Manager, Software Developer Kit, and MicroStrategy cube advisor, integrity manager, MicroStrategy Mobile and Architect.
  • Databases: Google BigQuery, Amazon Redshift, Amazon Aurora, MySQL, SQL Server, Oracle
  • BI Tools: Microstrategy, SAP Business Objects, Tableau, DOMO
  • ETL Tools: Snaplogic, Informatica, SSIS, Google Data flow
  • Operating Systems: Windows Server 2008/2012, Linux.
  • Languages: SQL/PLSQL, HIVE, Java, Python.
  • Scripting: Shell Scripting, VB Script and Java Scripting.

Experience:

  • 12 -15 Years of hands on experience in MicroStrategy and Business Intelligence systems.
  • Knowledge of Music Publishing business and information flow across artists, labels and distribution partners
  • Experience in Google Big Data technologies Google BigQuery, BigTable and Data Flow.
  • Experience in full-phase ETL implementation using technologies such as DataFlow, Informatica, Snaplogic, SSIS
  • Experience in SAP Business objects universe architecture, Lumira, Crystal Reports, WebI and CMC
  • Experience in Tableau Schema architecture and Administration
  • Architect and develop end to end scalable analytical MicroStrategy projects.
  • Experience in Amazon Redshift and Web Services
  • Certified in MicroStrategy Architecture, Administration and Development
  • Well versed in Star/ Snowflake/ Dimensional data modelling, Data Warehouse and reporting techniques for data analysis and optimum performance in database environments
  • Experience in implementing MicroStrategy Data and object security model, Object Manager, Enterprise Manager, Integrity Manager and System manger components

Education:

  • Bachelor's degree in Computer Science Engineering or related field preferred

Universal Music Group is an Equal Opportunity Employer.

Disclaimer

This job description only provides an overview of job responsibilities that are subject to change.


Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • PHPLanguages
    • PythonLanguages
    • ScalaLanguages
    • SqlLanguages
    • SwiftLanguages
    • jQueryLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • AccessDatabases
    • HiveDatabases
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • OracleDatabases
    • SAP HANADatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • SketchDesign
    • ConfluenceManagement
    • JIRAManagement
    • DrupalCMS
    • WordpressCMS
    • SalesforceCRM
    • Constant ContactEmail

Location

UMG IT is primarily based in Woodland Hills, a neighborhood bordering the Santa Monica mountains in the San Fernando Valley region of Los Angeles

An Insider's view of Universal Music Group

What’s the vibe like in the office?

Everyone is hard working but it’s still a pretty relaxed and friendly environment. If you need any help people are always ready to make time. Between the conference room with all over music related decorations, big lunch room with table-football and arcade games and a very casual dress code, the overall vibe is really chill.

Laurent Burte

Enterprise Portfolio Management Project Manager

How do you collaborate with other teams in the company?

Our team serves departments across the company by providing feedback and best practices on software asset management. We get to work with a lot of different teams which is really interesting.

Ashia Coleman

Junior Windows Systems and Application Administrator

What makes someone successful on your team?

Our team relies on the ability to have quick and meaningful communications, sharing of ideas in a constructive way and working closely as a whole team. You also need to be interested in always learning. Technology never stands still and neither does this team.

Todd Hancsicsak

Director, Rights & Repertoire Technology

What does your typical day look like?

There is no typical day at UMG, which is a good thing! I get an opportunity to work with numerous individuals within IT and the business on a variety of global projects. Having the opportunity to work with so many talented people globally and continuously learn and contribute to our business is very exciting.

Gauri Gohokar

Project Manager

What are Universal Music Group Perks + Benefits

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Vacation & Time Off Benefits
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Game Room
Parking
Fitness Subsidies
Professional Development Benefits
Tuition Reimbursement
Diversity Program
More Jobs at Universal Music Group74 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Internships
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Content
new
Hollywood
Design + UX
new
Hollywood
Content
new
Santa Monica
Finance
new
Santa Monica
Marketing
new
Santa Monica
Finance
new
Los Angeles
Finance
new
Los Angeles
Operations
new
Santa Monica
Data + Analytics
new
Los Angeles
Operations
new
Santa Monica
Project Mgmt
new
Los Angeles
Data + Analytics
new
Hollywood
Operations
new
Los Angeles
Data + Analytics
new
Hollywood
Marketing
new
Santa Monica
Marketing
new
Santa Monica
Operations
new
Santa Monica
Operations
new
Santa Monica
Data + Analytics
new
Santa Monica
Marketing
new
Santa Monica
Sales
new
Santa Monica
Marketing
new
Hollywood
Operations
new
Los Angeles
Design + UX
new
Los Angeles
Marketing
new
Santa Monica
Content
new
Santa Monica
Operations
new
Hollywood
Internships
new
Santa Monica
Finance
new
Los Angeles
Marketing
new
Los Angeles
Finance
new
Los Angeles
Data + Analytics
new
Los Angeles
Content
new
Los Angeles
Finance
new
Los Angeles
Design + UX
new
Los Angeles
Operations
new
Los Angeles
Operations
new
Santa Monica
Operations
new
Santa Monica
Internships
new
Hollywood
Marketing
new
Hollywood
Operations
new
Hollywood
Project Mgmt
new
Santa Monica
Operations
new
Santa Monica
HR
new
Santa Monica
Content
new
Santa Monica
Marketing
new
Santa Monica
Internships
new
Los Angeles
Sales
new
Los Angeles
Finance
new
Los Angeles
Product
new
Los Angeles
Marketing
new
Santa Monica
Finance
new
Los Angeles
Marketing
new
Santa Monica
Developer
new
Santa Monica