Back to Archive

Junior Data Engineer

PMG Advertising Agency

Austin, TX | Posted: 5 years ago

This job is expired and may no longer be accepting applications.

PMG is looking for a Junior Data Engineer with strong data warehousing experience to help lead up our data infrastructure process. This person will work closely with the Data Innovation, Analytics, and Development teams to build a strong foundation of data integrity and governance. We are looking for someone to set our clients up for success, ensuring they can access and act on their terabytes of marketing data.


ON A WEEKLY BASIS, YOU WILL BE RESPONSIBLE FOR:

  • Driving the advancement of PMG data infrastructure by designing and implementing the underlying logic and structure for how data is set up, cleansed, and ultimately stored for organizational usage.
  • Defining, documenting, and evangelizing data usage and best practices across PMG.
  • Scoping points of failure and creating alerts to ensure continual data cleanliness and accuracy.
  • Creating scripts to connect to APIs for Google, Facebook, SimilarWeb, etc., pulling and storing data for organizational use.
  • Interfacing with Data Innovation, Analytics, and Account Services teams to scope new use cases for structural data development.
  • Helping guide the development of feature improvements to our suite of proprietary data-intensive tools.


YOU'LL BE SUCCESSFUL IN THIS ROLE IF:

  • You have 3-5 years of experience working with back-end data systems to create clean data structures for use across the organization.
  • Organization and structure bring you joy. You enjoy the process of seeing everything fit into a nice orderly system.
  • You love solving good challenge. Taking a large problem, deconstructing it to make a plan of attack, and ultimately executing on that plan is something that excites you.
  • You have an interest in learning more about the intricacies of how search, social, and display work from a data-oriented perspective, or you have previous experience in these areas.
  • Youre comfortable communicating and presenting complex topics and plans to people in the organization, regardless of their technical skill level.
  • Youre a pro at writing complex SQL queries to manipulate data. Window functions and nested subqueries are second nature to you.
  • Youre proficient at writing scripts with Python, PHP, or Javascript. (Python preferred)
  • You feel at home with the AWS infrastructure, including the use of Redshift, Lambda functions, and S3 buckets.

This job was sourced from StackOverflow Jobs.