Sr Analyst, Analytics, Data Engineering at Rise, a Quad agency | Chicago, IL | $65K/yr – $75K/yr

Rise, a Quad agency

Sr Analyst, Analytics, Data Engineering

Chicago, IL (Hybrid)

$65K/yr – $75K/yrSenior Level2+ years expFull time

Posted 4 months ago

Top 1% of applicants do these two things.

The other 99% submit and hope. You're about to do something different.

Job Summary

Drive data workflows and ETL across SQL Server and Snowflake to support analytics initiatives.

Own cross-platform data processing using T-SQL, Python, PySpark, and Alteryx.
Must-have: 2–4 years MS SQL programming with related tooling.
Standout: Client-facing requirements gathering and QC auditing for analytic solutions.

Job Description

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.

Requirements

Education: BA/BS in Programming, Engineering, or other quantitative fields.
2-4 Years Programming experience using MS SQL. Additional skills in Alteryx, Python, PySpark/Snowpark are highly valued
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

Preferred

Experience with media or marketing campaigns either from client-side work or agency-side experience a plus.

Rise, a Quad agency

With a history in digital media, analytics, and customer experience, Rise proudly joins Quad, a global Marketing Experience company, to challenge the status quo and redefine the future of integrated marketing, together. As a full-service media agency, we move at the speed of opportunity with passion, inclusion, and understanding. We foster a culture of positivity and perseverance to usher in the future of media and challenge the status quo.At Rise, 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.Please note: Rise will never ask you to install an app or send money as part of the hiring process.

Founded in 2004

Chicago, Illinois, USA

386 employees (132 in marketing)

www.meetrise.com