Sr Business Intelligence Analyst

Our Client a top entertainment company is looking for a Sr. Business Intelligence Analyst for either LA or NYC office! Responsibilities: • Foster data-informed decision making throughout the marketing organization • Deliver analyses to inform marketing decision making using Cross-Platform and Clean Room analytics platforms • Gather data requirements from marketing activation and strategy to design automated data pipelines or build new tables into Google Big Query data warehouse for reliable and scalable reporting across business uses. • Partner with data engineers to ensure design, development, and solution builds are tested and validated for signal resilience. • Clearly provide statuses and project timelines with operational and technical teams as needed. • Collaborate with team members to ensure dimensions and metrics in data pipelines are compliant with business workflows powering reporting. • Support development of auditing tools of existing data sets to check for anomalies and irregularities; leverage tools to escalate data inconsistencies using SQL and Google Cloud Service suite features. • Partner with data engineers to optimize speed performance of Big Query tables in supporting dashboards and reports. • Build dashboards (using Tableau, Python and other BI tools) that illustrate how key performance indicators (KPIs) and metrics are changing over time. Provide “color” and insights from the findings and make recommendations to the business. • Build data workflows for marketing data that ensures consistent data integrity. • Stay current with emerging trends in data science, AI, and marketing analytics and apply them to business challenges • Perform other related duties including ad hoc reporting and projects as assigned by Director Required Qualifications: • BA/BS. 2+ years experience in digital marketing and analytics, web analytics, online media industry. • Proficient in SQL with a thorough understanding of data and systems' infrastructures; experience extracting, cleaning, and transforming data within databases using SQL • Experience or coursework in media measurement including cross platform, web, native, app, video measurement technology and standards • Proficient with analytical tools and languages supporting data analysis, reporting, and visualization - Excel, Microsoft Office, Google Collaborative Apps (Docs, Sheets, Slides), Tableau, R, Python • Strong detail-orientation with a penchant for data accuracy and good grammar • Strong mathematics, statistics background • Strong solutions-oriented and critical thinking mindset • Experience using Google Cloud Platform (Big Query) • Experience translating requirements into actionable instructions and documentation • Experience in working independently to meet deliverables with some oversight • Experience using project management tools like those from Atlassian (JIRA, Confluence) • Not a data engineering environment role, this is more analytical and will be driving insights. This role is for an insights driven candidate, however the sql knowledge is necessary for the analytics tools expertise. If you meet the required qualifications and are interested in this role, please apply today. The Solomon Page Distinction Solomon Page offers a comprehensive benefit program for hourly employees. We pride ourselves on offering medical, dental, 401(k), direct deposit and commuter benefits to our employees, including freelancers - which sets us apart in the industries we serve. About Solomon Page Founded in 1990, Solomon Page is a specialty niche provider of staffing and executive search solutions across a wide array of functions and industries. The success of Solomon Page reflects an organic growth strategy supported by a highly entrepreneurial culture. Acting as a strategic partner to our clients and candidates, we focus on providing customized solutions and building long-term relationships based on trust, respect, and the consistent delivery of excellent results. For more information and additional opportunities, visit: solomonpage.com and connect with us on Facebook, and LinkedIn. Opportunity Awaits.