Marketing Campaign SQL Developer - Minneapolis, United States - Talent Software Services

Description

Marketing Campaign SQL Developer

Job Summary: Talent Software Services is in search of a Marketing Campaign SQL Developer for a contract position in Richfield, MN. Opportunity will be three months with a strong chance for a longterm extension.

Position Summary: Responsible for designing, building, and maintaining complex database queries, stored procedures, workflows, and processes using SQL within a complex data environment that includes Google BigQuery, Netezza, and Oracle databases. This role is responsible for supporting data requirements for customer communication efforts in support of a variety of initiatives across all client brands and channels. This position works within data warehouses, executes data import/transfers, supports reporting environments via applicable data attribute logging, and solves data challenges daily. This position works collaboratively with Email Architects, Marketing team colleagues, and Third-Party Vendor partners to ensure that CRM campaigns are executed correctly and within the appropriate deadline.

Primary Responsibilities/Accountabilities:

• Writes and executes SQL queries utilizing common table expressions (CTE), inner joins, outer joins, cross joins, grouping, subqueries, and a variety of different types of criteria used to support customer selection for marketing campaigns, data investigations, and count requests.
• Responsible for the moderate to very complex design of data processes for direct marketing campaigns.
• Works with email architects and Third-Party vendors such as: MessageGears, Salesforce, etc. to ensure data meets requirements.
• Performs data quality assurance review and the quality assurance review of the final communication before the communication (email, direct mail, and Phone list) launches.
• Identifies and develops new campaign program improvements.
• Participates in efforts to build new direct marketing capabilities through new technical design projects.
• Identifies and manages process improvement efforts to continue to refine the campaign operations processes.

Qualifications:

• At least 10 years experience writing SQL in a business environment.
• Minimum of 5 years of related professional experience in IT, Marketing Research, Analytics or Marketing.
• A strong business process/operations/analytical background.
• Bachelor's degree (marketing, MIS, computer science, or business)
• Experience handling sensitive customer data using privacy and security standards and processes.
• Strict attention to detail.
• A curious mindset.
• Ability to manage a variety of tasks and requests from many different departments and colleagues.
• Ability to work comfortably and professionally in a dynamic and collaborative environment.
• Strong communication skills to translate between business and technical requirements and interact with a variety of stakeholders.
• Able to adjust communications as appropriate for audiences with varying degrees of technical expertise.

Preferred:

• At least 3 years experience with Campaign Management Applications/Software
• Expertise with the following concepts:
  • Relational databases
  • Database marketing
  • Data manipulation/ETL (Extract-Transform-Load)
• Expertise in data management (security, hygiene, etc.), direct marketing, campaign analytics, and/or retail industry

If this job is a match for your background, we would be honored to receive your application

Providing consulting opportunities to TALENTed people since 1987, we offer a host of opportunities including contract, contract to hire and permanent placement. Let's talk