GTM Analytics Engineer

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

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 thi