Ogilvy

  • Senior Analyst, Data Intelligence

    Posted Date 1 week ago(1 week ago)
    Requisition ID
    2018-3925
    Location
    US-MN-Minneapolis
    Department
    Analytics
  • Overview

    The Lacek Group (TLG), a specialty agency of Ogilvy & Mather, is a fast-growing customer engagement agency.  We work at the intersection of brands, data, and creativity to help industry-leading companies build and strengthen relationships with their best customers.


    As a Senior Analyst, Data Intelligence you will be responsible for executing campaigns for our clients' marketing loyalty program.  Your key responsibilities will be to provide data audiences for targeted email and direct-mail campaigns, leveraging complex customer and transactional data.  

    Responsibilities

    • Develop SQL queries based upon documented business requirements to transform customer data and to create audience lists.
    • Design and execute campaign processes to create data outputs supporting  personalized marketing email.
    • Collect and document selection criteria and business rules for new marketing campaigns and promotions.
    • Work with other team members to coordinate data service deliverables.
    • Assess business, data & technical needs, communicate gaps, risks and assumptions
    • Understand and document technical campaign requirements.
    • Support peers with code peer reviews and writing queries to audit campaign files.
    • Supply test/sample data in support of formalized testing.
    • Juggle multiple projects and timelines.

    Qualifications

    • 3 or more years of hands-on experience working with SQL or a similar database environment
    • Able to learn quickly and be very comfortable working within customer databases/ marts
    • Experience staging data using ETL tools and Teradata preferred
    • Superior attention to detail and organizational skills
    • Demonstrated ability to communicate and collaborate well in a team environment
    • Experience developing and/or documenting project requirements, code and processes
    • Self-motivated, proactive, and confident working independently
    • Bachelor’s Degree in Statistics, Marketing, IT, computer science or related field preferred

     

    You’ll love working at The Lacek Group – smart people, great environment, engaging culture, comprehensive benefits and fantastic growth opportunities. Your confidential inquiry is encouraged. 

     

    The Lacek Group

    900 2nd Avenue South, Suite 1800

    Minneapolis, MN  55402

     

    The Lacek Group is an Equal Opportunity Employer

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed