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.

#LI-DP1