Lead Data Engineer

As Acclinate's Lead Data Engineer, you will design, build, and operate the data infrastructure that powers the company's analytics, CRM, marketing, and machine learning initiatives. This is a hands-on role: you will be equally responsible for long-term architectural strategy and for the day-to-day engineering, pipeline maintenance, and reporting work that keeps Acclinate's data ecosystem running. You'll work across our event-driven architecture, CRM data platform, BI tooling, and production ML systems, partnering closely with the data lead, engineering, marketing, community, and customer success teams.

Key Responsibilities

• Design Event-Driven Data Models and Tables: Architect logical and physical data models, creating necessary data tables and schemas to effectively capture, store, and make accessible vast amounts of data generated by event streams. This includes defining how events are transformed into structured data suitable for analysis.
• Orchestrate Data Integration for Advanced Analytics: Design integration strategies to combine data from event-driven systems with existing data sources, ensuring a unified and consistent view for sophisticated analyses, including data warehousing and data mart design.
• Co-develop Acclinate's Data Strategy: Collaborate with appropriate unit leads and team members to define Acclinate's long-term vision for data, aligning it with business objectives, and creating a roadmap for implementation across both traditional and event-driven data.
• Contribute to Data Governance Frameworks: Collaborate with appropriate unit leads and team members to define data ownership, stewardship, quality standards, metadata management, and data lineage tracking for all data, including event data.
• Ensure Data Security and Compliance: Partner with engineering and legal teams to implement data security controls, access controls, and ensure adherence to relevant data privacy regulations (including PII and sensitive health information) for all data types.
• Optimize Data Storage and Performance: Recommend and implement appropriate data storage technologies and indexing strategies to ensure efficient data retrieval and analytical query performance, especially for high-volume event data.
• Evaluate and Recommend New Technologies: Stay abreast of industry trends and propose new data technologies and tools that can benefit Acclinate's data platform.

Hands-On Data Operations & Execution:

• Oversee Data Integration and ETL/ELT Processes: Build and maintain efficient, reliable data pipelines (e.g., in n8n or equivalent tooling) that transform event streams and other source data into a unified data environment such as a data warehouse or data lake, primarily on GCP/BigQuery.
• Own CRM Data (HubSpot): Manage HubSpot property and schema design, maintain the HubSpot-to-BigQuery integration (Operations Hub Enterprise), and perform ongoing data cleanup and reconciliation.
• Build and Maintain BI/Analytics Enablement: Build and maintain Metabase dashboards and a shared metrics library; produce recurring monthly and quarterly reports for Customer Success, Community, Marketing, and project reporting needs.
• Support Production Machine Learning (PPI Model): Own the ongoing data needs of a live production ML model, including feature engineering, data preparation and imputation, and managing model data in VertexAI; coordinate deployment-related data inputs with the product and engineering teams.
• Manage Marketing, Social, and Survey Data Pipelines: Build and maintain daily ingestion pipelines from Meta, Instagram, YouTube, Google Analytics, and Typeform into BigQuery.
• Manage External Data Partnerships: Own tokenized- and identified-data workflows and vendor relationships to support secure, compliant data sharing.
• Build AI Tooling: Develop and maintain Claude data skills for non-technical teams, including appropriate validation and guardrails.
• Maintain Data Documentation and Handover Materials: Create and maintain data dictionaries, runbooks, and onboarding materials to support knowledge transfer and business continuity.
• Apply Engineering Best Practices: Manage all pipeline and transformation code in version control (git), participate in code review, and maintain automated tests and data quality checks on business-critical pipelines.
• Own Data Quality and Reliability: Define and monitor freshness, completeness, and accuracy checks on critical tables; triage pipeline failures and data incidents, and communicate impact and resolution to affected teams.
• Manage Platform Cost: Monitor and optimize BigQuery and GCP spend, including query cost, storage tiering, and scheduled job efficiency.
• Support Compliance Operations: Maintain least-privilege access controls and periodic access reviews on data assets, apply Acclinate’s de-identification standard to externally shared datasets, and produce evidence artifacts (access logs, data lineage, data flow documentation) for audits and client security reviews.

Qualifications

• 6+ years building and operating production data pipelines, including at least 2 years owning a data platform end to end.
• Demonstrated ownership of a cloud data warehouse in production. BigQuery preferred; Snowflake, Redshift, or Databricks considered.
• Experience handling regulated health data (HIPAA/PHI) or comparable regulated data.
• Bachelor’s degree in a technical field, or equivalent practical experience.

Required Tools and Technical Skills

• SQL and BigQuery (primary data platform); Google Cloud Platform (IAM, storage, jobs)
• Python for data preparation, imputation, and analysis notebooks
• Pipeline and automation tooling (e.g., n8n or equivalent) and scheduled job management
• HubSpot CRM data model and its BigQuery integration (Operations Hub Enterprise)
• BI tooling, particularly Metabase
• ML/MLOps exposure: VertexAI and feature pipelines (supporting production models, not research-grade model development)
• Health-data privacy and compliance awareness (HIPAA/PHI)
• Practical AI tooling experience, including building and validating LLM-based "skills"/agents

Nice to Haves

• HubSpot Ops Hub data model and its BigQuery sync; VertexAI and production ML feature pipelines; building and validating LLM-based agents or “skills”. Strong candidates on the required list will be considered without these. 

Employee Benefits

We offer a comprehensive compensation and benefits package designed to attract and retain top talent. Here's what you can expect:

• Competitive salary commensurate with your experience and qualifications.
• Access to health, dental, and vision insurance plans, with the company covering half of the premium costs.
• Access to 401(k)-retirement plan to help you secure your financial future.
• Enjoy 22 paid holidays throughout the year.
• Receive an educational stipend to support your ongoing professional development.
• A technology allowance to keep you equipped with the tools you need.
• Generous paid time off to recharge and maintain work-life balance.