GTM Data Engineer

The 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.

GTM Data Infrastructure & Pipeline Development

• Design and optimize Business Dimensional Model (BDM) tables aligned with business requirements
• 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
• Establish and enforce data modeling standards, including naming conventions and calculation methodologies
• Develop and maintain source-to-target mapping documentation for all transformations and data flows
• Manage BDM change requests, including impact assessments and rollback strategies
• Assess and integrate new data sources into the BDM structure
• Perform user acceptance testing and continuously refine pipelines for performance and scalability

BI Tools & Permissions Management

• Administer business intelligence platforms (e.g., Looker, Tableau), ensuring continual uptime, data integrations, and the implementation of updates and new features.
• Manage user access and security rules, including role definitions and license provisioning within BI tools and data environments.
• Maintain and optimize BI tool data connections, semantic layer implementations (e.g., LookML), and underlying data source performance.
• Support Senior GTM Analysts in optimizing dashboard performance through data architecture improvements and query optimization.

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.

Data Engineer – Time Allocation

• 45% - Pipelines & modeling
• 20% - Governance & security
• 15% - BI tools & permissions
• 15% - Collaboration & documentation
•   5% - Learning & growth

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 anyways. You may be just the right candidate for this or other roles.

• 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.
• Experience designing and managing Business Data Models (BDM) for data warehouse environments, incorporating Salesforce objects (Accounts, Opportunities, Campaigns) for analytics and reporting.
• Familiarity with governance frameworks, data quality validation, monitoring, logging, troubleshooting, and BI tool administration (Tableau, Power BI, Looker, etc.).
• 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. 

• 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: We cover both you and your dependents' healthcare, dental, and optical insurance premiums and offer flexible personal & sick days to support your well-being.
• Retirement Planning: We offer a pension plan through SmartPension to help you plan for your future.
• Learning & Development: We provide an annual education budget and a comprehensive L&D program.
• Wellness Support: We reimburse monthly for things like home internet, meals, and wellness memberships/equipment to support your overall health and happiness.
• Team Connection: Virtual team-building activities and socials to keep our team connected, because building strong relationships is key to success.

Please note that the role compensation details below reflect the base salary only and do not include any equity or benefits. This represents the salary range that Affinity believes, in good faith, at the time of this posting, that it will pay for the posted job. 

A reasonable estimate of the current range is $117,000 to $147,000 CAD. Within the range, individual pay depends on various factors including geographical location and review of experience, knowledge, skills, abilities of the applicant. 

At Affinity, we may use artificial intelligence (AI) tools as part of our recruitment process to help screen and evaluate candidate applications. While AI assists our hiring team in managing applications efficiently, it never replaces decisions made by real people. We are committed to fair and transparent hiring practices, and our AI tools are regularly monitored to ensure they support—not replace—human judgment.