8 days ago

Data Architect

Pipefy

Hybrid
Full Time
$150,000
Hybrid
Apply

Job Overview

Job TitleData Architect
Job TypeFull Time
Offered Salary$150,000
LocationHybrid
Map of Hybrid

Who's the hiring manager?

Sign up to PitchMeAI to discover the hiring manager's details for this job. We will also write them an intro email for you.

Uncover Hiring Manager

Job Description

Data Architect

About the roleWe’re looking for a Data Architect to own and scale our data platform end-to-end. This role sits at the intersection of data architecture, analytics engineering, and AI, defining the foundations that power decision-making across the company.You’ll design robust, scalable data models, govern our semantic layer, and build AI-powered tooling that accelerates our data teams without compromising quality.

What you’ll do

  • Own the end-to-end data architecture (ingestion → transformation → consumption) on GCP
  • Design and maintain canonical data models (Kimball, star/snowflake, SCDs)
  • Define and govern the semantic layer (metrics, dimensions, consistency across BI & AI)
  • Establish dbt standards and best practices across the organization
  • Ensure data quality, lineage, testing, and CI/CD pipelines
  • Optimize performance and costs in BigQuery
  • Build AI tooling to automate analytics workflows (LLMs, prompt pipelines, evaluation frameworks)
  • Enable scalable self-service analytics through well-modeled data and BI tools
  • Act as a technical leader, mentoring senior engineers and influencing architecture decisions

What we’re looking for

  • 10+ years in Data / Analytics Engineering
  • Strong experience owning data architecture at scale
  • Deep expertise in data modeling (Kimball, dimensional modeling)
  • Advanced SQL + dbt (non-negotiable)
  • Hands-on experience with GCP / BigQuery
  • Experience with semantic layers (e.g., Cube.dev, dbt Metrics)
  • Strong skills in Python and AI/LLM-based tooling
  • Solid understanding of data quality, governance, and CI/CD
  • Ability to connect technical decisions to business impact

Nice to have

  • Experience with BI tools (Looker, Tableau, Power BI)
  • Background in building internal data/AI platforms

Why join us

  • Remote-first, global team
  • High-impact role shaping the company’s data foundation
  • Work at the intersection of data + AI + business
  • Strong culture of ownership and technical excellence

Benefits:

  • Health and Dental Plan
  • Individual Life Insurance
  • Flexible Hours (in compliance with daily work hours)
  • Flexible Meal/Food Allowance
  • Home Office Support
  • Furniture Assistance
  • Psychological Support (for you or legal dependents)
  • Wellhub
  • Extended Maternity and Paternity Leave
  • School/Nanny Allowance
  • Supplemental Nutrition Assistance
  • Veterinary Plan
  • Birthday Day Off
  • Marriage Leave (7 days)
  • Bereavement Leave for Loved Ones (10 days)
  • Bereavement Leave for Adoption or Pet Loss (2 days)
  • Individual Funeral Assistance
  • Monthly Education Support
  • Payroll Loan
  • Financial Consulting
  • Udemy Corporate Access
  • Coworking Space
  • Pipefy License for up to 10 Users

Key skills/competency

  • Data Architecture
  • Analytics Engineering
  • AI/LLM Tooling
  • Data Modeling
  • SQL
  • dbt
  • GCP
  • BigQuery
  • Data Governance
  • Technical Leadership

Tags:

Data Architect
Data Engineering
Analytics Engineering
GCP
BigQuery
SQL
dbt
AI
LLM
Data Modeling
Semantic Layer
Remote

Share Job:

How to Get Hired at Pipefy

  • Research Pipefy's data vision: Understand their remote-first culture and focus on data + AI.
  • Tailor your resume: Highlight 10+ years of data architecture and GCP/BigQuery experience.
  • Showcase dbt and SQL expertise: Emphasize advanced SQL and dbt proficiency.
  • Prepare for technical interviews: Be ready to discuss data modeling, semantic layers, and AI tooling.
  • Connect technical to business impact: Articulate how your data solutions drive business value.

Frequently Asked Questions

Find answers to common questions about this job opportunity

Explore similar opportunities that match your background