Analytics Enablement Engineer

Analytics Enablement Engineer

RAPP Chicago is looking for an Analytics Enablement Engineer to join our award-winning Marketing Sciences team.

We are RAPP – world leaders in activating growth with precision and empathy at scale.

As a global, next-generation precision marketing agency we leverage data, creativity, technology, and empathy to foster client growth. We champion individuality in the marketing solutions we create, and in our workplace. We fight for solutions that adapt to the individual's needs, beliefs, behaviors, and aspirations.

We foster an inclusive workplace that emphasizes personal well-being.

Part of Omnicom's Precision Marketing Group, RAPP is comprised of 2,000+ creatives, technologists, strategists, and data and marketing scientists across 15+ global markets

Your Role

The Analytics Enablement Engineer defines and implements analytics solutions in support of the measurement needs of RAPP's client initiatives. This person will facilitate architecture, documentation, and the implementation of a wide-range of analytics solutions including, data ecosystem components, tag management, analytics platform configuration, and data extraction to facilitate the comprehensive tracking of marketing touchpoints. Experience with data ecosystems, digital media platforms, web analytics software, tag management systems, and data management concepts is critical in this role. At RAPP, Analytics Enablement exists at the intersection between analytics and technology, as a division of the RAPP Marketing Sciences Center of Excellence.

Your 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

Required Skills

• 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
• Problem-Solving & Commitment: Ability to solve complex measurement and business challenges through technical creativity, while maintaining a continuing education commitment to remain current on analytics technology
• Personal Traits: 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 and cultures.
• Contributes to a work culture where differences are valued and supported.
• Is sensitive to cultural norms, expectations, and ways of communicating.

RAPP's current hybrid model is designed to enable in-person connections and collaboration that is core to our culture, while also supporting flexibility for all employees. As such, we have the option to work from home two days per week, if we'd like. RAPP provides a competitive salary and comprehensive benefits plan. Benefits for this role include health/vision/dental insurance, 401(k), stock options, Healthcare & Dependent Flexible Spending Accounts, vacation, sick, and personal days and positive activism days, paid parental leave and disability benefits. A reasonable estimate of the salary for this role, at the time of posting, is $63,000 - $75,600. This range is specific to Chicago and multiple factors are considered in making compensation decisions including, but not limited to: skill set, experience and training, certifications; etc.

"As an EEO/Affirmative Action Employer all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status."