Data Analytics Manager (DTC Ecommerce)

Software Guidance & Assistance, Inc., (SGA), is searching for a Data Analytics Manager (DTC Ecommerce) for a FULL-TIME assignment with one of our premier Pharmaceutical Services clients in Westchester County, NY.

The Manager, Digital Marketing Analytics - Direct to Consumer (DTC) and eCommerce will play a critical role in analyzing media spend and performance across various channels, including traditional, digital, and retail media investments, with a focus on maximizing return on investment (ROI) and driving sales outcomes. This role supports cross-functional teams such as media, CRM, and marketing by providing insights and recommendations to optimize media spend allocation and performance. The ideal candidate will be experienced in major DTC and retail media channels, and adept at using third-party analytics tools alongside Adobe Analytics to interpret website behavior, trends, and sales drivers. Prior experience working in-house or supporting a DTC, subscription, and/or consumer health brand is preferred. The role will also require cross-functional collaboration with teams in supply chain, operations, and finance.

Responsibilities:

• Analyze and optimize media spend across traditional, digital, and retail media channels, supporting the media, CRM, and marketing teams with actionable insights to drive sales growth and maximize ROI.
• Utilize Adobe Analytics as the primary tool for web performance and sales analysis, while integrating third-party tools such as Google Analytics, Looker, and Data Studio to provide a holistic view of customer journeys and channel performance.
• Support and advise on channel investments, helping adjust spend to achieve maximum return and meet sales targets by channel.
• Proficient in SQL (5 years) for querying data and working with databases, and experience in data transformation (3 years) to define and standardize data across the organization.
• Familiarity with retail media networks such as Walmart Connect, Amazon, Target/Roundel, and Criteo, analyzing their media performance and optimizing campaigns for maximum effectiveness.
• Experience with Excel and data visualization tools such as Tableau or Power BI to create dashboards and visual reports for stakeholders.
• Collaborate with marketing teams to track the performance of campaigns, providing detailed insights into the effectiveness of different media channels.
• Develop and maintain automated reports and dashboards to communicate key performance indicators (KPIs), ensuring stakeholders have a clear understanding of trends, opportunities, and risks.
• Provide thought leadership on the use of data to influence marketing strategies, assisting with test-and-learn initiatives and performance forecasting.
• Identify and communicate key drivers of sales outcomes and website behavior, offering recommendations for optimizations across digital and eCommerce platforms.
• Use JavaScript and HTML/CSS when necessary to analyze or manipulate web performance metrics and improve tracking implementations.
• Serve as a partner to cross-functional teams (supply chain, operations, finance), translating complex data into clear, actionable strategies to enhance marketing efforts and improve business outcomes.
• Stay current with industry trends and emerging analytics tools to continuously improve media optimization and performance measurement.

Required Skills:

• Bachelor's degree in Marketing, Business, Data Science, or a related field.
• 6-8 years of professional experience in digital marketing analytics or a similar field.
• 5 years of experience with SQL and 3 years with data transformation to standardize and define data across the organization.
• Proven experience with Adobe Analytics, Google Analytics, and familiarity with other third-party tools such as Looker, Google Data Studio, Criteo, Walmart Connect, Amazon, and Target/Roundel.
• Experience working with DTC, eCommerce, or subscription-based brands in a consumer health, beauty, or related industry.
• Strong analytical skills with proficiency in Excel, Tableau, or Power BI for data visualization and reporting.
• Familiarity with JavaScript, HTML/CSS, and the ability to implement or manage web performance tracking.
• Excellent communication skills, with the ability to present complex data to stakeholders in a clear and actionable manner.
• Ability to manage multiple projects and requests, prioritizing tasks to meet deadlines in a fast-paced environment.
• Proven ability to work cross-functionally and support teams in supply chain, operations, and finance, delivering insights that improve overall business performance.

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com/ .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.