Analytics Engineer

Affinity
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Tech stack

API
Data analysis
Business Logic
Google BigQuery
Data Architecture
Data Governance
Data Infrastructure
Data Warehousing
Query Optimization
Power BI
Salesforce
SQL Databases
Data Streaming
Tableau
Data Logging
Snowflake
Salesforce Object Query Language (SOQL)
Data Management
Looker Analytics
Data Pipelines
Redshift

Job description

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,\u00a0 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

o Establish data quality controls (audits, logging, root cause analysis, automated cleansing) to ensure accuracy, reliability, and compliance throughout all data flows. o Implement monitoring and alerting for data pipeline performance (timing, error rates, duplication), maintaining SLAs, and proactive issue resolution. o 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 \u2013 Time Allocation

@ 45% - Pipelines & modeling @ 20% - Governance & security @ 15% - BI tools & permissions @ 15% - Collaboration & documentation

Requirements

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.\u00a0
What you'll enjoy at Affinity

About the company

= 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. About Affinity

With more than 3,000 customers worldwide and backed by some of Silicon Valley's best firms, Affinity has raised $120M to empower dealmakers to find, manage, and close more deals. How? Our Relationship Intelligence platform uses the wealth of data exhaust from trillions of interactions between Investment Bankers, Venture Capitalists, Consultants, and other strategic dealmakers to deliver automated relationship insights that drive over 450,000 deals every month.\u00a0We are are proud to have received Inc. and Fortune Best Workplaces awards as well as to be Great Places to Work certified for the last 5 years running. Join us on our mission to make it possible for anyone to cultivate and fully harness their network to succeed.

We use E-Verify

Our company uses E-Verify to confirm the employment eligibility of all newly hired employees. To learn more about E-Verify, including your rights and responsibilities, please visit

", "employmentType": "FULL_TIME"

Apply for this position