Senior SAS Programmer

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.

Job Description:     
As part of Marketing Data Services team, execute clients' database marketing programs and partner with other agency practices to provide strategic planning and data insight. Support marketing initiatives ranging from email campaigns that utilize dynamic customer data, loyalty program and promotion websites, and direct mail. Understand and translate business rules and requirements into design, create and execute campaign processes, and create data outputs that support personalized marketing campaigns. Work with Account Services and other data team members to provide a diverse set of data services. Generate test and sample data in support of formalized testing. Support peers with code peer reviews and writing queries to audit campaign files. Manage multiple projects and deliverables. Explain significantly complex technical concepts to non-technical stakeholders.

Requirements:     
Bachelor's degree in Information Technology, Marketing, Business Administration, Business Analytics, Mathematics, Statistics, Computer Sciences, Economics, or related field plus 5 years of progressively responsible post-Bachelor's experience as SAS Developer, IT Engineer - System Integration, or related. 5 years of progressively responsible post-Bachelor's SAS programming experience required with 3 of the 5 years in hands-on marketing campaigns and communications. Prior experience must include: Ability to assess business, data, and technical needs for marketing campaigns and promotion; Interfacing with email service providers to stage data for campaign execution; Working closely with analytics, account and consulting teams to provide comprehensive data services; Data extraction, preparation, validation, and analysis; Using SAS Enterprise Guide for data validation and data investigation; Forecasting yearly revenue, customer retention/loss, and volumes of packages transacted under the various products; Using Enterprise Miner to conduct segmentation analysis to identify trend and create a profile; Performing data mining using SAS Enterprise Miner for customer retention and churn modeling; Extracting data using SQL queries and creating SAS data sets; Using advanced SAS Base procedures to analyze large data sets; Creating RTF, PDF, and HTML Reports using SAS ODS; Generating HTML embedded links to SAS graphs and reports formatting for the web browsers; Exporting SAS datasets to various file types (including Excel, CSV files); Preparing reports using macros according to statistician specifications; Creating ad-hoc reports and scheduling batch jobs (Cron jobs); Using SAS PROC SQL Pass through Facility to work with Teradata, SQL databases and Oracle; Developing global macros for use by multiple programs.

Submit Resumes at marketing.careers@lacek.com and reference Senior SAS Programmer

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