Sr Analyst, Analytics, Data Engineering

Rise is an award-winning, full-service Media Agency of Record that is backed by data and powered by people. We create omnichannel experiences using our proprietary tech stack and advanced analytics capabilities to help solve the unique struggles brands face today. This approach, with transparency at its core, specializes in omnichannel media, commerce and retail media, advanced in-home media, as well as content and creator marketing.

We offer "Risers" the opportunity to work in an ever-evolving industry that will foster learning and development, provide an innovative work environment with diverse projects and clients, career advancement paths a collaborative team environment, corporate social responsibility initiatives, an inclusive and diverse culture, plus association with a reputable media agency. We're looking for talent like you who can continue to elevate our work and culture.

Rise is seeking a Sr Analyst, Analytics, Data Engineering to assist the agency in the development and management of data-processing initiatives supporting a variety of clients. The successful candidate will be able to design workflows that encapsulate various acquisition, hygiene, and transformative requirements while supporting automation and scalability. Developing a high degree of familiarity and expertise with our client’s data is a marker of success.

The successful candidate will be able to effectively communicate with business stakeholders who will present business requirements: the technical design and implementation of solutions that resolve these business-focused requirements is a key measure of the candidate's value.

Locations: Sussex, WI or Chicago, IL – 4 days in office

Key Responsibilities

• Build data processing workflows to support analytic initiatives across MSSS and Snowflake platforms utilizing T-SQL, Python, Pyspark, Alteryx. Understand the merits of the various toolsets for any given solution.
• Take business-focused direction from key stakeholders and translate, design, and implement those requirements onto the appropriate technology platforms available to the team.
• Perform ETL/hygiene on disparate data from a variety of sources. Integrate that data into a variety of platforms.
• Build complex SQL queries to resolve analytic-focused requests.
• Understand/Implement performance-tuning of processes.
• Create complex data models supporting specific analytic consumption in SQL Server and/or Snowflake.
• Be able to use a combination of various tools to develop integrated systems in support of recurring analytic processes.
• Regularly identify opportunities for internal process enhancement.
• Extract insights from data and provide recommendations to improve our clients’ marketing efforts.
• Ability to evaluate various programmatic tools/approaches to determine the best platform.
• Interface with clients to understand their needs and subsequently design/manage/build accurate solutions.
• Implement vigilant process/results auditing to ensure QC.

Job Requirements

Education: BA/BS in Programming, Engineering, or other quantitative fields.

Experience

• 2-4 Years Programming experience using MS SQL. Additional skills in Alteryx, Python, PySpark/Snowpark are highly valued
• Experience with media or marketing campaigns either from client-side work or agency-side experience a plus.

Knowledge, Skills & Abilities

• Familiarity interfacing with cloud-based data sources such as Snowflake, S3, Redshift.
• Collaborative problem-solving mindset
• Intellectually curious, resourceful, with business savvy
• Clear and concise communication skills

Employees can be expected to be paid an annualized salary range of $65,000-$75,000, based on variations in knowledge, skills, experience and market conditions.

Rise and Quad are proud to be an equal opportunity employers. We are committed to creating a place of belonging — a space where employees do not need to sacrifice who they are to exist and grow in our workplace. Rise and Quad do not discriminate on any unlawful basis including race, religion, color, national origin, disability, gender, gender identity, sexual orientation, age, marital status, veteran status, genetic information, or any other basis prohibited by applicable federal, state, or local laws. Rise and Quad also prohibit harassment of applicants and employees based on any of these protected categories.