Marketing SSIS Database Developer (Remote Eligible)

Job Locations US-MI-Livonia (Headquarters)
Category
Marketing
Type
Full-Time
Location : Address
17197 N. Laurel Park Drive
Shift
Not Applicable

Overview

Role Overview:

The SSIS and MS SQL Developer role includes SSIS ETL, Database development work and data analysis tasks involved with development and support of analytical applications, specifically SSIS, MS SQL Server, PowerBI and Azure Machine Learning. You will assist and/or be responsible for managing the design and development of our Marketing databases by writing SQL procedures, creating SSIS ETL workflows, create and maintain tables, and modify our existing reports and systems as needed. This position may work in a hybrid space at our office in Livonia, MI or fully remote.

Responsibilities/Qualifications

Primary Responsibilities:

  • Develop the Marketing CRM database (MS SQL server based) by writing SQL procedures, creating tables and by building SSIS ETL workflows.
  • Drive the analysis, design, and development of databases and SSIS ETL work.
  • Develop SSIS Workflows to ingest, track and log Flat File Data movement effectively.
  • Create technical design specifications, database alerts, troubleshoot and resolve technical issues, debug, tune and optimize database performance.
  • Write procedures and SQL rules to clean up data.
  • Develop workflows and procedures to automate the data load from multiple source systems and create alerts to trigger the status of the jobs.
  • Modify the SQL of the existing PowerBI reports and write queries to create new metrics.
  • Contribute to team discussions presenting ideas, sharing knowledge, and listening to other’s ideas.
  • Assist in the development of Machine Learning algorithms, Power BI Dashboards, Tabular Data Models & other items to enhance Marketing strategies and programs.
  • Produce appropriate inline and external documentation for processes.

Skills and Qualifications:

  • Bachelor’s degree in Science or Engineering or appropriate experience.
  • 2+ years of experience in Database development and Data analysis which includes:
    • Excellent knowledge of developing ETL workflows using tools such as SSIS.
    • Strong experience in writing SQL queries on top of different data sets.
    • Thorough knowledge of creating stored procedures, tables, views, functions and other data objects in MS SQL Server.
    • Working experience in data modeling and data warehousing.
  • Ability to translate business requirements to SQL and to reporting objects.
  • 2+ years of experience in designing and delivering data integration/data warehousing solutions using tools like SSIS.
  • Strong oral and written communication skills; ability to convey ideas, problems, and issues to both business and technical teams.
  • Strong organizational skills that allow the individual to handle multiple tasks while being extremely detail oriented.
  • Must be customer focused and have experience in handling customer concerns.
  • Microsoft Azure experience a plus
  • Responsys Campaign Platform and/or Crowd Twist Loyalty Platform experience a plus
  • Previous work experience with Retail Industry is a plus.
  • Exposure to Machine Learning/Predictive Modeling is a plus
  • Marketing Data Warehousing experience is a plus

About Pet Supplies Plus

Pet Supplies Plus is focused on making it easier to get better products for your pet. With 650 locations in 40 states, the stores have a streamlined design making it easy to navigate a wide assortment of natural foods, hard goods and pet services. Friendly, knowledgeable staff get to know each pet and their owner by name and provide playful store experiences to remind them just how fun it is to own a pet. Pet Supplies Plus stores are large enough to house an incredible variety of food and equipment, yet small enough to still feel neighborly.

Pet Supplies Plus is ranked No. 20 overall in Entrepreneur Magazine's 2022 Franchise 500® list and is the Top Full-Service Pet Supplies Franchise for its exceptional performance in areas including financial strength and stability, growth rate and system size. For more information, please visit www.petsuppliesplus.com. 

 

EOE STATEMENT

We provide equal employment opportunities to all applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, the company complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment. 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed