Analytics Enablement Engineer

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

WHO WE ARE:

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 individuals needs beliefs behaviors and aspirations.

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

HOW WE DO IT:

At RAPP our fearless superconnectors help to create value from personal brand experiences by focusing on three key areas: connected data connected content and connected decisioning.

Our data analysts identify who that person is our strategists understand what they want and our award-winning technologists and creatives know how to deliver it ensuring were able to activate authentic customer connections for our clients.

Part of Omnicoms Precision Marketing Group RAPP is comprised of 2000 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 RAPPs 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.

Our hybrid work model:

RAPPs 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 wed 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. For more information regarding Omnicom benefits please visit . A reasonable estimate of the salary for this role at the time of posting is $63000 - $75600. 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. This is an exempt position. If your requirements fall outside of this range you are still welcome to apply.

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.

NOTE: This job description is not intended to be all-inclusive. Employee may perform other related duties as negotiated to meet the ongoing needs of the organization.