DATA ANALYST

POSITION SUMMARY.
OT VFX, a post-production services company in the entertainment industry with global clients, is looking for a mid-level position “Data Analyst” on a permanent role basis.
This role involves managing, aligning and ordering the data / reporting / analytic requirements against the business priorities, while working on the development of these requirements and overseeing the implementation of solutions.
This role reports to the COO.
he candidate must have experience relating to data modeling & analysis, systems and business process analysis as well as dashboarding.
OSITION RESPONSIBILITY Data Architecture Prepare architecture for data, prepare strategies and provide business object solutions as per requirements.
Manage all data for transactional sources to enable effective reports/Dashboards.
Plan and maintain development roadmap for data warehouse.
Data and Business Intelligence Interpret and act upon multiple reporting and analytical requests.
Define, Design, Develop the necessary core reporting architecture to enable appropriate automated Business Intelligence software solutions with emphasis on Tableau.
Work with the necessary key stakeholders in BOTVFX to ensure delivery roadmap.
Business expert in knowledge of data sets, data structure, software capabilities, and existing DA solutions.
Perform full development life cycle activities including building Proof of Concept, queries for reports/dashboards, validation and roll out.
Reporting Requirement Collaborate with the data/ reporting owners to fully define, document and gain functional sign off for reporting requirements.
Analyze all complex data, business logic, processes and identify requirements for business enhancement in a project.
Perform assessment on all reporting requirements and implement long term strategy for various reporting needs.
Align multiple requirements to ensure data and development is optimized for maximum benefit.
Ad Hoc / Support Manage the resolution of BI reporting issues by engaging with respective data, process, system owners and vendors to address issues impacting day to day operations of stakeholders.
Work closely with different departments to support their ad hoc analytical data and reporting requirements.
REQUIRED SKILLS Minimum 5 years experience working on databases with strong business analysis skills Strong Business Analytical Skills Strong experience in SQL (MS SQL is desirable), MS Excel formula/macros.
Excellent understanding of data modeling & data structure.
Understand complex data and create business logics.
ETL fundamentals, Database Scripting Knowledge.
Should be able to maintain and enhance data model by writing complex queries and stored procedures Stakeholder Management – able to foster strong relationships at all levels both internally and externally including senior leadership Understanding and adherence to key Information Security Best Practice.
Strong communication skills – able to tailor to non-technical users and multi-cultural team Should be willing to learn the VFX industry, business and relevant terminologies Detail oriented and hand on experience is a must Data Warehousing concepts - desired Hands-on experience on Tableau and exposure to LLM models is desirable