Senior Business Intelligence Developer

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.

ResponsibilitiesProficient with Power Query, DAX, MDX for complex data projectsExperienced in authoring, diagnosing, and altering SQL Server and Postgres objectsExperience creating and maintaining reporting assets in Power BIAnalyze business requirements into technical requirements for reporting/visualizations, data models, and databasesReview technical specifications derived from technical requirementsDevelop reporting for business consumption using a variety of BI tools.Work on drill-through reports using relational modelsAble to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automationExperienced in developing custom visuals serving various levels of need – executive dashboards to individual-usage reportsProvide 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 skillsAbility to work effectively with remote teammates and usersDesigning beautifully organized analytics dashboards for upper management

Basic Qualifications 5+ years of PowerBI Experience3+ years' experience with DAX, Power Query, and MDXExcellent analytical and problem-solving skillsExcellent verbal and written communication skillsCreative and innovative thinkerMeticulous attention to detailGreat team player and able to work efficiently with minimal supervision

Preferred Qualifications 3+ years of Data WarehouseFamiliar with Media & Entertainment dataRequired Education: Bachelor’s degree in Computer Science or Engineering, or related technical discipline

BenefitsThis is a full-time, W2 position (not a contract) with Blue Pisces Consulting Inc. We offer a very competitive benefit package including:

Attractive compensationPaid holidays and sick daysPaid vacation daysComprehensive Medical, Dental and Vision package (50% paid for employees, 25% for spouses/dependents)Discretionary bonus401(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. **

Key Skills

• PostgreSQL