Motion Picture Industry Pension & Health Plans · 13 hours ago
BI SQL Analytics Developer
Los Angeles, CA
Full-time
Hybrid
Senior Level
$105K/yr - $125K/yr
7+ years expMotion Picture Industry Pension & Health Plans (MPI) has been serving the entertainment community for over 70 years, focusing on the financial and healthcare well-being of its members. They are seeking a BI/SQL Analytics Developer to design, develop, and support enterprise analytics and business intelligence solutions, ensuring data quality and compliance while collaborating with business users.
Funding PlatformHealth CareMedia and EntertainmentMedical
No H1B
Responsibilities
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
Qualification
Required
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, MongoDB 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
Preferred
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
Benefits
Free medical, dental, and vision coverage
Generous paid time off
Retirement benefits
Professional development opportunities
Company
Motion Picture Industry Pension & Health Plans
Motion Picture Industry Pension & Health Plans primarily supported by employer contributions as provided by these agreements.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
David Asplund
Chief Executive Officer
Company data provided by crunchbase