Data Architect

fingerpaint

United States

Remoto

USD 130.000 - 180.000

Tempo pieno

14 giorni+

Una candidatura completa in un minuto

Curriculum e lettera di presentazione personalizzati, pronti da inviare.

Supera i filtri ATS

Descrizione del lavoro

Fingerpaint, a health and wellness advertising agency, seeks a Data Architect to define data structures, naming, documentation, and delivery for omnichannel campaigns. You’ll partner with data engineers, brand teams, and leadership to guide delivery for large, complex ecosystems.

You’ll design and maintain data pipelines, govern data integrity, and craft scalable solutions including data warehouse management.

Competenze

  • Defines and documents data models and view architecture.
  • 7+ years in data engineering/architecture with hands-on Snowflake in last 3+ years.
  • Proficient in SQL, Python, and ETL concepts.
  • Experience integrating AI with data platforms (e.g., Snowflake Cortex).
  • Able to explain technical decisions to leadership and non-technical partners.
  • Experience developing APIs for data integration.
  • Infrastructure as Code (Terraform).
  • Cloud experience, ideally AWS.
  • Knowledge of data integrity and hygiene practices.
  • Experience with unstructured data ingestion.

Mansioni

  • Define and document data architecture solutions and naming conventions.
  • Advise leadership on data structure and architecture.
  • Design and maintain views and datasets for omnichannel campaigns.
  • Develop and maintain data pipelines to validate, cleanse, and optimize data.
  • Lead data warehouse management and optimization initiatives.
  • Establish data integrity processes for campaign data.

Conoscenze

Data modeling
Snowflake
SQL
Python
ETL
IaC
AWS
Data governance
API integration
Communication

Strumenti

Terraform
Airflow
Databricks

Descrizione del lavoro

Reset your expectations of a health and wellness agency. From our inception, Fingerpaint has been driven by an unstoppable collective spirit of possibility. It’s that curiosity that’s at the heart of everything we do. From our legendary people-first culture to the hundreds of Fingerpainters who define us, we’ve reimagined what it means to be a healthcare and wellness advertising agency. Here, creativity happens naturally—we attract top talent and collaborate.

As a Data Architect, you’ll define how our data is structured, named, documented, and delivered for omnichannel marketing campaigns. You’ll also serve as the data expert for project and brand teams, joining team meetings to guide delivery for clients with large, complex data ecosystems. You’ll partner with data engineers, brand teams, and leadership, and your decisions will shape how reliably and consistently campaign data performs.

What you’ll do
  • Define and document data architecture solutions, including structure, naming conventions, data models, and view architecture, so every team works from the same blueprint.
  • Advise leadership on data structure, nomenclature, and architecture, so decisions rest on clear technical guidance.
  • Design and maintain the views and datasets that power omnichannel campaigns, following established standards.
  • Develop and maintain sophisticated data pipelines to validate, cleanse, and optimize campaign data
  • Design and advance next-generation data solutions, including campaign data warehouse management and optimization
  • Establish data integrity processes that keep campaign data accurate and trustworthy.
  • Deliver custom dataset solutions for complicated requests, including advanced transformations and ad‑hoc or unstructured data ingestion.
  • Address ad‑hoc requests and resolve technical issues efficiently
  • Join project kickoffs and team meetings as needed to shape data approach early, flag risks, and keep delivery on track.
  • Support brand teams working with clients that have large, complex data ecosystems and campaigns, so they can plan and deliver with confidence.
  • Coach engineers on the team through delegation and feedback that helps them grow.
Required qualifications
  • Demonstrated experience defining and documenting data models and view architecture.
  • 7+ years in data engineering, software engineering, or data architecture, including the last 3+ years of hands‑on experience with Snowflake
  • Proficiency in SQL, Python, and ETL tools for building and supporting data pipelines, with solid understanding of ETL concepts and advanced data transformations.
  • Experience integrating AI with data platforms (e.g., Snowflake Cortex).
  • Ability to explain technical decisions clearly to leadership, brand teams, and other non‑technical partners.
  • Experience developing and leveraging APIs for data integration.
  • Expertise in Infrastructure as Code (IaC), preferably Terraform.
  • Cloud experience, ideally with AWS.
  • Experience defining data integrity processes and data hygiene practices.
  • Working knowledge of data security principles and how they apply to campaign data.
  • Experience working within large, complex data ecosystems, including ingesting ad‑hoc or unstructured data.
  • Comfortable working in cross‑functional project teams.
Preferred qualifications
  • Experience with data supporting omnichannel marketing or promotion
  • Experience working in centralized services across multiple clients and brands
  • Experience working at marketing agencies, pharmaceutical marketing is a plus.
  • Experience supporting client‑facing or brand teams on complex campaigns.
  • Experience coaching, delegating to, and giving feedback to other engineers; proven ability to mentor team members.
  • Proficiency in Atlassian products and services (Bitbucket/Jira/Confluence).
  • Experience with SFMC or Marketo datasets.

Don’t meet every single requirement? That’s okay! Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At Fingerpaint, we are dedicated to building a diverse, inclusive, and authentic workplace, so if you’re excited about this role but your experience doesn’t align perfectly, we encourage you to apply anyway. You may be just the right candidate for this or other roles! Our team of qualified recruiters can match you with the right opportunity. Fingerpaint Group provides equal employment [and affirmative action] opportunities to all applicants and employees. We are proud to recruit qualified applicants without regard to race, color, religion, gender, age, ethnic or national origin, protected veteran status, physical or mental disability, sexual orientation, gender identity, marital status, or citizenship status.

Ottieni la revisione del curriculum gratis e riservata.

o trascina qui il file.

Similar jobs

Offerte di lavoro simili che vale la pena confrontare

Data Architect
Data Architect

fingerpaint • Stati Uniti

Remoto
USD 140.000 - 190.000
Senior Director, Engagement Strategy & AI-Driven Growth
Senior Director, Engagement Strategy & AI-Driven Growth

Fingerpaint Marketing, Inc. • New Jersey

In loco
USD 140.000 - 210.000
Senior Director, Engagement Strategy
Senior Director, Engagement Strategy

Fingerpaint Marketing, Inc. • New Jersey

In loco
USD 140.000 - 210.000
Digital Marketing Specialist
Digital Marketing Specialist

fingerpaint • Stati Uniti

Remoto
USD 60.000 - 75.000
Digital Marketing Specialist
Digital Marketing Specialist

Fingerpaint Marketing, Inc. • Stati Uniti

Remoto
USD 55.000 - 75.000
Senior Manager, Data Governance & Stewardship
Senior Manager, Data Governance & Stewardship

Fingerpaint Marketing, Inc. • New Jersey

In loco
USD 120.000 - 180.000
Senior Digital Producer
Senior Digital Producer

Fingerpaint Marketing, Inc. • New Jersey

In loco
USD 90.000 - 120.000
Senior Digital Producer
Senior Digital Producer

Fingerpaint Marketing, Inc. • Cedar Knolls (NJ)

In loco
USD 100.000 - 140.000
Senior Director, Engagement Strategy
Senior Director, Engagement Strategy

Fingerpaint Group • Cedar Knolls (NJ)

In loco
USD 150.000 - 230.000
Senior Digital Producer: Omnichannel & MarTech Lead
Senior Digital Producer: Omnichannel & MarTech Lead

Fingerpaint Marketing, Inc. • New Jersey

Ibrido
USD 90.000 - 120.000