Sr Analyst, Analytics, Data Engineering

Quad•Chicago, IL

2h•$65,000 - $75,000•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

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.