Strategic Data Analyst & Analytics Architect

Orange Barrel Media, LLC; Columbus (OH); On-site; USD 75,000 - 115,000; Full time

Job summary

Orange Barrel Media seeks a Data Analyst to join the Data and Insights team. The role focuses on architecting data solutions, building pipelines, and delivering strategic insights to leadership. You will work closely with Sales, Finance, Technology, and executives to shape analytics priorities.

The ideal candidate has 3–5+ years in data analytics, strong SQL skills, and experience creating dashboards with Tableau, Power BI, or Looker. A Bachelor's degree in a related field is required.

Qualifications

• Bachelor's degree in analytics, economics, mathematics, computer science, or related field.
• 3–5+ years in data analytics, including defining requirements and owning data models.
• 2+ years writing SQL with advanced techniques (CTEs, windows, joins).
• Experience building dashboards in Tableau, Power BI, or Looker.
• Highly organized, detail-oriented, and able to communicate data insights clearly.
• Ability to map data outputs to real business use cases and troubleshoot issues.

Responsibilities

• Design and implement end-to-end data solutions translating business needs into analytics architecture.
• Develop data models, semantic layers, and analytics structures for multiple use cases.
• Write and optimize SQL queries to integrate internal and external datasets.
• Support ETL processes and data pipelines for reliable data delivery.
• Assist dashboards and visualizations for leadership with clear data storytelling.
• Ensure accuracy, performance, and maintainability of analytics outputs.

Skills

SQL

Data modeling

ETL processes

Dashboard development

Data storytelling

Education

Bachelor's degree in Analytics, Economics, Mathematics, Computer Science, or related fields

Tools

Tableau

Power BI

Looker

Job description

Orange Barrel Media seeks a Data Analyst to join the Data and Insights team. The role focuses on architecting data solutions, building pipelines, and delivering strategic insights to leadership. You will work closely with Sales, Finance, Technology, and executives to shape analytics priorities.

The ideal candidate has 3–5+ years in data analytics, strong SQL skills, and experience creating dashboards with Tableau, Power BI, or Looker. A Bachelor's degree in a related field is required.