Business Intelligence Analyst

Overview

Who We Are

SAG-AFTRA is the iconic American labor union that represents approximately 160,000 media professionals. SAG-AFTRA employees support our members and thrive on securing the strongest protections by negotiating the best wages, working conditions, health and pension benefits. We preserve and expand members’ work opportunities, vigorously enforce our contracts and protect our members against unauthorized use of their work. ​

Responsibilities

What You’ll Do

As part of the Center for Business Innovation, the Business Intelligence Analyst functions as a bridge  between internal and external business customers to brainstorm and develop both technical and  functional solutions that innovate industry business processes supported and / or administered by the  Union. This position will also produce reports for internal staff as well as external entities, assist in the  creation and maintenance of Business Intelligence applications, and also perform SQL queries on Oracle  and MS-SQL servers and utilize data from various other sources such as Excel, Sheets, etc.

(Most significant job duties performed. It does not explain in detail every single duty performed.)

Evaluate internal opportunities for process / technical improvements

Conduct business evaluation / ROI analysis where applicable

Develop business plans and strategy

Meet with internal departments to gather requirements, research and or / design solutions, and  build, test, implement and train on solutions.

Communicate functional requirements to internal IT staff and / or consultants and oversee the  development of the solution when applicable.

Develop wireframes and process flow diagrams.

Develop formal documentation including, but not limited to project plans, schedules, requirements  and test plans.

Develops, implements and supports Business Intelligence applications

Works with business users, developers and other IT staff to gather requirements for ad hoc and  scheduled reporting needs

Performs SQL queries as needed to fulfill reporting requirements

Assists DBA’s with data gathering, loading and reporting of data from multiple sources

Optimize SQL on existing and future Business Intelligence applications

Troubleshoot and support existing applications where necessary.

Communicate progress to management and other interested parties.

Performs other duties as assigned.

Qualifications

What You’ll Need

We want to make sure you’re successful. To be considered, you must have :

(The individual must possess the following knowledge, skills and abilities and be able to explain and demonstrate that he or she can perform the essential functions of this job with or without reasonable accommodation, using some other combination of skills and abilities.)

Strong experience with relational databases required

Strong experience in Business Intelligence required

Experience in Microsoft Excel or Google Sheets required

Experience with Oracle and Microsoft SQL Databases preferred

Experience with Structured Query Language (SQL) required

Experience with Qlikview and Qlik Sense preferred

Experience with technical documentation a plus

Experience with systems documentation such as Requirements, Design, and Test Plans.

• Experience with Google Workspace applications. (Docs, Sheets, Slides, etc)
• Ability to organize meetings and deliver effective presentations to all levels.

Ability to assess risks, and to provide remediation plans

Ability to work well in a team environment and under pressure.

Able to communicate effectively in English, both orally and in writing.

Superlative interpersonal skills : High degree of patience and tact, and must be able to cultivate  respectful, strategic, and collaborative relationships with people from diverse backgrounds; both  internally and externally.

Hold yourself and others accountable for a high level of performance and integrity.

Have an understanding and awareness of worker rights impacting SAG-AFTRA members.

Must be available and willing to work extended hours per day or week, including weekends and  holidays, as SAG-AFTRA determines is necessary to meet its business needs.

Must be available and willing to travel to such locations and with such frequency as SAG-AFTRA  determines is necessary or desirable to meet its business needs.

MINIMUM QUALIFICATIONS :

Education and / or Experience :

Bachelor’s degree a plus

3 years of experience in business analysis required

PREFERRED BACKGROUND :

Working knowledge of the entertainment industry and / or with unions preferred.

Experience with G-Suite, including Slides, Sheets, etc. preferred.

Experience with office and / or building management preferred.

PHYSICAL REQUIREMENT / WORK ENVIRONMENT :

Unless otherwise stated, the work environment is normal and absent of disagreeable elements.

Regularly (67-100%) Seeing, hearing / listening, talking, sitting, typing

Frequently (34-66%) Walking, standing, writing

Occasionally (12-33%) Bending

Rarely (0-11%) Driving, lifting

What You’ll Get

We are a great place to work because we offer :

Colleagues that are passionate about what we do and how they contribute to our mission

Balance between work and home life responsibilities

Affordable and comprehensive medical and dental plans

Generous pension plan

Employee discounts and perks