AdTechTalent
Ad Ops1 month agoHybrid

Epsilon

Senior Business Systems Analyst

business analysisad techdigital marketingSQLdata analysiscleanroomPeopleCloudDSPSSPDMPdata warehousedata martclient liaison

Key details

Salary

$76K – $142K

Employment type

Full-time

Seniority

Senior

Years experience

5-10

Location

Chicago, United States

Full job description

Senior Business System Analyst role focused on providing technical solutions and strategies for digital marketing objectives using Epsilon’s Cleanroom platform, PeopleCloud Prospect & Discovery. Acts as liaison between clients, advertising agencies, product teams, and data science teams. Responsibilities include requirements gathering, documentation, design, testing, and project delivery support. Requires 5+ years of business analysis experience in database/data-driven marketing, strong SQL skills, understanding of relational databases and data warehousing, and knowledge of ad tech platforms such as DSP, SSP, and DMP. Must have excellent communication, problem-solving, and collaboration skills. Benefits include flexible time off, paid holidays, health coverage, 401(k), parental leave, and professional development. Location: Chicago, Illinois.

What you'll do

  • Integrate large marketers into Epsilon’s Cleanroom platform – PeopleCloud Prospect & Discovery
  • Act as subject matter expert and client liaison
  • Collaborate with Advertising Agencies, Data Science, Account Management, Client Development, Media Managers, Data Engineers, and Product Owners
  • Create and maintain project documentation including requirements, source-to-target specifications, process flow diagrams, data profiles, and test cases
  • Lead documentation reviews and gain acceptance
  • Create traceability of business requirements to functional and non-functional specifications
  • Analyze data quality and provide recommendations
  • Drive product fitment analysis and create gap resolution specifications
  • Support onboarding of multiple data sources to client’s cleanroom environment
  • Ensure business requirements are captured and met through partnership with client services, product/data teams, and data science
  • Host effective client meetings and drive successful outcomes
  • Support development and implementation of best practices, standards, and methodologies around business and data analysis

Requirements

  • 5+ years of relevant business analysis work experience in the database/data-driven marketing space
  • Experience in defining business requirements and functional specifications
  • Experience in translating business requirements into functional/business specifications
  • Understanding of relational databases, data warehouse, and data mart concepts
  • Ability to assemble, analyze, and evaluate data
  • Strong understanding of SQL
  • Curious with desire to continue learning
  • Strong critical thinking and problem-solving skills
  • Collaborative with strong attention to detail
  • Excellent written and verbal communication skills
  • Excellent presentation skills
  • Ability to multi-task, prioritize and quickly change priorities
  • Ability to work collaboratively with global teams
  • Ability to mentor and train less experienced peers
  • Understanding of web technologies a plus
  • Prefer previous digital marketing experience, especially within online display advertising
  • Prefer working knowledge of advertising technologies such as DSP, SSP, and DMP

Tech stack

SQLDemand-Side Platform (DSP)Supply-Side Platform (SSP)Data Management Platform (DMP)relational databasesdata warehousedata martdigital marketingad tech

Benefits

Flexible time off (FTO)15 paid holidaysPaid sick timeParental/new child leaveChildcare & elder care assistanceAdoption assistanceComprehensive health coverage401(k)Tuition assistanceCommuter benefitsProfessional developmentEmployee recognitionCharitable donation matchingHealth coaching and counseling

Apply now

Ready to take the next step in your career? Click the button below to continue to the application process.

Continue to applicationBrowse more jobs

Similar jobs

More roles worth a look

Related opportunities based on specialty and working model so candidates can keep momentum.