Senior Software Engineer (SQL + Snowflake + Data Modeling + Cloud Data Platforms)

Acquia empowers the world’s most ambitious brands to create digital customer experiences that matter. With open source Drupal at its core, the Acquia Digital Experience Platform (DXP) enables marketers, developers, and IT operations teams at thousands of global organizations to rapidly compose and deploy digital products and services that engage customers, enhance conversions, and help businesses stand out.

Headquartered in the U.S., Acquia is positioned as a market leader by the analyst community and is listed as one of the world’s top software companies by The Software Report. We are Acquia. We are a global company with employees located in more than 30 countries, and we’re building for the future. We want you to be a part of it!

We are seeking an experienced Senior Software Engineer specializing in Data Engineering to join our team and build robust, scalable data infrastructure using modern tools like Snowflake and Dagster to power our marketing cloud platform and AI-driven analytics.

As a Senior Software Engineer, you will:

• Design and build scalable data pipelines using Dagster for orchestration and Snowflake for data warehousing

• Develop and optimize complex data models and transformations to support real-time analytics and AI/ML initiatives

• Build metadata-driven, reusable data solutions that enable self-service analytics across the organization

• Implement AI-powered data quality monitoring, anomaly detection, and automated data validation frameworks

• Partner with Data Scientists and ML Engineers to enable efficient model training and inference workflows

• Optimize query performance and cost efficiency across multi-petabyte data workloads in Snowflake

• Build robust data governance frameworks including lineage tracking, data cataloging, and access controls

• Implement event-driven data architectures supporting real-time customer experience optimization

• Collaborate with Product and Engineering teams to instrument applications for comprehensive data collection

• Mentor junior engineers on data engineering best practices and modern data stack technologies

Skills:

• 5+ years of experience in data engineering roles with focus on large-scale data processing

• Expert-level proficiency in Python for data pipeline development and automation

• Strong SQL skills with experience in query optimization and performance tuning

• Strong hands-on experience with Snowflake including performance optimization, security, and cost management (must-have)

• Proven experience with Dagster or similar workflow orchestration tools (Airflow, Prefect)

• Deep understanding of data modeling, ETL/ELT patterns, and dimensional modeling techniques

• Experience with streaming data technologies (Kafka, Kinesis, Pub/Sub) and real-time processing

• Experience with cloud data platforms (AWS, GCP, Azure) and their native data services

• Knowledge of data governance tools and practices (data cataloging, lineage, quality monitoring)

• Familiarity with version control (Git) and CI/CD practices for data pipelines

• Interest in AI/ML applications including feature engineering, model serving, and MLOps workflows

Additional Advantages:

• Experience with dbt for analytics engineering and data transformation

• Hands-on experience with vector databases and embedding pipelines for AI applications

• Knowledge of data mesh architecture and domain-driven data design

• Experience with Apache Spark for large-scale data processing

• Snowflake certifications (Data Engineer, Architect)

• Experience with customer data platforms (CDPs) and marketing analytics

• Understanding of privacy regulations (GDPR, CCPA) and data anonymization techniques

We are an organization that embraces innovation and the potential of AI to enhance our processes and improve our work. We are always looking for individuals who are open to learning new technologies and collaborating with AI tools to achieve our goals.

Acquia is proud to provide best-in-class benefits to help our employees and their families maintain a healthy body and mind. Core Benefits include: competitive healthcare coverage, wellness programs, take it when you need it time off, parental leave, recognition programs, and much more!

Individuals seeking employment at Acquia are considered without regard to race, color, religion, caste, creed, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. Whatever you answer will not be considered in the hiring process or thereafter.