BI SQL Analytics Developer

For more than 70 years, the Motion Picture Industry Pension & Health Plans (MPI) has proudly served the entertainment community by supporting the financial and healthcare well-being of the people who bring stories to life — from set crews to post-production pros.

We’re not just analysts and data experts; we’re problem-solvers, collaborators, and stewards of trust. Our teams are guided by a simple mission: to improve the lives of those who work in the entertainment industry through accuracy, accountability, and care.

Role Overview

We are seeking a BI/SQL Analytics Developer to become a member of our IT department in Studio City. This hybrid role requires an independent contributor who will be responsible for the design, development, and support of enterprise analytics and business intelligence solutions.

This position plays an integral part in developing and supporting analytics platforms including Microsoft Fabric, Power BI, Alteryx, and SSIS. Successful candidates will have the ability to leverage strong SQL skills to deliver trusted, governed, and scalable data solutions. You’ll work closely with business users to translate requirements into actionable insights while ensuring data quality, performance, and compliance.

Local candidates only, relocation assistance is not provided. We do not offer visa sponsorship for this job classification.

Qualified candidates, please submit your current resume with a cover letter and your compensation requirements for consideration.

Submissions will be reviewed; only candidates most closely matching the requirements of the position will be contacted.

What You Will Need

• 7+ years of hands-on experience with SQL and SSIS
• Bachelor’s or Master’s degree in Computer Science, Business Administration, Information Systems/Technology or a related field; or equivalent combination of education, training, and 4-6 years of related experience.
• Strong experience developing, configuring, deploying, and supporting SSIS packages from multiple data sources
• Proficiency with Power BI, including data preparation, data modeling, DAX, and interactive dashboard development
• Strong Alteryx experience, including workflow development, optimization, and operational support
• Experience administering and supporting Alteryx Server, including upgrades, Mongo
  
  DB backups, and issue resolution
• Thorough understanding of enterprise data warehousing concepts, including designing, developing, and maintaining data marts
• Experience using Microsoft Fabric components for analytics and data integration
• Advanced-level Microsoft Excel skills for analyzing datasets and identifying trends or inconsistencies
• Experience providing production support for BI and analytics solutions
• Excellent communication skills (verbal and written) with the ability to work well with individuals at all levels of the organization.
• Excellent attendance and reliability, with the ability to work extended hours as needed.
• Experience in regulated industries such as insurance, healthcare, and financial services preferred.
• Experience supporting self-service BI and governed analytics environments and a familiarity with modern data governance/compliance preferred.

What You’ll Do

• Design, develop, and deliver interactive Power BI datasets, dashboards, reports, and stories that are easily understood
• Build, deploy, and maintain ETL/ELT pipelines using SSIS, Alteryx, and Microsoft Fabric
• Design, create, and optimize complex SQL queries, views, and stored procedures
• Design, develop, deploy, and manage Alteryx workflows and analytic applications
• Provide daily operational and production support for Power BI, Alteryx, and other BI solutions, including dashboards and reports
• Ensure data quality, reliability, performance, and scalability across analytics solutions
• Apply data governance, lineage, sensitivity labeling, and compliance standards using Microsoft Purview
• Ensure regulatory compliance (HIPAA and other applicable regulations) in all aspects of data utilization and access
• Collaborate with business users and IT partners to translate requirements into effective analytics solutions
• Communicate professionally with technical and non-technical audiences through written, verbal,…