Technical Business Analyst (Media/Entertainment Finance)

Milestone Technologies, Inc.; Burbank (CA); On-site; USD 110,000 - 121,000; Full time

Job summary

Milestone Technologies, Inc. is seeking a Senior Business Systems Analyst to join a team focused on implementing innovative solutions to support the production of episodic television.

The team works to implement solutions across production, production finance and business affairs for multiple studios and platforms, focused on building solutions to business problems that increase insight and operational efficiency and are looking for a senior analyst to join our team.

Qualifications

• 10+ years of experience on custom software development projects.
• Deep domain experience in financial planning, financial reporting, ERP, or similar.
• Strong analytical and data analysis skills.
• Ability to understand complex systems and end-to-end processes.
• Experience writing test plans and performing application testing.

Responsibilities

• Develop a deep understanding of the television production business.
• Translate complex functional requirements into technical requirements.
• Collaborate closely with developers as subject matter expert.
• Lead change management for business readiness and user adoption.
• Provide first line support for user reported issues.
• Develop test cases, estimate test effort, perform testing, and document results.
• Create training materials and train users.
• Lead testing across web apps, reports, interfaces, data conversions, reconciliations, and production support.
• Data validation using Excel and SQL.

Skills

Software development experience

Financial planning domain

Data analysis

SQL/Excel data analysis

Testing/UAT

Agile/SCRUM

Documentation/writing

Communication with developers

Advanced Excel (Pivot/VLOOKUP)

Tools

Snowflake

Oracle EPM

SAP

Airtable

Job description

Technical Business Analyst (Media/Entertainment Finance)

24 Months Contract

Onsite> 4 days/week in Burbank CA

Description

Seeking a Senior Business Systems Analyst to join a team focused on implementing innovative solutions to support the production of episodic television. The team works to implement solutions across production, production finance and business affairs for multiple studios and platforms, focused on building solutions to business problems that increase insight and operational efficiency and are looking for a senior analyst to join our team.

Responsibilities

• Develop a deep understanding of the television production business


• Translate complex functional requirements into technical requirements


• Collaborate closely with developers in the role of subject matter expert


• Lead change management efforts to ensure business preparedness and user adoption


• Provide first line support for user reported issues


• Develop test cases, estimate test effort, perform application testing, and document test results


• Create training materials and train users


• Identify and communicate risks and issues


• Lead and execute testing activities across web applications, reports, interfaces, data conversions, reconciliations, and production support scenarios.


• Data validation using Excel and SQL

Basic Qualifications

• 10+ years of experience working on custom software development projects


• Deep business domain experience within financial planning, financial reporting, ERP, or similar


• Highly analytical with strong data analysis skills


• Ability to understand complex systems and end-to-end business processes


• Ability to work at a detailed level


• Ability to analyze data using a SQL database, multi-dimensional database, or Excel


• Experience writing test plans and performing application testing


• Experience conducting user acceptance testing


• Comfortable working in Agile/SCRUM environment


• Ability to communicate clearly and collaborate closely with developers


• Produces high quality written deliverables (specifications, test plans)


• Advanced Excel skills to include pivot tables, VLOOKUP, formulas

Preferred Qualifications

• Experience working at a major studio in television production or distribution


• Experience with enterprise financial systems (SAP, Oracle EPM)


• Experience with Airtable


• Experience with Snowflake or Oracle relational databases


• Experience with SOX applications

Education

N/A

The estimated pay range for this position is USD $80.00/hr - USD $88.00/hr. Exact compensation and offers of employment are dependent on job-related knowledge, skills, experience, licenses or certifications, and location. We also offer comprehensive benefits. The Talent Acquisition Partner can share more details about compensation or benefits for the role during the interview process.