Sr Business Intelligence Engineer
Location Preferences for this role are Burbank, CA - Bristol, CT - Seattle, WA - New York, NY - Woodlands, TX or Remote Work available for the right candidate
Disney's Media & Entertainment Distribution (DMED) division is a newly formed technology epicenter which combines Disney's tradition of bold innovation and creativity to directly deliver compelling content to hundreds of millions of people all around the world. Comprised of Disney's media businesses and the Company's various streaming services, the DMED segment aligns technology, content, and distribution platforms to expand the Company's global footprint and deliver world-class, personalized entertainment experiences to consumers around the world. Our employees are leading, creating, innovating, and making bold moves in unexpected directions that redefine not just what a mass media entertainment company does, but what it can do.
Within DMED, the Advertising Platforms team is responsible for creating and scaling innovative global advertising solutions by building mission-critical tools and workflows to support digital & linear ad sales, traffic, marketing and parts of broadcast operations. Being part of the DMED team is a once-in-a-career opportunity to be a part of what's next.
Using the latest technology from MicroStrategy and Oracle, the developer will design complex reports & exciting dashboards based on a semantic layer constructed from multiple sources. Partner with architecture and database developers to create conceptual designs and detailed technical specifications for MicroStrategy solutions. You will help drive design and construct projects for efficient ad-hoc reporting capabilities across the Ad Sales group. Design & construct grid/graphs, documents & dashboards according to requirements in a timely manner while managing promotion of projects/objects through the development, test and production processes. You will also assist with troubleshooting support tickets for operational issues and manage performance monitoring and tuning of the environments.
Responsibilities :
- Work with the analytics product and engineering groups to engage with business stakeholders, participating in requirements gathering sessions to understand, interpret and translate requirements into effective technical solutions
- Data Platform, and Analytics Engineering to discover, expose, and deliver information solutions
- In partnership with product designers, design prototypes and lead prototype working sessions with business leaders
- Leverage your understanding of SQL, rational databases, and normalization to drive data development in Snowflake and other data systems
- Develop dashboards and reports in MicroStrategy, Excel, and Tableau
- Assist with data discovery and systems analysis to direct business users to the right information
- Educate business stakeholders on available data, analytics, and reporting capabilities, in partnership with Product Management
- Effectively communicate and interact with business and technical stakeholders to solve complex data related business and technical problems
- Ensure compliance with company data and software policies and procedures
- Be able to work under minimal supervision and with a wide latitude for independent judgment
- Having a wide-range of experience you will use professional concepts and company objectives to resolve complex issues in creative and effective ways.
Basic Qualifications :
- 5+ years of experience working as a MicroStrategy developer (MicroStrategy 9 or greater), 5+ years of working in a data warehousing environment, MicroStrategy project development, complex report development, dashboards, performance tuning, and Oracle 10g or greater.
- Minimum 5 years of working experience in data and business analysis
- Expert knowledge of data systems and SQL
- Experienced with Excel and data manipulation
- Knowledge of ETL systems and data pipeline.
Preferred Qualifications:
- Experience with BusinessObjects
- Experience with Python programming
- Data and analytics/measurement experience in digital or mobile app environment preferred.
- Experience in Linear or Digital Ad Sales will be a huge plus.
Required Education :
- Bachelors in Computer Science or equivalent work experience
Preferred Education :
- Masters in Computer Science or equivalent work experience