At Constant Contact, we are seriously awesome people who take ownership and make an impact by operating with the mindset, integrity and courage of a small business owner. There’s something so profoundly rewarding about knowing that your work is empowering people everywhere to pursue their dreams.  Here, we all play an integral part in helping business owners, entrepreneurs, non-profits and individuals to succeed by giving them all the help and tools they need to grow online. We’re energized by new challenges and new possibilities-and we’re just getting started!

What you'll do:

• The Principal Snowflake Data Engineer will be responsible for architecting large-scale data intelligence solutions, performing architectural assessments, crafting architectural options and analysis around Snowflake Data Warehouse
• Finalize preferred solution alternative working with IT and Business stakeholders to build data ingestion pipeline using tools like Talend, Informatica, etc
• Need to have professional knowledge of AWS
• Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SnowSQL Writing SQL queries against Snowflake
• Understanding data transformation and translation requirements and which tools to leverage to get the job done
• Understanding data pipelines and modern ways of automating data pipeline using cloud-based tools
• Hands on experience with building productionized data ingestion and processing pipelines using Java, Spark, Scala, Python
• Snowflake SQL Writing SQL queries against Snowflake Developing scripts Java, Python, Scala, etc
• In-depth understanding of Data Warehouse/ODS, ETL concept and modeling structure principles

Who you are:

• 6+ years of experience working with data in the following ways: SQL development, Shell Scripting, Python, Snowflake, AWS, software engineering or database development
• Experience developing end-to-end data pipelines to transform and process data for reporting layer
• Experience with large-scale data sets using both structured and unstructured data
• Proficient in Unix/Linux environment
• Full grasp of continuous integration and delivery, including branching strategies, automated deployment and functional automation within CI and CD Pipelines.
• Strong communication skills across both business and technical communities
• Self-directed and able to proactively lead complex projects unsupervised
• Experience working in Agile/Scrum methodologies
• Bachelor or Master’s degree in Computer Science, Information Technology or Equivalent
• Performing in an agile, self-directed team environment
• Experience with billing data and systems is a big plus

Why You’ll Love Us:

• We celebrate one another’s differences. We are proud of our culture of diversity and inclusion, and we're always working hard to strengthen and improve this culture. We have programs in place that bring us together on important issues and provide educational opportunities for all employees. 
• Join the experts. If you're passionate about supporting businesses and organizations, you won’t find a better spot to share your talent. We’re dedicated to improving the quality of our product from a customer standpoint and have a true desire to enable the success of businesses, non-profit organizations, and community groups.
• You’ll have opportunities to grow your career. We encourage and support our team members to learn different aspects of the business, take on stretch assignments, seek coaching opportunities and professional development opportunities.
• A generous paid time off policy and a competitive benefits package that supports the health and well-being of you and your family

At Constant Contact, we’re all about work flexibility and are proud to serve our customers as a hybrid workforce. Our hybrid work model combines the convenience of remote work with access to our great office locations to collaborate in-person, participate in live trainings, and socialize with colleagues. To promote the safety of our employees, their families and our community, where permitted by applicable law, we require all new hires to be fully vaccinated against COVID-19 prior to their first day of work.

Constant Contact is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, sex, gender, gender identity, national origin, citizenship, age, disability, sexual orientation, genetic information, veteran status or any other status protected under applicable law. If you require accessibility assistance applying for open positions, please contact talentacquisition@constantcontact.com.

Notice to Recruiters and Staffing Agencies:

Constant Contact has an internal talent acquisition department and designated career site for individuals looking to join our team. Constant Contact will not accept unsolicited resumes from any external recruiters, staffing firms, search agencies or any fee-based referrals. Any unsolicited resumes sent to directly to Constant Contact, in any capacity will be considered property of Constant Contact. Constant Contact will not pay a fee for any placement resulting from the receipt of an unsolicited resume.