Manager, Business Intelligence

Manager, Business Intelligence

03 Jan 2024
California, Northhollywood, 91604 Northhollywood USA

Manager, Business Intelligence

Vacancy expired!

The Business Intelligence Manager designs and implements systems to collect, process, manage and analyze key health and retirement data for insights that support administrative and executive decision making and strategic planning. This position will collaborate with Business Users and Business Leaders to define, conceptualize, design, develop and coordinate all reporting and analytics efforts within MPI to meet the needs of both Internal and External Stakeholders.

Candidates should submit a letter of interest, with resume, and salary requirements

Qualifications:
  • Bachelor’s degree or equivalent work experience
  • 2+ years' experience formally managing a team
  • Outstanding presentation skills for audiences up to and including the senior leadership team
  • Excellent, clear, articulate verbal and written communication skills
  • Minimum 5+ years of experience leading development and/or data analytics projects with strong knowledge of building and presenting reports and dashboards
  • 4+ years' experience using BI tools (i.e. Tableau, Alteryx, Qlik, PowerBI, etc.) to create interactive data visualizations and reports
  • Excellent analytical skills and ability to analyze technical data with regard to health and retirement benefits
  • Advanced SQL writing using data warehousing, star schema, data matts, master data, Tableau development, and Alteryx workflow skills
  • Strong analytical, problem-solving and troubleshooting skills - ability to define problems, collect data, establish facts and draw conclusions
  • Exposure to ETL tools such as SSIS, Alteryx and Informatica
  • Experience with SDLC methodologies
  • Excellent ability to elicit, gather, manage, and translate requirements into reports, views, and BI query objects
  • Self-motivated with ability to manage multiple priorities
  • Work closely with business and IT leaders
  • Possess advanced proficiency in MS Excel, Word, PowerPoint Previous experience in healthcare, insurance and/or pension plan administration strongly preferred
  • Ability to organize thoughts and present information in an informative, relevant and concise manner to internal and external stakeholders

Your responsibilities would include:
  • Oversees the collection and processing of Bl data, analyzes and presents key financial, demographic, health and retirement information for operational and administrative support and executive decision making
  • Understands pension and health data and takes initiative on presenting information in an accurate and meaningful way for various audiences, including business partners/consultants, executive management and the Board of Directors
  • Works closely with department heads, business partners and vendors, consultants and executives to determine analytic specifications
  • Thorough understanding of enterprise data warehouse, data mart and data analytics
  • Design and build internal and external customer-facing reports using Power Bl and/or Tableau
  • Collaborate with stakeholders to identify the data elements in each report, construct the necessary queries and data models, and assemble the front-end of each report
  • Use creativity to visualize and format data/output in new and interesting ways that are geared towards quickly uncovering key business insights
  • Assist with the ongoing transition of existing reports from SSRS to Power Bl or Tableau, including identification of opportunities to streamline, refactor, redesign, and consolidate reports
  • Create/maintain documentation associated with reports and analytics, consisting of data sources, sample data, fields, calculated measures, filters, parameters, and/or business logic used in each module
  • Translates large, complex data sets into polished and understandable, visualization formats
  • Creates, develops and maintains executive dashboards displaying key performance indicators
  • Manipulates and integrates data from several sources to design comprehensive reports
  • Statistically summarizes key financial, demographic, health and retirement information
  • Creates effective visualizations of the summarized data using modern predictive analytic and machine learning techniques

Local candidates only, relocation assistance is not provided.

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

MPI does not file visa petitions or sponsor applicants for work visas in this job classification.


About MPI

Located in Studio City, CA, the Motion Picture Industry Pension and Health Plans (MPI) are multi-employer trust funds established by collective bargaining agreements between various employers and over 30 Unions and Guilds representing employees in the motion picture industry.


Recognized as an Employer of Choice for its employee-focused work environment, competitive compensation and benefits, MPI is a recipient of the World at Work Seal of Distinction.

MPI offers free employee health, dental, vision and life insurance ($50/month for family coverage), retirement and pension, and generous paid time off.


Equal Opportunity Employer

Related jobs

Job Details

  • ID
    JC7714645
  • State
  • City
  • Job type
    Permanent
  • Salary
    Depends on Experience
  • Hiring Company
    Motion Picture Industry Pension and Health Plans
  • Date
    2020-12-30
  • Deadline
    2021-02-28
  • Category

Jocancy Online Job Portal by jobSearchi.