Analytics Enablement Engineer

Unclassified - Chicago, IL

Full-time - Mid Level

Remote - Chicago, IL

1,001-5,000 employees

About the position

The Analytics Enablement Engineer at RAPP Chicago is responsible for defining and implementing analytics solutions to support the measurement needs of client initiatives. This role involves collaborating with cross-functional teams to understand business requirements, designing data models, and developing foundational analytics capabilities to enable data-driven decision-making. The position sits at the intersection of analytics and technology within the Marketing Sciences Center of Excellence.

Responsibilities

• Perform discovery of client marketing and analytics data ecosystems
• Collaborate with cross-functional teams to understand business requirements and translate them into solutions for analytics initiatives
• Partner on requirements for data pipelines and infrastructure to ensure the efficient collection, storage, and processing of data
• Design and implement data models and views to organize and optimize the storage and retrieval of data
• Develop and maintain foundational data analytics capabilities such as dashboards and self-service initiatives that enable data-driven decision-making across the organization
• Identify and resolve data quality and integrity issues, ensuring that data is accurate, complete, and accessible to stakeholders

Requirements

• Minimum 1-3 years of analytics and technology experience
• An understanding of ETL concepts including the data integration pipeline, staging tables, incremental loading, SCD, data quality, business logic, and views
• Experience authoring SQL, Python, and JavaScript in team environments, leveraging Git for source control
• Experience authoring SQL to query, load, transform, and retrieve data from various databases including MS SQL Server, Redshift, and PostgreSQL
• Experience with scripting and other languages including Python, JavaScript, CLI, and Regular Expressions
• Experience with cloud services including Amazon Web Services
• An understanding of core marketing analytics concepts including impressions, clicks, pageviews, events, sessions, users, conversions, and attribution models
• Experience working in or supporting analytics for digital media, with working knowledge of Google Analytics / Ads / Campaign Manager / DV360 / SA360, Bing Ads, Facebook Ads, Kochava or other MMPs, Salesforce Marketing Cloud, and Adobe Analytics is a plus
• Ability to solve complex measurement and business challenges through technical creativity, while maintaining a continuing education commitment to remain current on analytics technology
• Passionate about problem solving in the areas of marketing, data, analytics, and technology
• Excellent verbal and written communication skills
• Recognizes the value that different perspectives and cultures bring to an organization and seeks to understand those different perspectives
• Contributes to a work culture where differences are valued and supported

Nice-to-haves

• Experience with Google Analytics / Ads / Campaign Manager / DV360 / SA360, Bing Ads, Facebook Ads, Kochava or other MMPs, Salesforce Marketing Cloud, and Adobe Analytics

Benefits

• Competitive salary
• Hybrid work model allowing work from home two days per week