Data Analyst

ADWEEK; New York (NY); On-site; USD 69,000 - 117,000; Part time

Job summary

ADWEEK is seeking a highly analytical, technically hands-on data professional for a part-time role in New York to support our data warehouse, pipelines, and reporting environment. You will model data in BigQuery, develop pipelines, ensure data quality, and create dashboards with Looker, Tableau, or Power BI to deliver actionable insights.

Ideal candidates have 3–5 years in data analytics or analytics engineering, with experience in media or publishing being a plus, and strong communication of

Qualifications

• 3–5 years of experience as a Data Analyst, Analytics Engineer, or Data Visualization Analyst.
• Experience building dashboards, developing data models, and supporting data warehouse environments.
• Media, digital advertising, or publishing experience is a plus.

Responsibilities

• Data Modeling & Warehouse Management: Build and optimize SQL-based models in BigQuery for performance and cost.
• Data Pipelines & Integrations: Develop pipelines across core systems for reliable ingestion, transformation, and orchestration of data.
• Data Quality & Governance: Implement validation controls to maintain accuracy and reliability.
• Dashboard & Reporting Development: Design dashboards and reports using Looker and BI tools.
• Data Visualization & Storytelling: Translate analytics into clear insights for technical and non-technical stakeholders.
• Project Execution: Collaborate with Data & Analytics to deliver prioritized projects on a part-time schedule.

Skills

Data modeling

SQL

BigQuery

Python

Looker

Tableau

Power BI

dbt

Dashboard development

Data visualization

Tools

Google BigQuery

Looker

Tableau

Power BI

dbt

Job description

About ADWEEK: ADWEEK is the leading source of news, insights, and analysis on marketing, advertising, and media industries. With over 40 years of experience, ADWEEK is committed to delivering valuable, high-quality content to professionals worldwide. Our mission is to empower brands and marketers with the knowledge they need to succeed in an ever-changing digital landscape.

ADWEEK is seeking a highly analytical, technically hands-on data professional with expertise in SQL-based data engineering, data modeling, and business intelligence. This part-time role will support the development and maintenance of the company's centralized data warehouse, data pipelines, and reporting environment.

The ideal candidate combines strong technical skills with data visualization expertise, translating complex datasets into reliable, intuitive dashboards and actionable business insights.

Primary Responsibilities

• Data Modeling & Warehouse Management: Build, maintain, and optimize SQL-based data models in Google BigQuery, with a focus on query performance and cost efficiency.
• Data Pipelines & Integrations: Develop and maintain data pipelines across core business systems, ensuring reliable ingestion, transformation, and orchestration of data.
• Data Quality & Governance: Implement validation controls and monitoring to maintain data accuracy, consistency, and reliability.
• Dashboard & Reporting Development: Design, develop, and maintain interactive dashboards and reports using Looker and other BI tools (e.g., Tableau, Power BI).
• Data Visualization & Storytelling: Translate complex analytical findings into clear, actionable insights for technical and non-technical stakeholders.
• Project Execution: Collaborate with the Data & Analytics team and business stakeholders to deliver prioritized projects within an agreed-upon part-time schedule.

Required Skills & Qualifications

Experience

• 3–5 years of experience as a Data Analyst, Analytics Engineer, or Data Visualization Analyst.
• Experience building dashboards, developing data models, and supporting data warehouse environments.
• Media, digital advertising, or publishing experience is a plus.

Technical Skills

• Advanced SQL proficiency for data manipulation, transformation, and analysis.
• Hands-on experience with Google BigQuery or similar cloud data warehouse platforms.
• Working proficiency in Python for data manipulation, automation, and analysis.
• Experience with dbt or similar data transformation tools is a plus.
• Strong Looker experience; familiarity with Tableau or Power BI is a plus.
• Understanding of ETL/ELT processes, data pipelines, and data orchestration.

Additional Qualifications

• Strong analytical, problem-solving, and data visualization skills.
• Ability to communicate complex findings clearly to technical and non-technical audiences.
• Self-directed, organized, and comfortable managing priorities independently in a collaborative, fast-paced environment.

Employment Structure

• Part-time position with mutually agreed-upon weekly hours and schedule.
• Flexible scheduling aligned with team priorities and project deliverables.
• Focus on prioritized warehouse, data engineering, analytics, and reporting initiatives.

Equal Opportunity Employer

ADWEEK is an equal opportunity employer. We consider all qualified applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital or familial status, veteran or military status, citizenship status, or any other characteristic protected by federal, state, or local law.

Reasonable Accommodations

ADWEEK provides reasonable accommodations to qualified individuals with disabilities, in accordance with the Americans with Disabilities Act and applicable state and local laws, during the application process and in the performance of essential job functions. If you need an accommodation, please contact HR.