Senior Data Analyst
Location: Columbus OH (In Office)
Company Overview
Orange Barrel Media creates and operates iconic urban media displays that advertisers ask for by name across major U.S. markets. Through Orange Barrel Media and IKE Smart City we sit at the intersection of media technology real estate and city infrastructure delivering premium out-of-home (OOH) advertising experiences and smart city platforms that serve brands cities and communities alike.
Learn more at and .
Position Overview
Orange Barrel Media is seeking a Senior Data Analyst to join our growing Data and Insights team. This role is ideal for someone who has thrived in a lean fast-paced environment where you have had to be both the strategist and the executorsomeone comfortable defining what needs to be built and then building it. You will own the full data lifecyclefrom architecting data solutions and building pipelines to delivering polished insights and strategic recommendations to leadership.
Please provide a cover letter sharing how your experience and interests synch up with this opportunity.
Key Responsibilities
Technical and Analytical Execution
- Design and implement end-to-end data solutions that translate business needs into scalable analytics architecture.
- Define data models semantic layers and analytics structures that support multiple use cases across the organization.
- Write and optimize advanced SQL queries (CTEs window functions complex joins) to integrate and analyze internal and external datasets.
- Build maintain and improve ETL processes and data pipelines for reliable production-ready data delivery.
- Develop dashboards and visualizations aligned to business priorities and analytics best practices.
- Ensure accuracy performance and long-term maintainability of analytics outputs and infrastructure.
Strategy Insights and Collaboration
- Translate ambiguous business questions into analytical frameworks and actionable insights.
- Communicate findings clearly through dashboards presentations and data storytelling for technical and non-technical audiences.
- Partner cross-functionally with Sales Finance Technology and leadership to shape analytics priorities and decision-making.
- Manage multiple initiatives with strong ownership prioritization and accountability for high-quality outcomes.
Required Qualifications
- Bachelors degree in Analytics Economics Mathematics Computer Science or related field
- 5-7 years in data analytics roles including significant experience defining requirements designing data models and owning solution architecture (not just building dashboards from specifications)
- 5 years writing complex SQL queries using CTEs window functions and advanced techniques
- Demonstrated experience with dashboarding tools (e.g. Tableau Power BI Looker)
- Strong understanding of ETL processes and data pipeline architecture
- Excellent communicator who can tell compelling stories with data to technical and non-technical audiences
- Ability to connect data outputs to real-world business use cases and troubleshoot technical issues
Preferred Experience
- Work within the media advertising or marketing analytics ecosystem
- Experience working in smaller fast-moving organizations where you have built processes from scratch or solved problems without established playbooks
- Comfort collaborating with Sales Finance and Technology teams in a complex cross-functional environment
What Success Looks Like
- You approach the business as a partner and seek to understand the why behind the data
- You take ownership of your work while remaining open to feedback and collaboration
- You balance technical rigor with practical business-ready outputs
- You help make data easier to use and interpret for everyone around you
- You are the architect of how we approach analytics problems designing solutions that scale as we grow
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.
Required Experience:
Senior IC
Senior Data Analyst Location: Columbus OH (In Office) Company Overview Orange Barrel Media creates and operates iconic urban media displays that advertisers ask for by name across major U.S. markets. Through Orange Barrel Media and IKE Smart City we sit at the intersection of media technology real ...
Senior Data Analyst
Location: Columbus OH (In Office)
Company Overview
Orange Barrel Media creates and operates iconic urban media displays that advertisers ask for by name across major U.S. markets. Through Orange Barrel Media and IKE Smart City we sit at the intersection of media technology real estate and city infrastructure delivering premium out-of-home (OOH) advertising experiences and smart city platforms that serve brands cities and communities alike.
Learn more at and .
Position Overview
Orange Barrel Media is seeking a Senior Data Analyst to join our growing Data and Insights team. This role is ideal for someone who has thrived in a lean fast-paced environment where you have had to be both the strategist and the executorsomeone comfortable defining what needs to be built and then building it. You will own the full data lifecyclefrom architecting data solutions and building pipelines to delivering polished insights and strategic recommendations to leadership.
Please provide a cover letter sharing how your experience and interests synch up with this opportunity.
Key Responsibilities
Technical and Analytical Execution
- Design and implement end-to-end data solutions that translate business needs into scalable analytics architecture.
- Define data models semantic layers and analytics structures that support multiple use cases across the organization.
- Write and optimize advanced SQL queries (CTEs window functions complex joins) to integrate and analyze internal and external datasets.
- Build maintain and improve ETL processes and data pipelines for reliable production-ready data delivery.
- Develop dashboards and visualizations aligned to business priorities and analytics best practices.
- Ensure accuracy performance and long-term maintainability of analytics outputs and infrastructure.
Strategy Insights and Collaboration
- Translate ambiguous business questions into analytical frameworks and actionable insights.
- Communicate findings clearly through dashboards presentations and data storytelling for technical and non-technical audiences.
- Partner cross-functionally with Sales Finance Technology and leadership to shape analytics priorities and decision-making.
- Manage multiple initiatives with strong ownership prioritization and accountability for high-quality outcomes.
Required Qualifications
- Bachelors degree in Analytics Economics Mathematics Computer Science or related field
- 5-7 years in data analytics roles including significant experience defining requirements designing data models and owning solution architecture (not just building dashboards from specifications)
- 5 years writing complex SQL queries using CTEs window functions and advanced techniques
- Demonstrated experience with dashboarding tools (e.g. Tableau Power BI Looker)
- Strong understanding of ETL processes and data pipeline architecture
- Excellent communicator who can tell compelling stories with data to technical and non-technical audiences
- Ability to connect data outputs to real-world business use cases and troubleshoot technical issues
Preferred Experience
- Work within the media advertising or marketing analytics ecosystem
- Experience working in smaller fast-moving organizations where you have built processes from scratch or solved problems without established playbooks
- Comfort collaborating with Sales Finance and Technology teams in a complex cross-functional environment
What Success Looks Like
- You approach the business as a partner and seek to understand the why behind the data
- You take ownership of your work while remaining open to feedback and collaboration
- You balance technical rigor with practical business-ready outputs
- You help make data easier to use and interpret for everyone around you
- You are the architect of how we approach analytics problems designing solutions that scale as we grow
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.
Required Experience:
Senior IC
View more
View less