Data Architect
Indianapolis
ActiveCampaign
ActiveCampaign's category-defining Customer Experience Automation platform helps over 180,000 businesses build meaningful connections with their customers.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.
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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Airflow APIs Architecture Data analysis Data management Data pipelines E-commerce Elasticsearch ETL Kafka MySQL Pipelines RDBMS Salesforce Security Snowflake SQL Streaming
Perks/benefits: Health care Home office stipend Paid sabbatical Salary bonus Startup environment Wellness
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Principal Data Engineer jobs
- Open Data Manager jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Sr Data Engineer jobs
- Open Business Data Analyst jobs
- Open Junior Data Scientist jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Junior Data Engineer jobs
- Open Research Scientist jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs