SQL Developer IV

4 weeks ago

Richfield, United States C4 Technical Services Full time
SQL Developer IV - Marketing Operations
Location: Remote

Tell us about your department:
The CRM Operations team is responsible for managing email, direct mail, text, and push customer communications. Positions in other companies may refer to the team as Campaign Operations or Marketing Operations.

Project Description:
This project entails supporting the data needs for marketing communications utilizing our marketing tools to prepare customer data for those communications. Our tools include Unica and MessageGears but if someone is familiar with other marketing tools they will be able to understand and learn the tools that we use. This project will also involve writing complex SQL code against multiple databases. Working with customer data is a core function of this project.

The project DOES NOT involve database administration duties, data science duties, marketing strategy duties, backend analytic reporting duties, or analytic model building duties. Individuals that have focused their career on the types of duties above may not find this position challenging as it does not require the duties mentioned above.

Position Summary/Job 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 of our 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.

Key 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.

Skills Overview:
• 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.

What are some preferred/nice to have skills the manager is looking for?
Preferred Qualifications
• At least 3 years experience with Campaign Management Applications/Software
• 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

#DICE
nkraft@c4techservices.com

  • SQL server Database Developer

    3 weeks ago

    Richfield, United States Diverse Lynx Full time

    Title: SQL server Database Developer Location: Richfield, MN Duration: Contract Job description: Must have: Top-3Deep knowledge of Relational Databases, Microsoft SQL server and proficient in T-SQL, SSIS and SSRS. (10+ years of experience) Design and Development of high-quality OLAP and OLTP database solutions, Data Warehousing Optimization and Performance...

  • Senior React Native Developer IV

    4 days ago

    Richfield, United States C4 Technical Services Full time

    Mobile Developer IV (React/React Native)Location: Richfield, MN (Mostly remote work schedule) Tell us about your department:We are part of Understanding and Deciding sub-org under Commerce & Category org under in DAT. We are the team who owns PDP (Product detail page), Reviews and Compare on both Web & App. Project Description:This candidate will be part of...

  • Developer (Specialty) IV

    1 week ago

    Richfield, United States TALENT Software Services Full time

    Tell us about your department: We are team of with skillsets ranging from cloud infrastructure to infrastructure platform management to application development. The team's responsibilities include both development and operations (DEVOPS) related to commonly used Engineering Tools. Project Description: Tools Platform is a Kubernetes based hosting...

  • Front End Developer IV

    2 weeks ago

    Richfield, United States Inabia Software & Consulting Inc. Full time

    What are the top five skills and number of years of experience required to perform this job? 8+ years of Front end/ Fullstack design and development Comfortable in TDD, BDD development using tools such as Mocha, Enzyme, Jasmine. Proficiency with Object Oriented Design principles and patterns Solid experience with JavaScript/ TypeScript /Node.js Etensive...

  • Front End Developer IV

    1 month ago

    Richfield, United States Inabia Software & Consulting Inc. Full time

    Job DescriptionJob DescriptionWhat are the top five skills and number of years of experience required to perform this job?8+ years of Front end/ Fullstack design and developmentComfortable in TDD, BDD development using tools such as Mocha, Enzyme, Jasmine.Proficiency with Object Oriented Design principles and patternsSolid experience with JavaScript/...

  • Front End Developer IV

    1 month ago

    Richfield, United States Inabia Software & Consulting Inc. Full time

    Job DescriptionJob DescriptionWhat are the top five skills and number of years of experience required to perform this job?8+ years of Front end/ Fullstack design and developmentComfortable in TDD, BDD development using tools such as Mocha, Enzyme, Jasmine.Proficiency with Object Oriented Design principles and patternsSolid experience with JavaScript/...

  • .net/C# Developer

    7 days ago

    Richfield, United States Experis Full time

    Sr .Net Developer Remote / Richfield OH $80- $85/hr on W2 MUST HAVE SKILLS, Per AM: - DELPHI, Strong C# /.Net experience - SQL /MS SQL Server - Powershell - Experience with API development and test automation tools - independent worker/self-starter Nice to have: - Atlassian Stack (JIRA, Bitbucket, Bamboo) - Hybrid and Public Cloud: PCF, GCP or AWS -...

  • .net/C# Developer

    6 days ago

    Richfield, United States Manpower Group Inc. Full time

    Sr .Net Developer Remote / Richfield OH $80- $85/hr on W2 MUST HAVE SKILLS, Per AM: - DELPHI, Strong C# /.Net experience - SQL /MS SQL Server - Powershell - Experience with API development and test automation tools - independent worker/self-starter Nice to have: - Atlassian Stack (JIRA, Bitbucket, Bamboo) - Hybrid and Public Cloud: PCF, GCP or AWS -...

  • Java Backend Developer

    4 days ago

    Richfield, United States TWO95 International Full time

    - Design, build, test, and deploy highly scalable customer facing RESTful APIs that can handle traffic and mobile apps - Collaborate with Product and Engineering leadership to translate business vision into technical design, code and test suite - Partner with other engineers to produce high quality software - Gain a broad understanding of the system/domain...

  • Senior Java Full Stack Developer- Richfield, MN- Hybrid Model

    2 weeks ago

    Richfield, United States Dice Full time

    Dice is the leading career destination for tech experts at every stage of their careers. Our client, Javen Technologies, Inc, is seeking the following. Apply via Dice today! Greetings from Javen Technologies Inc.!!! Direct Client requirement... Job Title: Senior Java Full Stack Developer- IV Location: Richfield, MN- Hybrid role Duration: 8 months contract...

  • Oracle Database Administrator

    4 days ago

    Richfield, United States HealthPartners Full time

    HealthPartners is currently hiring for an Oracle Database Administrator. This role develops solutions within HealthPartners predefined database architecture. This position works closely with application developers to identify needs and set up appropriate pipelines to maintain the effectiveness and efficiency of the database. The engineer is responsible for...

  • QA Lead

    2 weeks ago

    Richfield, United States Diverse Lynx Full time

    • dvanced competence with Selenium using C# preferred, OR other structured OOP (JAVA) language experience required. • Strong experience with Automation frameworks and/or tools such as BDD specflow/ POM , or JAVA Karate framework. • Strong experience in testing and automating Dot Net core applications developed in C# with SQL server back end. •...

  • Sr. Product Manager, AI Powered Notebooks

    4 days ago

    Richfield, United States Databricks Full time

    At Databricks, we are passionate about enabling data teams to solve the world’s toughest problems — from making the next mode of transportation a reality to accelerating the development of medical breakthroughs. We do this by building and running the world’s best data and AI infrastructure platform so our customers can use deep data insights to improve...

  • EpicHealth Informatics Analyst

    5 days ago

    Richfield, United States HealthPartners Full time

    HealthPartners is currently hiring for an Epic Health Informatics Analyst. The analyst is responsible for driving the adoption and use of data and analytic services and products to positively impact the health, costs, and experiences, or our patients and members. It works within collaborative scrum teams consisting of developers, data scientists, and data...

  • .Net Tech Lead

    3 weeks ago

    Richfield, United States Diverse Lynx Full time

    .Net Tech Lead *Onsite Day 1: Richfield, MN (Hybrid - 3 days in office)* # of Positions: 1 Experience: 10+ years Required Skills: .Net, .Net Core, SQL, SSRS, Angular (Looking for Candidate who has worked on Development only and worked all the latest .NET Technologies) Nice to have skills: Angular Lead/.Net Architect exposure Roles & Responsibilities:...

  • EpicHealth Informatics Analyst

    5 days ago

    Richfield, Minnesota, United States HealthPartners Full time

    HealthPartners is currently hiring for an EpicHealth Informatics Analyst . The analyst is responsible for driving the adoption and use of data and analytic services and products to positively impact the health, costs, and experiences, or our patients and members. It works within collaborative scrum teams consisting of developers, data scientists, and data...

  • EpicHealth Informatics Analyst

    4 days ago

    Richfield, United States HealthPartners Full time

    HealthPartners is currently hiring for an Epic Health Informatics Analyst. The analyst is responsible for driving the adoption and use of data and analytic services and products to positively impact the health, costs, and experiences, or our patients and members. It works within collaborative scrum teams consisting of developers, data scientists, and data...

  • QA Tester

    6 days ago

    Richfield, United States Procom Full time

    QA Tester Intro:We are seeking a highly skilled and experienced QA Tester to join our dynamic team. This senior-level position is designed for a professional with a strong background in both automated and manual testing methodologies. The successful candidate will work remotely, collaborating closely with agile teams consisting of developers, testers,...

  • QA Tester

    7 days ago

    Richfield, United States Mindlance Full time

    Duration: 0-12 month(s) Description/Comment: Strong experience with manual testing and building test cases for manual testing. Must be comfortable with MS SQL and running queries that will stage data for testing scenarios. Strong initiative to learn the product that we're testing and become an expert user with the application. Experience with JIRA (story...

  • Senior Quality/Performance Engineer

    5 days ago

    Richfield, Minnesota, United States HealthPartners Full time

    HealthPartners is currently hiring for a SeniorQuality/Performance Engineer . The Quality/Performance Engineer provides stability and resilience and quality engineering expertise while supporting the delivery of high quality software to meet business needs. The engineer's responsibilities are focused on creating performance testing strategies and leading the...