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. ​

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.

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. • Must be able to work in a challenging environment where constructive feedback from others is  encouraged. 

• Have an understanding and awareness of worker rights impacting SAG-AFTRA members. • Must maintain regular and acceptable attendance at such a level as is determined at SAG AFTRA’s sole discretion. 

• 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:

• Annual Salary of $70,304.00 

• 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