Data Analyst (Advertising Analytics)

Location: Columbus, OH, United States

Company

hirify.global creates and operates urban media displays and smart city infrastructure platforms across major U.S. markets.

What you will do

• Design and implement end-to-end data solutions that translate business needs into scalable analytics architecture.
• Develop data models, semantic layers, and analytics structures for multiple organizational use cases.
• Write and optimize SQL queries using CTEs, window functions, and complex joins to integrate and analyze datasets.
• Support and maintain ETL processes and data pipelines for reliable, production-ready data delivery.
• Build dashboards, visualizations, presentations, and data stories aligned with business priorities.
• Partner with Sales, Finance, Technology, and leadership to define analytics priorities and support decision-making.

Requirements

• Bachelor’s degree in Analytics, Economics, Mathematics, Computer Science, or a related field.
• 3–5+ years of experience in data analytics, including requirements definition, data modeling, and solution architecture ownership.
• 2+ years of experience writing advanced SQL queries with CTEs, window functions, and other advanced techniques.
• Experience with dashboarding tools such as Tableau, Power BI, or Looker.
• Strong organization, attention to detail, troubleshooting ability, and ownership in a fast-changing environment.
• Excellent communication skills and the ability to explain data insights to technical and non-technical audiences.

Nice to have

• Experience in media, advertising, or marketing analytics.
• Experience building processes from scratch in a smaller, fast-moving organization.
• Experience collaborating with Sales, Finance, and Technology teams.

Culture & Benefits

• Work in a lean, fast-paced environment with significant ownership.
• Collaborate across multiple business functions and with organizational leadership.
• Opportunities to grow while contributing to urban media and public engagement platforms.
• Balance technical rigor with practical, business-ready analytics outputs.