Madison-Davis - New York, NY

posted 2 months ago

Full-time
New York, NY
Personal and Laundry Services

About the position

The Data Analyst role is primarily focused on providing business intelligence support across various areas by delivering both repeatable and ad hoc reporting solutions. This includes the creation of reports in the form of charts, graphs, and tables that facilitate informed business decisions. The Data Analyst will be responsible for translating business requirements into SQL queries and Python scripts, enabling ad hoc analysis and custom reporting solutions tailored to the needs of the organization. In addition to reporting, the Data Analyst will explore data to identify client ad performance opportunities, trends, and anomalies. This exploration will contribute to the development of new Client Data Solutions through custom analytics. The role also involves coordinating reporting automation with other internal Product and Engineering teams to streamline processes and enhance efficiency. A key responsibility of the Data Analyst is to architect data pipelines that connect various data sources, ensuring seamless data flow and accessibility. The analyst will also develop and maintain Extract, Transform & Load (ETL) processes, transforming and cleansing outputs into meaningful analyses for business and sales teams. Furthermore, the Data Analyst will be tasked with tuning and optimizing the current code base and reporting solutions to improve performance and reliability.

Responsibilities

  • Provide business intelligence support through repeatable and ad hoc reporting delivery.
  • Translate business requirements into SQL queries and Python scripts for ad hoc analysis.
  • Explore data to identify client ad performance opportunities, trends, and anomalies.
  • Contribute 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.
  • Develop and maintain Extract, Transform & Load (ETL) processes.
  • Transform and cleanse outputs into meaningful analysis for business/sales teams.
  • Tune and optimize current code base and reporting solutions.

Requirements

  • Degree in computer science, engineering, or a quantitative discipline (Computer Science, Economics, Statistics, Engineering, Physics, Mathematics).
  • Strong SQL skills with 5+ years of experience using SQL.
  • Experience with Snowflake or a similar platform.
  • Proficiency in Python programming.
  • Experience with Business Intelligence tools, preferably Domo.
  • Exposure to automation processes.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service