At Constant Contact, we’re working to transform marketing for small businesses. The Product team at Constant Contact is a passionate, fast moving team that drives our product forward to continually help our 500,000 small business customers succeed in their own businesses. We have to stay one step ahead of our customers, the market and technology, so we can deliver new and improved features and to do so, we need to understand our customers, their needs and how they use our products.
As the Product Data Analyst intern, you’ll work with Senior Analysts, Product Managers, User Experience Researchers (UXR), DB/DW engineers and other analysts to dig into the product data in order to surface insights about customer and product usage. You’ll contribute to the future of our product by providing the Product Managers with the data that they need to understand what our customers are doing and how they do it.
This is not your typical internship. You must be a ‘digger’, be inquisitive and curious and ask questions. You’ll have mentorship, but you’ve got to be comfortable working with little direction. You’ll be experimenting with the product in order to understand our customer's experience and you’ll be digging into the raw data that’s behind the scenes to create reports and charts to identify trends in usage and how it relates to our customer’s success.
You must have experience with:
Databases / Data warehousing
Writing complex SQL
Strong Microsoft Excel skills
It would be great if you have the following (and if you don’t, you will!):
Experience with Big Data platforms such as Hadoop
Experience with other reporting/visualization tools such as Tableau
Experience with monitoring and tracking tools such as Splunk, NewRelic, Adobe/Google Analytics
Other skills you’ll need:
Ability to hit the ground running, ask questions and learn quickly
Very strong verbal and written communication skills
Comfort with working independently on tasks
Ability to multitask (where one of those tasks is always having fun!)