The Role
Own and build a production Snowflake analytics platform and ELT pipelines from GTM and product sources, implement dbt transformations and CI/CD, enable self-service BI in Power BI/Tableau, ensure data quality/security/compliance, and present insights to leadership.
Summary Generated by Built In
Senior Data Analytics Engineer
SummaryLocation:
- Flexible in the United States; remote-friendly with overlap to core business hours.
- Occasional travel for team onsites or leadership presentations may be required.
We are seeking a GTM Data Analytics Engineer to design, build, and scale our analytics platform from the ground up. You will own our Snowflake environment end-to-end, create robust data pipelines from core SaaS tools (Salesforce, Gong, Spiff, Clay, Common Room) and internal product usage data, and enable self-service analytics via Power BI or Tableau. This role partners closely with RevOps, Sales, CS, Product, and Finance, and includes regular communication and presentation to senior leadership.
What you’ll do
- Architect and stand up a Snowflake environment, including account setup, databases and schemas, virtual warehouse strategy, RBAC, security, data governance, cost controls, and monitoring.
- Design and implement reliable ELT pipelines from Salesforce, Gong, Spiff, Clay, Common Room, and internal product data sources using connectors, APIs, and Snowflake-native capabilities (Snowpipe, Streams, Tasks).
- Ingest and normalize semi-structured data (JSON/VARIANT), implement CDC, and build resilient orchestration with tools such as Airflow, Prefect, Dagster, or cloud-native schedulers.
- Model data for analytics using best practices (dimensional modeling/Kimball, data marts, medallion architecture) to create trusted, documented datasets for GTM, Product, and Finance use cases.
- Own dbt-based transformations, testing, and CI/CD, including version control, code reviews, and deployment workflows.
- Establish data quality, reliability, and lineage standards with automated tests, monitoring, alerting, and SLAs; create runbooks and documentation.
- Build and optimize BI assets in Power BI or Tableau, including semantic models, governed metrics, executive-ready dashboards, and query performance optimization against Snowflake.
- Partner with stakeholders to define and operationalize key metrics (pipeline, conversion, ARR, retention, product adoption), and regularly present findings and recommendations to leadership.
- Implement and maintain security and compliance controls (PII handling, data masking, role-based access, auditing, retention).
- Monitor and tune performance and cost (warehouse sizing, caching, micro-partitioning, clustering, materialized views); drive continuous improvement in reliability and efficiency.
- Evaluate and integrate new tools and vendors; contribute to data platform roadmap and best practices.
- 5+ years of data engineering experience, with 3+ years hands-on in Snowflake and a track record of building a Snowflake environment from scratch.
- Deep expertise with Snowflake features: virtual warehouses, RBAC, security policies, Time Travel, zero-copy cloning, Snowpipe, Streams, Tasks, materialized views, and performance tuning.
- Proven experience building pipelines from Salesforce, Gong, Spiff, Clay, and Common Room, plus internal product usage telemetry (e.g., events, logs). Comfortable with third-party connectors (e.g., Fivetran/Stitch), APIs/webhooks, and Python-based ingestion.
- Strong SQL and Python; experience with dbt for transformation and testing, Git-based workflows, and CI/CD.
- Advanced data modeling skills (dimensional modeling/Kimball), data warehousing concepts, and building semantic layers for BI.
- Extensive experience with Power BI or Tableau, including data modeling (e.g., DAX or Tableau calculations), dashboard design, and performance optimization with Snowflake as the backend.
- Excellent communication skills and comfort presenting to senior leadership; ability to translate technical details into business value and actionable insights.
- Experience in a major cloud (AWS, Azure, or GCP) including IAM/SSO, networking, secrets management, and logging/monitoring.
- Strong focus on data quality, documentation, and operational excellence.
- Experience with RevOps data, CRM schemas, Gong audio/transcript metadata, compensation/commission data (Spiff), lead enrichment (Clay), and community/product signals (Common Room).
- Familiarity with product analytics tools and event pipelines (Segment, Snowplow, Amplitude) and modeling product usage and adoption metrics.
- SnowPro Core/Advanced Architect certification or equivalent cloud certifications.
- Experience with metric layer tooling, data contracts, and governance frameworks.
- Stand up a secure, cost-aware Snowflake environment with production, staging, and development tiers, RBAC, and monitoring.
- Deliver initial ELT pipelines for Salesforce and at least one additional source (Gong, Spiff, Clay, or Common Room), plus an MVP product usage ingestion.
- Ship an executive-ready dashboard in Power BI or Tableau with a governed metric set and documented data lineage.
- Implement dbt transformations and data tests for core domains; establish CI/CD and operational runbooks.
- Flexible; remote-friendly with overlap to core business hours.
- Occasional travel for team onsites or leadership presentations may be required.
At BlueVoyant, we recognize that effective cyber security requires active prevention and defense across both your organization and supply chain. Our proprietary data, analytics and technology, coupled with deep expertise, works as a force multiplier to secure your full ecosystem.
Led by CEO, Jim Rosenthal, BlueVoyant’s highly skilled team includes former government cyber officials with extensive frontline experience in responding to advanced cyber threats on behalf of the National Security Agency, Federal Bureau of Investigation, Unit 8200, and GCHQ, together with private sector experts. BlueVoyant services utilize large real-time datasets with industry leading analytics and technologies.
Founded in 2017 by Fortune 500 executives, including Executive Chairman, Tom Glocer, and former Government cyber officials, BlueVoyant is headquartered in New York City and has offices in Maryland, Philippines, San Francisco, London, Budapest, and Latin America.
BlueVoyant provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, BlueVoyant complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.
BlueVoyant uses AI-assisted tools within our applicant tracking system to help identify candidates whose experience and skills best match the requirements of a role. This technology provides hiring teams with additional insights to support fair and efficient hiring decisions. Please note that all applications are reviewed by a member of our hiring team, and final hiring decisions are made by humans, not AI. By submitting your application, you acknowledge that AI tools may assist in the evaluation of your resume as part of the recruitment process. For more information on how we process your personal data, please review our Candidate Privacy Notice available at https://www.bluevoyant.com/candidate-privacy-notice.
All employees must be authorized to work in the United States. BlueVoyant provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, BlueVoyant complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.
Disclaimer: Please note that pursuant to contractual requirements and applicable law, in order for employees to perform work on some of the company’s federal contracts, U.S. citizenship is required. Accordingly, an employee’s ability to perform work on such contracts is contingent upon the company’s verification of the employee’s citizenship status. Furthermore, individuals may be subject to additional background checks and fingerprinting.
Top Skills
Airflow
Amplitude
APIs
AWS
Azure
Ci/Cd
Clay
Common Room
Dagster
Dax
Dbt
Fivetran
GCP
Git
Gong
Iam
Materialized Views
Power BI
Prefect
Python
Salesforce
Segment
Snowflake
Snowpipe
Snowplow
Spiff
SQL
Sso
Stitch
Streams
Tableau
Tasks
Time Travel
Webhooks
Zero-Copy Cloning
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
BlueVoyant is an analytics-driven cybersecurity company based in New York City, whose mission is to defend businesses around the world against agile and well-financed cyber attackers by providing unparalleled visibility, insight and responsiveness.
