About the company
Constant Contact, an established leader in online marketing, helps small businesses, nonprofits, and individuals stay connected with their customers through email marketing, social media, event marketing, and more. Our mission is to empower small businesses and organizations to create and grow customer relationships and achieve their goals through powerful online marketing tools.
Responsibilities
- Design, build and optimize data models for analytical and operational use cases.
- Design, develop, and maintain scalable data pipelines and ELT processes to transform raw data into usable formats (as needed).
- Collaborate with data analysts, data scientists, data engineers and other stakeholders to understand data needs and deliver high-quality, reliable data solutions.
- Ensure data quality and integrity by implementing best practices for data validation, testing, and documentation.
- Develop and maintain data infrastructure and tooling to support analytics workflows.
- Monitor and troubleshoot data pipelines/models and reports to ensure smooth operation and timely data delivery.
- Implement and enforce data governance and security measures.
- Provide reliable and trustworthy models for the Organization to make critical decisions.
Requirements
- Bachelor's degree in Computer Science, Engineering, Mathematics, or a related field. A Master's degree is a plus.
- 1-3 years of experience as an Analytics Engineer, Data Engineer, or a similar role.
- Strong proficiency in SQL and experience with data modeling and schema design such as star and snowflake.
- Experience with ELT tools and data pipeline frameworks (e.g., Apache Airflow, dbt, Fivetran). DBT - Preferred.
- Proficiency in programming languages such as Python or R.
- Familiarity with cloud data warehousing solutions (e.g., Snowflake, BigQuery, Redshift). Experience with Snowflake is desirable.
- Knowledge of data visualization tools (e.g., Tableau, Looker, Power BI) is a plus.
- Strong problem-solving skills and attention to detail.
- Excellent communication and collaboration skills.
Conditions
- Competitive salary and benefits package.
- Opportunity for professional growth and development.
- Collaborative and inclusive work environment.
- Flexible work arrangements.
- Pay Transparency: $84,800 - $101,760 USD.