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