Job Overview
Job TitleData Architect
Job TypeFull Time
Offered Salary$150,000
LocationHybrid
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.

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
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
01What does a Data Architect at Pipefy do?
02What are the key technical skills required for this Data Architect role at Pipefy?
03Is this a remote role at Pipefy?
04What kind of AI tooling will the Data Architect build at Pipefy?
05How does Pipefy support its remote employees in this Data Architect role?
06What is the expected seniority level for the Data Architect position at Pipefy?
07How does Pipefy ensure data quality and governance?
Explore similar opportunities that match your background