Job Title: Data Analyst
Location: New York, NY
Contract
Job Summary:The Data Analyst will provide business intelligence support through repeatable and ad hoc reporting, delivering insights via charts, graphs, tables, and other visual representations. This role is essential in enabling informed business decisions by analyzing performance data, identifying trends, and supporting various business areas.
Responsibilities:- Analyze performance of process activities, identify problem areas, and present findings in concise charts, graphs, tables, or summaries.
- Establish standardized methods for recording, tracking, and reporting on activities.
- Design, implement, automate, and maintain large-scale enterprise data ETL processes.
- Modify existing databases and database management systems or direct programmers and analysts to make necessary changes.
- Translate business requirements into SQL queries and Python scripts for ad hoc analysis and custom reporting solutions.
- Explore data to identify performance opportunities, trends, and anomalies, contributing to new client data solutions through custom analytics.
- Coordinate reporting automation with internal product and engineering teams.
- Architect data pipelines to connect different data sources.
- Transform and cleanse outputs into meaningful analysis for business and sales teams.
- Tune and optimize the current code base and reporting solutions.
- Oversee documentation processes.
Qualifications:- Bachelor's degree in computer science, engineering, or a related technical field.
- 5-7 years of experience in engineering/analytics.
- Strong SQL skills with 5+ years of experience.
- Experience with Snowflake or similar platforms.
- Proficiency in Python.
- Experience in Big Data and data/technology methodologies.
- Experience with AWS tools such as IAM, Lambda, EC2, and S3.
- Knowledge of business intelligence (BI) tools (Domo preferred).
- Stakeholder engagement experience.
- Experience with automation.
- Familiarity with Jira, Confluence, GitHub, and other agile development tools.
- Knowledge of data privacy.
- Bonus qualifications include familiarity with media and TV measurement, Athena, Qubole, Salesforce, and vendor management experience.