Senior Analyst - Orange Barrel Media

Senior Analyst

Location: Columbus, OH – This in-office position requires you to live in Columbus, Ohio. Candidates outside of Columbus will not be considered. 

Company Overview

Orange Barrel Media creates and operates iconic urban media displays that advertisers ask for by name in 27 of the top markets in the U.S. Since our founding in 2004, OBM has pioneered a community-oriented model of outdoor media development and is now nationally recognized by cities and real estate owners alike seeking to implement best-in-class programs that add to the character of urban places. To this end, OBM has pioneered zoning changes allowing spectacular signage in several markets (and growing), including Los Angeles, Boston, Washington, DC, Atlanta, Denver, and other high barrier-to-entry markets. In the advertising community, OBM is widely recognized as the owner of the highest impact and most memorable advertising locations in the cities where it operates, and OBM displays are consistently selected as the centerpiece of clients' outdoor advertising campaigns.

The OBM team is also a leader in smart city infrastructure, launching the interactive kiosk experience (“IKE”) platform in concert with cities across the United States through the company IKE Smart City. IKE is a breakthrough citizen engagement platform that helps cities communicate with the public, improve the pedestrian experience, and tell the story of their city. Our commitment to innovation and ongoing investment in software development has created the true smart city hub: a multi-lingual, open, and flexible platform with integrated features, functions, services, and resources that provide cities and the public with everything they need to navigate their city, all in one place. The core tenets of the IKE platform are public benefit and social equity, two values that we seek to maximize in every IKE market through the formation of public-private partnerships that achieve city objectives, exceed community expectations and build smart cities. Learn more at orangebarrelmedia.com and ikesmartcity.com.

Position Overview

Orange Barrel Media is seeking a Senior Analyst to join our growing analytics team. The Senior Analyst will coordinate with varying stakeholders in the business to develop reporting and analyses that helps empower other teams to make data-based decisions and help guide teams with recommendations based on business needs.

Responsibilities:

• Analyze data to identify insights that drive business decision-making.
• Develop and maintain SQL queries and stored procedures to extract, transform, and analyze data from various sources.
• Create and maintain advanced Tableau dashboards and reports to visualize data and present findings to non-technical stakeholders.
• Utilize strong data storytelling skills to provide tools and resources to the business.
• Collaborate with cross-functional teams to understand business needs and translate them into analytical solutions.
• Provide recommendations based on data analysis to maximize business value and support strategic business initiatives.
• Ensure data accuracy and integrity in all analysis and reporting efforts.
• Mentor and provide guidance to junior analysts on the team.

Qualifications:

• Bachelor's Degree
• 5+ years of experience in financial analysis, business analysis, data analysis, or a related field.
• Detail-oriented experience leading projects.
• Strong written and verbal communication skills. Able to advocate for data driven decision making to a variety of audiences.
• Advanced proficiency in SQL, with experience in writing complex queries and working with disparate datasets.
• Strong experience with Tableau, including dashboard development, data visualization, and storytelling with data.
• Excellent analytical and problem-solving skills, with the ability to derive insights from complex data sets.
• Strong communication skills, with the ability to convey technical concepts to non-technical audiences.
• Experience working in a fast-paced, dynamic environment, with the ability to manage multiple priorities.
• Familiarity with other data visualization tools (e.g., Power BI, Looker) is a plus.
• Experience with statistical analysis and/or programming languages (e.g., Python, R) is a plus.

This job description is intended to convey information essential to understanding the scope of the role and is not an exhaustive list of skills, efforts, duties, responsibilities, or working conditions associated with it. Responsibilities may change over time to adapt to business needs.