Data Engineer

Data Engineering

Saratoga Springs, New York

Reset your expectations of a health and wellness agency. Independent by design and built on a foundation of empathy, Fingerpaint celebrates what you bring as both a professional and an individual. With talent across the United States and Europe launching more than 200 brands, we are committed to creating and executing meaningful experiences. In 2021, Fingerpaint was named to Ad Age’s Best Places to Work and was awarded Agency of the Year by Med Ad News. Here, creativity happens naturally—we attract top talent and give them a space to grow and collaborate.
Fingerpaint is looking for an inquisitive, analytical thinker to join our growing digital team in the Saratoga 
Springs, New York office. This person will utilize their analytical, statistical, and database skills to turn raw
data into actionable insights.

Core Responsibilities:
  • Identify, analyze, and interpret trends or patterns in complex data sets
  • Performing ad-hoc analysis and presenting results in a clear manner
  • Validate, cleanse, and optimize campaign data
  • Management of campaign data warehouses
  • Advance our reporting and data visualization efforts

What it Takes:
  • Undergraduate degree in Computer Science, Mathematics, Statistics, or equivalent combination
  • of training and experience required.
  • 3-5 years of experience in data analysis or data engineering in a digital marketing setting
  • Advanced query building skills in PostgreSQL, SQL Server, or similar
  • Practical business experience using SQL, Python, and ETL tools & techniques for data analysis
  • Versed in mainstream business intelligence tools (Tableau, Power BI, etc.) and/or data
  • visualization platforms (Datorama, Google Data Studio, etc.)
  • Working knowledge of statistics and common digital marketing principles and metrics
  • An analytical mind capable of creative problem-solving
  • Articulate, detail-oriented communication skills
  • Ability to stay current on new technology advancements and analytical trends
  • A sense of humor and collaborative approach

Bonus Points:

  • Agency or pharma experience
  • Experience with popular data warehouse platforms –Snowflake, RedShift, or equivalent
  • Experience managing data models and ERDs (e.g. Omnigraffle, Lucidchart)
  • Exposure to machine learning concepts
  • Experience managing and mentoring team members