Position Overview & Specifications
Location: Minneapolis / St. Paul or Remote
Notes:
Work Environment - Remote or if candidate is local - open to hybrid if desired.W2 or C2C candidates are welcome to apply.
VALERE is seeking a SQL Developer who will become a part of our Client's team that is 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 will be responsible for supporting data requirements for customer communication efforts in support of a variety of initiatives across all our enterprise retail Client 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.
Key ResponsibilitiesWrites 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.
Skills Overview:
Required:
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.
Nice to have /preferred qualifications:At least 3 years' experience with Campaign Management Applications/SoftwareExpertise with the following concepts:Relational databasesDatabase marketingData manipulation/ETL (Extract-Transform-Load)Expertise in data management (security, hygiene, etc.), direct marketing, campaign analytics, and/or retail industry
We welcome diversity:At VALERE, we know that when people from different backgrounds and perspectives come together, amazing things happen. We strive to create a workplace where every employee, candidate, and client feels valued, respected, and empowered to reach their full potential.We actively work to dismantle barriers that prevent underrepresented groups from thriving in Tech, UX, and Product careers. No matter your race, gender, age, sexual orientation, gender identity or disability β we welcome you.
Notes:
Work Environment - Remote or if candidate is local - open to hybrid if desired.W2 or C2C candidates are welcome to apply.
VALERE is seeking a SQL Developer who will become a part of our Client's team that is 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 will be responsible for supporting data requirements for customer communication efforts in support of a variety of initiatives across all our enterprise retail Client 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.
Key ResponsibilitiesWrites 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.
Skills Overview:
Required:
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.
Nice to have /preferred qualifications:At least 3 years' experience with Campaign Management Applications/SoftwareExpertise with the following concepts:Relational databasesDatabase marketingData manipulation/ETL (Extract-Transform-Load)Expertise in data management (security, hygiene, etc.), direct marketing, campaign analytics, and/or retail industry
We welcome diversity:At VALERE, we know that when people from different backgrounds and perspectives come together, amazing things happen. We strive to create a workplace where every employee, candidate, and client feels valued, respected, and empowered to reach their full potential.We actively work to dismantle barriers that prevent underrepresented groups from thriving in Tech, UX, and Product careers. No matter your race, gender, age, sexual orientation, gender identity or disability β we welcome you.