Job Description
We are seeking a highly motivated and experienced Data Engineer with Power BI experience to join our Program Management & Enabling Technologies team.
You will be responsible for developing and maintaining data models/visualizations for strategic dashboards and reports serving key stakeholders such as Studio Executives, Financial leaders, Operational leaders, Project/Program Managers and Engineers.
The ideal candidate will bring expertise in designing and implementing reports and visualizations using latest technology standards, as well as develop and implement innovative techniques for measuring, analyzing, and reporting on project and various Studios financial data in an agile team environment.
Responsibilities
- Proficient with Power Query, DAX, and MDX for complex data projects
- Experienced in authoring, diagnosing, and altering SQL Server and Postgres objects
- Experience creating and maintaining reporting assets in Power BI
- Analyze business requirements into technical requirements for reporting/visualizations, data models, and databases
- Review technical specifications derived from technical requirements
- Develop reporting for business consumption using a variety of BI tools
- Work on drill-through reports using relational models
- Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation
- Experience building and maintaining data pipelines
- Experienced in developing custom visuals serving various levels of need -- executive dashboards to individual-usage reports
- Provide detailed source analysis and data mappings/transformations to BI developers to implement new data sources and integrations
- Devise and deliver testing plans and testing data to validate BI solutions
- Perform data analysis, profiling, and quality assessment to ensure the integrity of business data to necessary levels
- Assist with complex incident management situations affecting BI capabilities and solutions
- Review design proposals of other BI Analysts and vendors; as well as, perform reviews on work during various stages of delivery for adherence to current standards
- Perform peer reviews and mentor less experienced BI Analysts on solution approaches and ensuring conformity to standards and quality
- Work with technical leads and architects to implement new standards, new technology, and tactical solutions driving the business strategy forward
- Works within the System Development Life Cycle
- Monitor the lifecycle of BI systems by being aware of obsolescence and release dates for the product per the System Development Lifecycle
- Excellent written and verbal communication skills
- Ability to work effectively with remote teammates and users
- Designing beautifully organized analytics dashboards for upper management
This team manages 400+ internal end users across 4 of Disney Studios Banners(i.e. Marvel, Disney Animation, etc.) from 20+(growing) data sources(all types of data including studio/vfx financials, production based apps, internal studio bus apps, etc.), 200 Report Pages.
Team is 10 PPL, including the manager. We have 5 people currently on the team, including Data SWE, PowerBI, Data Product Manager, PM, QA Engineer.
Required Skills & Experience
- 5 plus years of Business Intelligence Engineering, specifically with PowerBI
- 5 plus years' experience with DAX, Power Query, and MDX
- Remote, must work PST hours
- Must have a work portfolio(via PowerBI) or be able to create and/or share examples of visuals/dashboards created in the past.
- Experience creating complex dashboards/reports that are dynamic/responsive, must have experience Writeback.
- Direct experience building/creating visuals/dashboards/reports with financial data(Important)
- Excellent verbal and written communication skills(important as the entire team sits remote nationwide)
- Prior experience working on a team that has several data integration points, several report pages, etc.
Nice to Have Skills & Experience
- Data Warehouse experience
- Programing experience using Python, SQL, and GoLang
- Familiar with Media & Entertainment data
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.