Jobs
>
Minneapolis

    SQL Developer IV - Minneapolis, United States - C4 Technical Services

    Default job background
    Description

    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

  • Synechron

    SQL Developer

    1 week ago


    Synechron Minneapolis, United States

    Job Title: SQL Developer · Location: Minneapolis, Minnesota, United States · Contact to : · Summary: · As a SQL Developer, you will collaborate with stakeholders across the business to work on complex technical requirements. You will be responsible for managing multiple engagem ...

  • Blue Star Partners LLC

    SQL Developer

    3 weeks ago


    Blue Star Partners LLC Minneapolis, United States

    Job Description · Job DescriptionJob Title: SQL Developer · Location: Local to Minneapolis candidates only – required to be onsite 3 days/week · Start Date: ASAP Duration: Now - Through December 31, 2024 · Hours/Week: 40 hours · Rate: $70 - $80/hr · Contract Type: W2 Only (No 10 ...

  • Chelsoft Solutions Co

    SQL Developer

    2 weeks ago


    Chelsoft Solutions Co Minneapolis, United States

    Job Description · Job DescriptionSQL/Server Developer Scrum Team. This individual will be a member of the Scrum Team. There is not much additional information as the job description was created specifically for this role. It is up to date and very detailed. · The top qualificati ...

  • Synechron

    SQL Developer

    1 week ago


    Synechron Minneapolis, United States

    Job Title: SQL Developer · Location: Minneapolis, Minnesota, United States · Contact to : · Summary: · As a SQL Developer, you will collaborate with stakeholders across the business to work on complex technical requirements. You will be responsible for managing multiple eng ...


  • Lorven Technologies Minneapolis, United States C2C, W-2

    Role: SQL Server Developer with ERWin Data Modeling · Location: Minneapolis, MN- Hybrid role- 3 Days Onsite · Skills: ERWin, SQL Server and/or UDB, SQL Server, UML, XML · Job Description: · We are seeking a skilled SQL Server Developer with ERWin Data Modeling to join our te ...


  • U.S. Bancorp Minneapolis, United States

    U. S. Bank is seeking two innovative and detailed oriented SQL Developer / Financial Analysts to support and enhance data applications/processes within Finances Business Intelligence - Management Reporting Operations (MRO) group. The position is pri Financial Analyst, Developer, ...


  • JobRialto Minneapolis, United States

    Job Description: · The client, is seeking Senior SQL Database Developers for a long-term project. The focus is on modernizing and stabilizing their database systems as the department undergoes restructuring, particularly in the Financial Operations Division. · The ideal candida ...

  • The Judge Group Inc.

    SQL Developer

    5 days ago


    The Judge Group Inc. Minnetonka, United States

    Location: Minnetonka, MN · Salary: $85,000.00 USD Annually - $90,000.00 USD Annually · Description: · Software Engineer (APIs and Vendor Application Support) · We are seeking an experienced Software Engineer to join our team. In this role, you will be responsible for supporti ...


  • Accord Technologies Inc. Minneapolis, United States

    Job Description · Job DescriptionTitle: SQL Server Developer with Data Modeling/ETL · Location: Minneapolis, MN (Need Onsite day 1, Hybrid 3 days from office, No Remote). · Need Local Candidates Based in Minneapolis, MN. · position type: W2 contract. Job Description: · SQL Serve ...


  • Adameservices Minneapolis, United States

    Job Title: SQL Developer with Data Modeling Expertise · Location : Minneapolis, MN · Job Description · We are seeking a highly skilled and motivated SQL Developer with a strong background in data modeling, specifically using ERwin. In this role, you will play a crucial part in ...


  • Dice Minneapolis, United States

    Dice is the leading career destination for tech experts at every stage of their careers. Our client, Thronus Group LLC, is seeking the following. Apply via Dice today · Title: · SQL Server Developer with Data Modeling/ETL . · Location: Minneapolis, MN (Need Onsite day 1, Hybri ...

  • Constellation Search Group

    SQL Report Writer

    3 weeks ago


    Constellation Search Group Minneapolis, United States

    Title: SQL Report Writer · Location: Minneapolis, MN · Compensation: 60 to 80k · Type: Direct · We are seeking a skilled SQL Report Writer to join our dynamic team. The SQL Report Writer will be responsible for developing and maintaining reports using SQL queries to extract and p ...


  • eTeam Minneapolis, United States

    Job Title- Software Developer - .Net · Duration- 6 Months (Possibly C2H) · Hybrid- 3 days onsite is needed. · Primary locations - Minneapolis and New Jersey.Atlanta GA as a backup location(Team in Minneapolis is coming three days between Monday and Thursday, Team in New Jersey is ...

  • VySystems

    Data Engineer

    1 week ago


    VySystems Minneapolis, United States

    Primary Skills: PySpark, Azure DataFactory, Databricks, SQL · Secondary Skills: DBT, Snowflake · Role Responsibility: · Data Engineer with 5-8 years of experience · Must have good experience in pyspark programming and SQL scripting · Translate business requirement document, funct ...


  • Equity Staffing Group Plymouth, United States

    Contract to hire opportunity with a leader in the energy space. The role will initially be a contract, with the goal of having someone come on full time after 3-6 months. · Target salary after contract is $110-120k · **Please note, this role will be onsite 4 days/week with one re ...


  • programmers Minneapolis, United States

    Overview: · We are looking for an Integration Engineer with Rhapsody Integration Engine development experience. The candidate should have strong HL7 and healthcare integration expertise. Below are the complete skill sets required to be a suitable candidate for this role. · Qualif ...

  • Noir

    NET Developer

    2 days ago


    Noir Minneapolis, United States Full time

    NET Developer, C#, WPF - Leading Manufacturing Company - Minneapolis, Kansas · (Tech stack: .NET Developer, C#, SQL, RESTful APIs, HTML, CSS, JavaScript, Agile, Programmer, Engineer, Architect, .NET Developer) · About the Company: · Our client is one of the foremost manufacturing ...


  • INSPYR Solutions Minneapolis, United States

    Senior .NET and UI Developer - Long Term Project - Remote (US/CA based) · ABOUT THE ROLE: · Our Client's IT software development and engineering program is building applications and developing discrete functions of our systems as well as converting our legacy data to our new sys ...


  • Voya Financial Minneapolis, United States Full time

    We will do this together — with customers, partners and colleagues. We will fight for others, not against: We will stand up for and champion everyone's access to opportunities. The status quo is not good enough ... we believe every individual and every community deserves access t ...


  • Fractal, Inc. Minneapolis, United States

    Senior Azure Data Engineer · Fractal is a strategic AI partner to Fortune 500 companies with a vision to power every human decision in the enterprise. Fractal is building a world where individual choices, freedom, and diversity are the greatest assets; an ecosystem where human im ...