Data Architect

About the role

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.