Job Description
This is a full-time (W2) position with Blue Pisces Consulting Inc. where you will have the opportunity to work with our client, a very notable and respectful entertainment company. As part of our 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 dashboards, data models, and visualizations using latest technology standards, as well as develop and implement innovative techniques for measuring, analyzing, and reporting on project and various Studio’s data in an Agile team environment.
Responsibilities
- Proficient with Power Query, DAX, 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
- 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
Basic Qualifications
- 5+ years of PowerBI Experience
- 3+ years' experience with DAX, Power Query, and MDX
- Excellent analytical and problem-solving skills
- Excellent verbal and written communication skills
- Creative and innovative thinker
- Meticulous attention to detail
- Great team player and able to work efficiently with minimal supervision
Preferred Qualifications
- 3+ years of Data Warehouse
- Familiar with Media & Entertainment data
- Required Education: Bachelor’s degree in Computer Science or Engineering, or related technical discipline
Benefits
This is a full-time, W2 position (not a contract) with Blue Pisces Consulting Inc. We offer a very competitive benefit package including:
- Attractive compensation
- Paid holidays and sick days
- Paid vacation days
- Comprehensive Medical, Dental and Vision package (50% paid for employees, 25% for spouses/dependents)
- Discretionary bonus
- 401(k)
** Please note: We cannot currently provide visa sponsorship. If you require visa sponsorship now, or in the future, please do not apply for this position. **