Hope you are doing fine!
We have this position for you, and I am looking forward to hear from you with your updated profile along with your comfort and availability about the requirement below.
Job Title Senior Data Analyst
Location Los Angeles, CA
Duration 12+ Months Contract
Job Description:
As a member of Data Services Management team, this person will create and maintain source to target designs and mappings, provide detailed data analysis, and manage metadata in support of the development and/or implementation of new or enhanced systems projects or programs. Participates in development of strategic and tactical planning activities, and works with IT PMO, business users, and technical peers to provide solution estimates. Reviews business requirements and leads source to target design efforts including system technical flows, use case analysis for a complex portfolio set of applications, leading a team of data analysts. Leads joint application design requirements and solution sessions across IT and business teams. Implements improvements to the quality of processes, standards and metrics. The Data Analyst works with subject matter experts from the project team to determine data requirements for analytical systems, develop these requirements into functional specifications and detailed data flow design documents, and participates in the full development process life-cycle from concept, through testing, to implementation. This includes identifying necessary data, reconciling with the new application and the legacy data sources and ensuring a successful implementation. This will include communicating business term definitions, establishing data quality rules, researching and analyzing data in support of business functions, process and workflow knowledge, and user acceptance testing. Leads the data and system impact analysis incorporating system designs and system architecture. Participate in problem management process. Performs data profiling and detailed data analysis of source systems and target analytic solutions.
Responsibilities:
- Own the design, development, validation, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions
- Develop and maintain the Core Data Dictionary and MDM
- Conduct hands-on modeling/analytics retrieving, compiling, and analyzing large volumes of data from disparate databases into distilled, actionable information and insights
- Develop and own business intelligence dashboards for operational aspects of the business
- Analyze data, including utilization, turns, lifetime value and profitability
- Supports data engineering team to help define business metrics and to close data gaps in our data warehouse
- Collaborate with data scientists to help build advanced analytical models
- Find ways to use data to empower team members across the business to take action in real time
Qualifications/Requirements:
- 3-5 years of experience as a data analyst, preferably with an entertainment or digital media company
- Exceptional analytical and quantitative skills with ability to interpret and summarize complex data that drive actionable plans that add value to the business
- Expert in MS Excel
- 3-5 years of professional experience using advanced SQL in a cloud data warehouse environment (such as Redshift, Snowflake or Hive), including window functions and CTEs
- Experience with AWS Stack (S3, RedShift, Spectrum, Glue, etc.)
- 2-3 years of experience with BI tools such as Looker, Tableau or AWS QuickSight
- Bachelor’s degree with a major in Math, Statistics, Finance, Economics, etc. is strongly preferred
- Knowledge of various software development processes, including SDLC, Agile methodologies, tools and technologies
- Detail-oriented and exceptional organizational skills
- Excellent verbal and written communication skills with the ability to interact at all levels of the organization
- Experience with Python or R is a plus, but not required
- Experience with Big Data (Hadoop, Spark, EMR, Streams, etc.) is a plus but not required
