SQL Developer

Skills

· Basic Requirements · 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. Minimum of 5 years of related professional experience in IT Marketing Research Analytics or Marketing. ·Expertise with the following concepts: o Relational databases o Database marketing o Data manipulation/ETL (Extract-Transform-Load) · Expertise in data management (security hygiene etc.) direct marketing campaign analytics and/or retail industry

Description

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 Best Buy 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.

Responsibilities

• · 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.
• How much time will the resource spend pair programming? Until the resource is comfortable