Data Analyst (SQL & Snowflake & Marketing Data)

Data Analyst 1

Duration: 12 Months possible extension

Location: One Pennsylvania Plaza, 26th Floor, New York, NY, USA

Schedule: 4 days in office till December 26 then fully on-site

Interview Process: 2 rounds - first round with be technical, 2nd round will be on-site with HM and 2 others

Additional Information provided by HM

• SQL is # 1 to succeed in this role
• Highly communicative person
• Communicate with internal sales stake holders and outside clients
• Customer facing role
• Data analysis role
• become an account specialist - will be given a specific client to deliver current reports and ad hoc requests via JIRA, building the relationship, help automate reporting
• Any marketing background would be helpful and given preference
• Building data pipelines (need experience building pipelines) - will be a big part - building new from snowflake - take raw, non-clean data from snowflake
• AWS is preferred experience
• Need a bachelor's degree
• Work with big data

Team works with snowflake, raw data from marketing for client, work with client on what they want to measure, then implement the SQL data & build structure of reporting

Qualifications

• 3 years in data analysis

• Strong SQL skills – 2 years using SQL.

• 2 years of Python experience.

• Exposure to Snowflake.

• Experience with AWS tools such as IAM, Lambda, EC2 and S3.

• Jira, Confluence, GitHub and other agile development tool experience.

• Experience with automation, and ability to build custom solutions for unique client needs across various software tools.

• Ability to communicate technical roadblocks to non-technical stakeholders.

Responsibilities

• Working closely with internal stakeholders, translate business requirements into SQL queries and Python scripts for Ad Hoc analysis and custom reporting solutions
• Transform and cleanse outputs into meaningful analysis for business/sales teams
• Explore data to identify client ad performance opportunities, trends and anomalies, contribute to new reporting capabilities/solutions.
• Architect data pipelines to connect different data sources and automate reporting flows.
• Develop and maintain Extract, Transform & Load (ETL) processes tailored to evolving client needs.
• Tune and optimize current reporting solutions to meet updated client needs, new measurement methodologies, or improve query performance.

Bonus:

• Degree in computer science/engineering or quantitative discipline (Economics, Statistics, Engineering, Physics, Mathematics.

• Familiarity with media, TV measurement.

• Experience designing AB tests.

• Big Data / Data Lake Experience.

• Exposure to Data Cleanrooms.

• Athena Experience.