Summer Internship, Analytics Engineer | Content Business
We are looking for an Analytics Engineering Intern to #JoinTheBand and help drive a data-first culture in the Content Unit, which works with the artists and podcasters that create the amazing work that fills our platform. Analytics Engineers design and maintain all of the data infrastructure leveraged by our data scientists. We blend and transform terabytes of data to make it easier for our data scientists to deliver key insights for the business.
The Analytics Engineering Intern will collaborate with Data Scientists, Data Engineers, and other Analytics Engineers to help craft an efficient analytics data suite, removing bottlenecks for sophisticated analytics, and empowering all end data users to efficiently answer their own questions. This involves redefining, testing, deploying, maintaining, and documenting data all while ensuring reproducibility and consistency of analytical results at all stages of the pipelines.
The successful candidate will have experience applying a collaborative work ethic in efficiently implementing data science solutions. They'll be a natural communicator, thinking in terms of solutions instead of tools, and can explain sophisticated systems to technical and non-technical audiences with equal clarity.
What you'll do
- Build and maintain the analytics data layer of our Data Science environment, which will empower research and analytic questions
- Create novel datasets and features, and improve existing ones
- Assist in the implementation of new ETL pipelines, and data infrastructure improvements, as needed
Who you are
- A current student pursuing a Bachelor’s degree in Computer Science and Engineering or a Master’s/post-graduate degree in Data Science or STEM and planning to graduate in 2024
- You currently have valid work authorization to work in the country in which this role is based that will extend from June to August 2023
- Proficiency with SQL dialects on distributed or datalake type systems (Presto, BigQuery, Spark/Hive SQL, etc); practical application proven through coursework or projects
- Experience with dbt
- Some experience analyzing data using complex SQL and basic Python in a professional setting
- You harbor a passion for numbers and the use of data to make decisions
- You also are passionate about documenting your work
- Additional skills as a plus: Hands-on experience with cloud provider integration and automation via CLIs and APIs
- You will work out of our New York City office
Our paid summer internships last for 10-13 weeks and start at the beginning of June. The last day to apply is February 28, 2023, at 11:59 PM ET.
The United States hourly rate for this position is 33.00 USD (Undergraduate First Year & Sophomores), 42.00 USD (Undergraduate Juniors & Seniors), 49.00 USD (Masters) & 58.00 USD (PhD) per hour plus a one-time intern stipend of 2,253 USD. This position is overtime eligible. These rates may be modified in the future.