Senior Analytics Engineer

Motion-Picture-Industry-Pension-; Los Angeles (CA); Hybrid; USD 125,000 - 145,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

Generous paid time off

Retirement benefits

Professional development opportunities

Job summary

Motion Picture Industry Pension & Health Plans (MPI) in Studio City, CA, seeks a Senior Analytics Engineer to design, develop, and support enterprise analytics and BI solutions. The role focuses on building trusted data pipelines and dashboards using MS Fabric, Power BI, and SSIS, with strong SQL skills and governance.

You’ll translate business requirements into scalable analytics, collaborating with users and IT while ensuring data quality, performance, and compliance.

Qualifications

• 7+ years of hands-on experience as a SQL Developer or Data Analyst.
• Bachelor’s or Master’s degree in Computer Science, Business Administration, Information Systems/Technology or related field; or equivalent.
• Strong analytical and problem-solving skills in a fast-paced environment.
• Experience building and maintaining data pipelines using MS Fabric, modeling data with Fabric Lakehouse/Warehouse.
• Experience documenting data models, reports, and pipeline logic; understanding data warehousing concepts.
• Strong Power BI skills, including data prep, modeling, DAX, and paginated reports.
• Strong Alteryx experience: workflow development and operations.
• Proficiency with SSIS; experience administering Alteryx Server and MongoDB backups.
• Advanced Excel for data analysis and trend identification.
• Experience providing production support for BI/analytics solutions.
• Excellent communication and collaboration abilities.
• Willingness to work extended hours and adhere to governance/compliance requirements.

Responsibilities

• Design, develop, and deliver interactive Power BI datasets, dashboards, reports, and stories.
• Build and maintain ETL/ELT pipelines using SSIS, Alteryx, and Microsoft Fabric.
• Create and optimize complex SQL queries, views, and stored procedures.
• Develop Alteryx workflows and analytic applications.
• Provide daily operational support for BI solutions and dashboards.
• Ensure data quality, reliability, performance, and scalability.
• Apply data governance, lineage, and compliance standards using Microsoft Purview.
• Ensure HIPAA and applicable regulations in data utilization.
• Collaborate with business users and IT to translate requirements into analytics solutions.
• Communicate with both technical and non-technical audiences.
• Participate in design reviews and stay current with BI trends.

Skills

SQL

Data modeling

Power BI

Alteryx

SSIS

Fabric Lakehouse

Excel

Data governance

Education

Bachelor’s or Master’s degree in Computer Science/Information Systems/Business Administration

Tools

MS Fabric

Power BI

Alteryx

SSIS

MongoDB

Job description

Posted Thursday, July 23, 2026 at 10:00 AM

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.

MPI is recognized as a five-time certified Great Place to Work® employer and recipient of the World at Work Seal of Distinction because we believe people do their best work when they’re respected, supported, and inspired.

Role Overview:

MPI is seeking a Senior Analytics Engineer 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 ; no relocation or visa sponsorship is available. This is a hybrid position requiring regular and as-needed onsite work in Studio City, CA.

MPI requires employees to be vaccinated against Covid-19 with exceptions as required by law.

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 as a SQL Developer or Data Analyst
• 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 related experience.
• Strong analytical and problem-solving skills, with the ability to adapt to a fast-paced, dynamic work environment.
• Strong experience in building and maintaining data pipelines using MS Fabric, model and transform data using Fabric Lakehouse/Warehouse.
• Experience in documenting data models, reports, pipeline logic, and understanding of data warehousing concepts and best practices.
• Strong experience with Power BI, including data preparation, data modeling, DAX, and report optimization, with the ability to develop and maintain paginated reports using Power BI report Builder for operational and detailed reporting needs.
• Strong Alteryx experience, including workflow development, optimization, and operational support
• Proficiency in maintaining and supporting SSIS packages is required
• Experience administering and supporting Alteryx Server, including upgrades, MongoDB backups, and issue resolution
• 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.
• Ability to accept direction and developmental guidance from supervisor.
• 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, and formal presentations.
• Participate in design and peer reviews within the department
• Stay current with BI and data analytics trends, tools, and best practices

The anticipated base salary for this position is $125,000 - $145,000 annually. The actual base salary offered will depend on a variety of factors, including without limitation, the qualifications of the individual applicant for the position, years of relevant experience, level of education attained, certifications or other professional licenses held.

MPI offers a comprehensive benefits package, including free medical, dental, and vision coverage, generous paid time off, retirement benefits, and professional development opportunities.

Motion Picture Industry Pension & Health Plans (MPI) is an equal opportunity employer and does not discriminate against any applicant or employee on the basis of race, religion, color, national origin, ancestry, sex, sexual orientation, gender identity, age over 40, marital status, veteran status, mental or physical disability, pregnancy, genetic information, or any other basis prohibited by law. Any applicant who, because of disability, requires accommodation or assistance in completing this application or at any time during the application process should contact the Human Resources Department. MPI also provides reasonable accommodations to disabled employees consistent with its obligations under applicable law.