GTM Analytics Engineer

Affinity Inc; Barcelona; Presencial; EUR 75.000 - 110.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health insurance

Education budget

L&D program

Wellness budget

Descripción de la vacante

Affinity Inc. is seeking a GTM Analytics Engineer to design, implement, and maintain scalable data infrastructure enabling analytics and reporting for GTM metrics across Finance, Marketing, Sales, and CS.

The role reports to the Director of Revenue Operations and embraces a hub-hybrid model with in-office collaboration. You will manage dbt models, CI/CD pipelines, and AI-assisted tooling to accelerate analytics while enforcing data quality, governance, and security.

Formación

• Proficiency with data pipeline development and SQL.
• Experience with cloud data warehousing (Snowflake, BigQuery, Redshift).
• Hands-on Salesforce data management and SOQL troubleshooting.
• dbt in version-controlled CI/CD workflows.
• Experience integrating data warehouses with AI/LLM tooling.
• Strong communication and cross-functional collaboration.

Responsabilidades

• Design, implement, and maintain GTM data infrastructure and pipelines.
• Develop and test dbt models, enforce CI/CD testing.
• Create reusable semantic layers and standardized metrics.
• Govern data quality controls and monitor pipeline performance.
• Collaborate with analysts, data scientists, and stakeholders.
• Architect AI-ready data models for safe LLM querying.

Conocimientos

Data pipeline development

SQL

Cloud data warehousing

Salesforce data integration

dbt experience

AI tools familiarity

SOQL

Communication & collaboration

Herramientas

dbt

GitHub

Salesforce APIs

Claude

MCP

CI/CD

Descripción del empleo

The Role

The GTM Analytics Engineer designs, implements, and maintains scalable data infrastructure to enable analytics and reporting. Responsibilities center on the development, management, and governance of GTM (Finance, Marketing, Sales, CS) BDM Data architecture, GTM pipeline integration, data quality assurance, and the secure operation of BI tools across the GTM organization. This role reports to the Director of Revenue Operations.

What You’ll Be Doing

GTM Data Infrastructure & Pipeline Development

• Manage all data models in dbt using version control (Git/GitHub), with pull-request review, automated testing, and CI/CD deployment pipelines.
• Write and maintain dbt tests (schema, data, and unit tests) and enforce them in CI to catch regressions before they reach production.
• Use AI-assisted development tools (e.g., Cursor, Claude) to accelerate modeling, refactoring, code review, and documentation.
• Establish and enforce data modeling standards, including naming conventions and calculation methodologies
• Design and optimize Business Dimensional Model (BDM) tables aligned with business requirements in dbt.
• Develop, automate, and maintain GTM data pipelines, ensuring delivery for business analytics
• Build and maintain reusable semantic layers with standardized metric definitions and business logic and YML files.
• Perform user acceptance testing and continuously refine pipelines for performance and scalability

Data Governance and Pipeline Performance

• Establish data quality controls (audits, logging, root cause analysis, automated cleansing) to ensure accuracy, reliability, and compliance throughout all data flows.
• Implement monitoring and alerting for data pipeline performance (timing, error rates, duplication), maintaining SLAs, and proactive issue resolution.
• Govern access and controls for sensitive customer, marketing, and product data, ensuring compliance with privacy regulations and security standards.

Collaboration & Documentation

• Partner with analysts, data scientists, and stakeholders to deliver curated datasets, communicate data limitations, and support ad hoc data requests.
• Maintain comprehensive documentation, including lineage tables, schema definitions, performance logs, and operational procedures for BDM and GTM solutions.

AI Solutioning and Management

• Design and maintain AI-ready data models and semantic definitions that let LLMs query GTM data accurately and safely.
• Integrate warehouse data into AI tools (e.g., Claude via MCP) to enable natural-language analytics, reducing reliance on static dashboards.
• Build and maintain reusable AI skills, prompts, and agents that automate recurring analytics and data-ops tasks.
• Partner with stakeholders to identify workflows where AI can replace manual reporting, and prototype/ship those solutions.
• Establish guardrails, evaluation, and governance for AI-driven data access (scope, accuracy, sensitive-data handling).

Qualifications

Don't meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every qualification. At Affinity, we are dedicated to building a diverse, inclusive, and authentic workplace, so if you're excited about this role but your past experience doesn't perfectly align with the qualifications above, we encourage you to apply anyway. You may be just the right candidate for this or other roles.

Required

• Proficiency with data pipeline development, SQL, and cloud data warehousing (Snowflake, BigQuery, Redshift, etc.), including ingesting and transforming Salesforce data via APIs or native connectors.
• Strong dbt experience — modeling, testing, and managing projects in a version-controlled, CI/CD workflow (Git/GitHub).
• Proficiency with AI-assisted development and analytics tools (e.g., Cursor, Claude/LLMs) and interest in AI-native data workflows.
• Familiarity with integrating data warehouses into AI/LLM tooling (e.g., MCP, semantic layers for AI consumption) — a strong plus.
• Experience designing and managing Business Data Models (BDM) for data warehouse environments, incorporating Salesforce objects (Accounts, Opportunities, Campaigns) for analytics and reporting.
• Hands‑on experience with Salesforce data management, including SOQL, schema understanding, and troubleshooting sync issues.
• Strong communication and collaboration skills, with the ability to partner with Sales, Marketing, and RevOps teams.

Location: Barcelona, Spain

For this role, we're embracing a hub-hybrid model, designed to balance flexibility with meaningful in-person collaboration. Team members in-office 2-days per week. We believe great things happen when people come together intentionally to connect, create, and build momentum as a team.

What you’ll enjoy at Affinity:

• We live our values: As owners, we take pride in everything we do. We embrace a growth mindset, engage in respectful candor, act as playmakers, and "taste the soup" by diving deep into experiences to create the best outcomes for our colleagues and clients.
• Health Benefits: Comprehensive health insurance for both you and your family.
• Learning & Development: We provide an annual education budget and a comprehensive L&D program.
• Wellness Support: We provide a monthly budget for wellness memberships/equipment to support your overall health and happiness.