Analytics Enablement Engineer

RAPP Chicago is seeking an Analytics Enablement Engineer to join their Marketing Sciences team. This role involves defining and implementing analytics solutions to support client initiatives, focusing on data architecture, documentation, and comprehensive tracking of marketing touchpoints. 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 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 Benefits Health/vision/dental insurance 401(k) Stock options Healthcare & Dependent Flexible Spending Accounts Vacation Sick, and personal days Positive activism days Paid parental leave Disability benefits Company Overview RAPP is a customer experience agency. It is a sub-organization of DAS Group. It was founded in 1965, and is headquartered in New York, New York, USA, with a workforce of 1001-5000 employees. Its website is Company H1B Sponsorship RAPP has a track record of offering H1B sponsorships, with 3 in 2024, 1 in 2023, 1 in 2022, 1 in 2021. Please note that this does not guarantee sponsorship for this specific role.