SQL Consultant with Chatbot and SSIS experience

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 12 Month(s)

Skills

Data Science
Database
Scratch
SQL
Database Administration
Chatboat
SSIS

Job Details

Role: SQL Consultant with Chatbot and SSIS experience
Location: Charlotte, NC (onsite 3x a week)
Contract/contract to hire and Contract Length: 12-18 months

Note: SQL Consultant with Chatbot experience. Need someone with experience creating both SQL Queries and SSIS packages

1) Top 3 requirements:
a. 7+ years experience as a SQL DBA/Developer with Hands on expertise in advanced SQL queries (creating objects for SSIS packages, etc.)
b. Experience with database design, transactions, building data sets, etc.
c. Mentorship mindset/ability (can do code reviews and upskill junior team members)
d. Experience working with Chatbot data (Amelia would be the win, but another chatbot technology would be okay)
2) Nice to have
a. Data Science background
b. Python
c. Angular
d. PowerBI

Day to Day Responsibilities/project specifics:
Working on the team that handles all the data coming from the Erica for Employees chatbot (amongst other things) they own the logic, collect the data, organize it, and present it to execs and tech teams. Candidate must be able to do advanced SQL queries (maintenance, creating indexes, optimizing query sets) as well as digging into the data logic and anomalies in incoming chatbot data.
Screening questions:
What does/did your team look like? (He wants to know how much of the work the candidate actually did vs what their peers did)
Describe your role at your most recent project/workplace.
o Did you create the queries from scratch or just optimizing?
o What did the code look like (he wants specific examples vs someone describing someone else's work)
How would you approach designing a database schema for a new application?
Define your ETL experience with creating objects for SSIS packages.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.