Analytics Engineer
Role details
Job location
Tech stack
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
- 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.
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 & documentationRequirements
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