Data Software Engineer

About ActiveCampaign: ActiveCampaign is the autonomous marketing platform that gives growing businesses the intelligence to market like a much larger team. Powered by Active Intelligence, ActiveCampaign turns each business’ own data into campaigns, automations, and customer experiences that get smarter over time. Learn more at activecampaign.com.   As a global multicultural company, we are proud of our inclusive culture which embraces diverse voices, backgrounds, and perspectives. We don’t just celebrate our differences, we believe our diversity is what empowers our innovation and success. You can find out more about our DEI initiatives here.    Perks and Benefits: At ActiveCampaign, we prioritize employees’ well-being and professional growth by cultivating a culture centered on collaboration and innovation. When you join our team, you’ll not only have the opportunity to make a significant impact, but also enjoy a range of benefits tailored to support your personal and career development.    Here are some of the benefits we offer: -Comprehensive Health & Wellness: Top-tier benefits package that includes medical and dental benefits paid 100% by ActiveCampaign for you and 50% for your dependents, and reimbursements on vision expenses. In addition, employees receive complimentary access to telehealth services, and a free subscription to Calm. -Growth & Development: Access to LinkedIn Learning, professional development programs, and career growth opportunities in a fast-growing organization. -Generous Paid Time Off: Recharge and take the time you need to maintain work-life balance. -Total Rewards: Pension scheme with matching up to 1.5% of your contribution, MultiSport Plus card to support your active lifestyle, home office stipend to cover your commuter or work from home expenses, and a four-week paid sabbatical with bonus after five years. -Collaborative Culture: Work alongside brilliant, passionate colleagues in an environment that values innovation, teamwork, and mutual support.   ActiveCampaign is an equal opportunity employer. We recruit, hire, pay, grow, and promote no matter of gender, race, ethnicity, sexual orientation, marital status, political opinion, national origin, social origin, parentage, workers union membership, economic status, religion, age,  health condition, disability or any other grounds protected by law.   Our Employee Resource Groups (ERGs) strive to foster a diverse inclusive environment by supporting each other, building a strong sense of belonging, and creating opportunities for mentorship and professional growth for their members.

What your day could consist of:

Architect and Build Pipelines by designing, developing, and maintaining high-throughput data pipelines that seamlessly transform data across our ecosystem

Execute Data Modeling and Schema Design, utilizing DDL and DML operations to optimize data structures for both performance and long-term scalability

Champion Engineering Excellence by implementing automated testing, CI/CD pipelines, and Infrastructure as Code (Terraform) to ensure system health and reliability.

Collaborate Cross-Functionally with Data Science and AI teams to engineer feature stores and automated MLOps pipelines, moving cutting-edge research into live production environments

Drive System Monitoring and health checks, ensuring our containerized and orchestrated environments (Kubernetes, Docker, Airflow) run at peak efficiency.

Act as a Technical Advisor to stakeholders, translating complex data architectures into clear, non-technical conversations that guide business decisions

Technical environment:

Databases: MySQL, Amazon Aurora, Amazon RDS, PostgreSQL

ata Storage and Analytics: AWS S3, Apache Iceberg, Snowflake, Apache Druid, Looker

Data Processing and Transformation: Apache Spark, DBT

Languages: Python (primary)

Infrastructure as Code: Terraform

Containerization and Orchestration: Kubernetes, Docker, Airflow

The Ideal Candidate Will Bring:

4+ years of professional software engineering experience, with a proven track record of building and maintaining production-grade data systems.

Deep Data Architecture expertise, with the ability to design modern data stack components and schemas that balance immediate performance with future growth.

Proficiency in Infrastructure as Code, specifically using Terraform to manage and deploy your own infrastructure.

A high level of software rigor, including a strong background in automated testing, CI/CD, and general software engineering best practices

Expert-level SQL skills (particularly MySQL), with a focus on optimizing complex queries for maximum performance.

Experience in a modern technical environment, ideally having worked with Python, AWS (S3, Aurora, RDS), Snowflake, Apache Spark, and DBT

Exceptional communication skills, with the talent to distill complex technical concepts into clear, actionable insights for both technical and non-technical peers