Jr. Data Analyst

Who We Are:

With office locations in Pittsburgh and Chicago, Gatesman is a privately held, fully integrated marketing communications agency with expertise in advertising, digital, analytics, public relations, social media, and performance media. We don't shy away from the unknown and thrive on the speed of business. We solve business challenges by using data, and a human filter to fuel our marketing solutions- whether it's building brand awareness, improving reputation, launching new products, or publishing brand narratives. We maintain our client relationships with an industry leading tenure of 7+ years on average.

Our agency is frequently named as being one of the Best Places to Work as voted by our own employees, and continuously earn a 90%+ satisfaction rate in blind annual surveys among our clients and employees. With 60+ associates and thriving, Gatesman serves clients nationwide in Healthcare, Higher Ed, Energy, Financial, Retail and B2B.

Jr. Data Analyst

Gatesman is seeking a Jr. Data Analyst who is excited to join our growing analytics team. The Jr. Data Analyst will support the analytics team in collecting, analyzing, and interpreting data to help drive data-informed decision-making. This individual should have a background using numbers and digging into data, heightened attention to detail, and a curiosity for finding business insights in data. Overall, this is someone who will be interested in helping our clients succeed by getting the most out of their data.

Responsibilities:

Collaborate with the agency teams to support data analysis, tracking set up, reporting and measurement for all agency-led initiatives.
Work cross-functionally to assist in tracking set-up prior to launch
Push data into database environments through either manual insertion, creating scheduled emails or working with our partner to set up necessary feeds.
Pull data from reporting interfaces including various advertising platforms, google analytics and dashboards
Collect and analyze datasets to generate actionable insights
QA dashboards to ensure reliability and usability for the end user; Address dashboard and data issues as they arise
Provide regular reporting that has accurate data, meaningful metrics and key observations
Begin to create compelling dashboards that are easy for stakeholders to interpret and quickly gauge success of initiatives
Deep dive into interesting trends identified in dashboards to help round out more meaningful insights
Proven ability to work effectively both independently and as part of a team. Strong interpersonal skills to collaborate with various departments.
The successful candidate will demonstrate the following characteristics:

Thoughtful and curious with a data-driven approach to solving business problems
Strong analytical skills with experience in data usage and confidence with numbers and logic
High attention to details; ability to follow key data processes to achieve desired end result
Strong written and verbal communications skills with the ability to take complex data and articulate them in easily understood concepts
Energized by learning new things and continuous improvement
Demonstrated ability to work independently and collaboratively with cross-functional teams to achieve shared objectives
Commitment to delivering measurable results and a proven ability to manage projects to successful completion
Required Qualifications:

Bachelor's Degree in Marketing, Economics, Statistics or related discipline
Proficiency using Excel (including pivot tables and VLOOKUP), reporting interfaces and data visualization software
Experience with Tableau and/or other dashboarding tools
Preferred Qualifications:

One year experience in business and/or marketing analytics preferred
Familiarity and understanding of digital advertising and marketing preferred
Experience using marketing data via Google Ads, Meta Ads, LinkedIn Ads preferred
Some experience writing code in SQL or python preferred
Gatesman Benefits:

Hybrid Work Schedule
Medical, Dental and Vision Insurance available on the first day of employment
FSA/HSA's
401k with an employer match
Unlimited PTO
Flex Friday's
13 Holiday's including time off between Christmas and New Years
Paid Maternity and Paternity Leave
Strong culture and supportive working environment