Data Analyst - Remote

Recruit Monitor; City of Rochester (NY); Remote; USD 80,000 - 100,000; Full time

Job summary

A leading digital video organization is seeking a Data Analyst with expertise in SQL and data warehousing to manage large-scale data solutions. This role involves analyzing complex data, delivering insights through reports and dashboards, and collaborating with teams to automate business processes. Candidates should have a Bachelor's degree in a quantitative field and at least 3 years of experience in a similar role. Familiarity with AWS technologies and relational databases is highly desired. This position offers valuable exposure to exciting projects and challenges.

Qualifications

• 3+ years as a data analyst or similar role.
• Proficiency with SQL and relational database concepts.
• Experience with relational databases and data pipelines.

Responsibilities

• Analyze and interpret complex data, patterns and processes.
• Provide analysis, reports, dashboards, and insights.
• Manage, maintain, and report on daily results of data jobs.
• Provide Root Cause Analysis for data issues.

Skills

Advanced SQL skills

Data analysis

Strong analytical skills

AWS experience

Report development

Relational database concepts

Education

Bachelor's degree in Computer Science or related field

Tools

Redshift

Business Intelligence Dashboard

Job description

Endeavor Streaming, part of Endeavor, is building the worlds most advanced content distribution platform for Content Creators, Global Brands, TV Broadcasters and Sports Federations.

Role:

• SQL / Data warehouse (Redshift) / AWS experience required for this.

You will assist in the management and growth of a large-scale data solution enabling TV everywhere with a worldwide leader specializing in digital video broadcasting, distribution, and monetization. You will build and manage solutions and processes that will grow and solve critical business needs. You will learn and implement new business processes and automate them with today's and tomorrow's technologies. You will be exposed to many exciting projects that will broaden your industry experience and continuously enhance your skills with new challenges.

Responsibilities:

• Analyze and interpret complex data, patterns and processes
• Provide analysis, reports, dashboards, and insight of data supporting existing and new initiatives.
• Work with a team to define and implement solutions allowing the visibility of data and insight for use at the business level
• Manage, maintain, and report on the daily results of daily data jobs and processes both internally and externally
• Provide Root Cause Analysis and related documentation and communications of data issues and the data solutions we provide.
• Work with external clients and internal finance department on the delivery of data and reports.

Skills:

• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, Quantitively-oriented degree, or a related field
• 3+ years as a data analyst or similar role.
• Must have a high degree of initiative and strong analytical skills
• Must have advanced skills in report development, SQL queries, views, functions, and stored procedures.
• Must have experience with relational databases, data lakes, data warehouses such as Redshift, and ETL/ELT data pipelines
• Proficiency with SQL and relational database concepts
• Must have experience working with AWS related technologies
• Must have experience working with an off-the-shelf Business Intelligence Dashboard product.
• Experience in meeting directly with business managers and their teams without direct support from their manager