Data Analyst

Data AnalystOrange Barrel Media is seeking a 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 executor—someone comfortable defining what needs to be built and then building it. You will contribute to the full data lifecycle—from 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 align with this opportunity.Technical and Analytical ExecutionDesign and implement end-to-end data solutions that translate business needs into scalable analytics architectureProven understanding of data models, semantic layers, and analytics structures that support multiple use cases across the organizationWrite and optimize moderate SQL queries (CTEs, window functions, complex joins) to integrate and analyze internal and external datasetsSupport & maintain ETL processes and data pipelines for reliable, production-ready data deliverySupport the Director of Analytics and Sr Data Analyst as needed for dashboards and visualizations aligned to business priorities and analytics best practicesEnsure accuracy, performance, and long-term maintainability of analytics outputs and infrastructureStrategy, Insights, and CollaborationTranslate ambiguous business questions into analytical frameworks and actionable insightsCommunicate findings clearly through dashboards, presentations, and data storytelling for technical and non-technical audiencesPartner cross-functionally with Sales, Finance, Technology, and leadership to shape analytics priorities and decision-makingManage multiple initiatives with strong ownership, prioritization, and accountability for high-quality outcomesQualificationsRequiredBachelor's degree in Analytics, Economics, Mathematics, Computer Science, or related fields3-5+ years in data analytics roles, including significant experience defining requirements, designing data models, and owning solution architecture (not just building dashboards from specifications)2+ years writing SQL queries using CTEs, window functions, and advanced techniquesExperience with dashboarding tools (e.g., Tableau, Power BI, Looker)Highly organized and detail-oriented, with the ability to maintain accuracy in dynamic, fast-changing environmentsExcellent communicator who can tell compelling stories with data to technical and non-technical audiencesAbility to connect data outputs to real-world business use cases and troubleshoot technical issuesPreferredWork within the media, advertising, or marketing analytics ecosystemExperience working in smaller, fast-moving organizations where you have built processes from scratch or solved problems without established playbooksComfort collaborating with Sales, Finance, and Technology teams in a complex, cross-functional environmentWhat Success Looks LikeYou approach the business as a partner and seek to understand the "why" behind the dataYou take ownership of your work while remaining open to feedback and collaborationYou balance technical rigor with practical, business-ready outputsYou help make data easier to use and interpret for everyone around youYou are the architect of how we approach analytics problems, designing solutions that scale as we grow