Senior Analytics Engineer
Motion Picture Industry Pension & Health Plans · Los Angeles, CA · 1 wk ago
HybridEngineering$125k–$145k/yrFull-time
About the role
MPI is seeking a Senior Analytics Engineer to join our IT department in Studio City. This hybrid role involves designing, developing, and supporting enterprise analytics and business intelligence solutions.
Responsibilities
- Leverage strong SQL skills to deliver trusted, governed, and scalable data solutions.
- Work closely with business users to translate requirements into actionable insights while ensuring data quality, performance, and compliance.
- Build and maintain data pipelines using MS Fabric, model and transform data using Fabric Lakehouse/Warehouse.
- Document data models, reports, pipeline logic, and understand data warehousing concepts and best practices.
- Develop and maintain paginated reports using Power BI report Builder for operational and detailed reporting needs.
- 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.
Requirements
- 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.
- 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.
Qualifications
- Free medical, dental, and vision coverage.
- Generous paid time off.
- Retirement benefits.
- Professional development opportunities.
Benefits
- Comprehensive benefits package.
Pay
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.
Schedule
This role is hybrid, combining remote and in-office work.