JOB SUMMARY:
Adams Outdoor Advertising (AOA), the 4th largest and largest private Outdoor Advertising firm in the U.S., is seeking an Analytics Engineer to build, maintain, and optimize the data infrastructure that powers business insights.
You will be responsible for ensuring data accuracy, timely availability, and accessibility for reporting and analytics. The position requires advanced SQL skills, experience with dbt, and the ability to work closely with sales and finance teams to provide training on how to use our data tools to drive data-informed decisions.
ESSENTIAL FUNCTIONS OF POSITION INCLUDE:
- Build and maintain data pipelines in dbt to ensure accurate, timely, and accessible data for analytics and reporting.
- Create and maintain Tableau dashboards that deliver actionable insights and data visualizations for various teams.
- Collaborate with sales teams to develop solutions for complex data challenges, including predictive analytics and advanced reporting.
- Write and optimize advanced SQL scripts to automate complex data processes, ensuring accuracy and efficiency in alignment with business objectives.
- Train finance and IT analysts on how to use SQL to analyze data in our Snowflake warehouse.
- Continuously evaluate and recommend improvements to the data processes and tools to meet evolving business needs.
- Support cross-functional teams by providing data insights and solutions as needed.
- Other duties as assigned.
PREFERRED QUALIFICATIONS:
- Bachelor’s degree in Data Science, Business Analytics, Computer Science, or a related field.
- 2 - 7 years of experience in a data operations role with a focus on dbt, SQL, and data visualization tools.
- Advanced SQL skills, with a proven ability to script and automate data processes.
- Experience building and maintaining data pipelines in dbt.
- Proficiency with Tableau (or a similar tool) for creating visualizations and delivering actionable insights.
- Strong collaboration skills to work effectively across teams.
ADAMS OUTDOOR ADVERTISING:
- AOA, founded in 1983 by Steve Adams, is the 4th largest, and largest privately-held, Outdoor Advertising operator in the U.S.. AOA operates in the following 12 markets: Ann Arbor/Kalamazoo/Lansing (MI), Beaufort/Charleston/Florence (SC), Charlotte (NC), Eastern Pennsylvania (PA), Madison (WI), Norfolk (VA), Peoria and Champaign (IL).
- Searchlight Capital Partners, a leading global private investment firm, in partnership with British Columbia Investment Management Corporation, one of the largest asset managers in Canada, invested in AOA in 2021.
The above statements are intended to describe the general nature and level of work being performed by the people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required of the job.
#LI-Remote
Top Skills
What We Do
Founded in 1983, Adams Outdoor is the 4th largest privately held out of home advertising operator in the United States. Our portfolio of 10,000+ displays are comprised of static bulletins, static posters, junior posters and digitals located in 15 markets across the Midwest, Northeast and Southeast. By thinking big, we are able to help our clients reach their audience and drive results where it matters most.
It's through our core values of Tenacity, Accountability, Innovation, and Integrity that we strive to do what's best for our clients, partners, and team members.
We are proud to be a leader in the outdoor space and are committed to growing the industry through meaningful relationships, original thinking, and the relentless pursuit of authenticity.
