Analytics Enablement Engineer at RAPP in Greater Chicago Area

Summary: 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 Required Qualifications: - 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 Required Skills: ETL concepts, SQL, Python, JavaScript Important Skills: Amazon Web Services, Google Analytics, Data quality Nice-to-Have Skills: Cultural sensitivity, Problem-Solving, Communication skills 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