Data Architect

We are seeking an experienced Data Architect to guide the design, modeling, and implementation of our customer data platform. As a Data Architect, you can translate business requirements into data management and technology requirements, strategy, principles, and architectures. In this role you will play a pivotal role in implementing scalable and performant solutions that unify data across multiple teams and domains including large-scale event streaming, reporting, analytics and more. Create insights for our customers using terabytes of platform transactional and time series data, email and marketing content, user e-commerce trails, email enrichment tags, etc. We are looking for a candidate who can improve data performance in our existing systems as well as design and guide new systems and technology choices for our next chapter of growth.

What your day could consist of:

• Collaborating across teams to implement a unified data reporting infrastructure that meets multiple teams’ requirements.
• Designing a system that delivers real-time reporting and analytics to customers utilizing data from MySQL, Druid, Snowflake, S3, and more.
• Brainstorming with Customer Data Platform teams to guide data and architectural solutions.
• Creating and maintaining comprehensive and high-quality documentation for data infrastructure, pipelines, and processes.
• Creating data pipelines for ingesting, processing, and storing event streaming and time-series data.
• Implementing data science IT infrastructure (data stores, ETL tools, visualizations, runtime environments).
• Owning data loads between data lake, internal data structures, and internal/external API’s.

What is needed:

• 10+ years experience in data analysis, integration and delivery.
• 5+ years of proven experience as a Data Architect working with technologies such as MySQL databases in high transaction production environments.
• Proven experience in designing, modeling, documenting, and implementing scalable and performant data architectures in MySQL as well as technologies such as Druid, Snowflake, and/or ElasticSearch.
• Deep understanding of relational databases MySQL database architecture, optimization, troubleshooting as well as complex data sets with focus on resource utilization.
• Experience in designing and modeling database schemas, including normalization, denormalization, and indexing strategies.
• Experience with Apache Druid or other time series technologies to provide analytics for large-scale event streaming data.
• Expertise in unifying data from multiple data stores and technologies to provide real-time reports and analytics to customers.
• Ability to create high quality documentation and implementation timelines that facilitate multiple workstreams
• Streaming technology knowledge (Maxwell’s Daemon, Kafka, Snowpipe).
• Database administration skills (SQL, no-SQL, etc.) for scale, stability, security, multi-user load management and performance.
• Experience implementing ETL processes with Airflow.

About ActiveCampaign:ActiveCampaign helps small teams power big businesses with the must-have platform for intelligent marketing automation. Customers from over 170 countries depend on ActiveCampaign’s mix of pre-built automations and integrations (including Facebook, Google, WordPress, Salesforce, Shopify, and Square) to power personalized marketing, transactional emails, and one-to-one CRM interactions throughout the customer lifecycle. 
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. 
ActiveCampaign holds the highest customer satisfaction rating among Marketing Automation, E-Commerce Personalization, Landing Page Builders, and CRM solutions on G2.com and is one of only a handful of software solutions with over 10,000 positive reviews. ActiveCampaign has also been named the Top Rated Email Marketing Software on TrustRadius. Learn more and start your free trial at ActiveCampaign.com.
Perks and benefits:ActiveCampaign is an employee-first culture. We take care of our employees at work and outside of work. You can see more of the details here, but some of our most popular benefits include:
-Comprehensive health and wellness benefits that includes a High Deductible Health Plan (HDHP) fully covered by ActiveCampaign, complimentary access to telehealth and tele-mental health resources, and a complimentary membership to Calm-Open paid time off-Generous 401(k) matching program with immediate vesting-Quarterly Path Perks with options for commuter and lunch benefits (for those reporting to a Hub), or a remote home office stipend-After five years of service, you’ll be eligible for a four-week paid sabbatical leave and a sabbatical leave bonus
ActiveCampaign is an equal opportunity employer. We recruit, hire, pay, grow and promote no matter of gender, race, color, sexual orientation, religion, age, protected veteran status, physical and mental abilities, or any other identities 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.