Job description

About TEAM LEWIS TEAM LEWIS is a global marketing agency that has grown from start-up to multi-national in a little over two decades. Its success is due to a combination of factors: talented creatives delivering award winning campaigns; expanding client relationships into new markets or services; its independence from outside investors. The agency, its people and client campaigns have won many awards, including Cannes Lions, PRovoke Media, ICCO, European Excellence, PRCA Digital, Digital Impact, Global Digital Excellence. At the heart of the business is the TEAM LEWIS Foundation (TLF), a non-profit charitable entity. Since its launch in 2021, it has funded over 2,700 causes. The TLF promotes a wide variety of social, cultural, and environmental causes that benefit society. It aims to strengthen the bonds between the creative industries, businesses, government, and non-profits. Community charities are championed by employees who, in addition to the financial donation, volunteer their time and skills to maximise the grants’ effectiveness. Purpose of the role We're looking for a passionate Sr. Data Analyst to help ensure clients have strong foundational analytics in place that help set the stage for effective measurement of marketing programs. This role will support the growth and use of analytics across the agency. This includes much of the technical setup and know-how required to measure performance across clients, and ensuring a strong foundation for tracking and reporting. A key component of this role is the ability to help support the setup and management of new dashboards, as the broader rollout and development of reporting and analytics across all clients is a core goal of the Analytics team moving forward. Key responsibilities and tasks • Analyze digital marketing and PR data from disparate data sources to optimize digital campaigns and communications programs • Serve as the day-to-day analytics point of contact on digital and PR clients; work closely with account, paid media, and content counterparts to deliver data-backed insights and recommendations to inform content and campaign optimization • Lead weekly, monthly, and quarterly owned and earned reports for retainer clients; conduct ad hoc analyses to support new business efforts and project-based work • Work closely with our data engineers to ensure data is clean and accurate. Implement and document new processes for data categorization, naming, and tracking to make reporting clearer and more efficient • Present performance results to internal teams and clients About you • 3-5 years of experience in an analytics, insights, or research role, ideally at a marketing, advertising, or PR agency • Strong proficiency in Microsoft Excel • Experience using BI data visualization and dashboarding tools such as Looker Studio or Tableau for data analysis • Familiarity with social media and digital advertising analytics platforms, such as LinkedIn Campaign Manager, Meta Ads/Business Manager, Amazon Ads, Google Analytics, and Adobe Analytics • Experience presenting reports and findings to clients and explaining technical concepts to non-technical audiences • Strong writing and communication skills • Strong attention to detail • Familiarity with ETL and data pipelines preferred • Experience using SQL for data analysis preferred This job description is not intended to be an exhaustive list of the responsibilities for this role. Other responsibilities may be added from time to time. Benefits: • Competitive salary • Hybrid work environment • Generous PTO • Paid parental leave • Medical, dental, and vision benefits + life insurance (eligible day 1 of employment) • 401k with employer match • Travel Programs • Free self-led industry courses via our Lewiversity platform • Up to $2k donation to a charity of your choice! The expected salary range for the Sr. Analyst position is between $70K - $95K. Base annual salary is determined by factors such as location, experience, and expertise. We provide equal employment opportunities to all employees and applicants for employment and prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, reproductive health decisions and family responsibilities, qualifying acts of violence, or any other characteristic protected by federal, state or local laws.

Requirements