Previous Job
Previous
SQL Developer
Ref No.: 17-09111
Location: Itasca, Illinois
Position Type:Right to Hire
Start Date: 08/15/2016
My direct client in the marketing industry has an immediate need for a Senior Database Developer to join their growing team.

Location: Itasca, IL (Chicago area)
Duration: Direct Hire or Contract-to-Hire
Salary: Open
Start Date: Immediate

Responsibilities
· Gather requirements from the business in order to create the necessary queries and related SSRS and/or Excel Pivot Table reports,
· Gather requirements from the business in order to create the necessary queries and related SSIS Packages
· Gather data and summarize it into KPI's with recommended approaches to the business based off of sample data sets.
· Assisting with QA review process.
· Database Development - creating stored procedures (T-SQL), triggers, indexes, views and queries.
· Assisting with Database Administration tasks such as database maintenance, optimization, backups, monitoring.
· Design, code, test and trouble shoot business ETL in SSIS Packages
· Provide general technical support as needed, both to other functions within the business, as well as other segments of the technology department (database design, infrastructure, compliance, etc.)
· Assist in creating Reports, as necessary.


Experience:
· Minimum 5 years' experience with MS SQL Server 2008 (including SSIS) or greater.
· Must understand how to build SSIS packages and use SSIS functionality to solve complex business problems.
· Deep experience manipulating data in a variety of formats (Excel, Text, etc.)
· Experience in Marketing is a plus
· BA/BS in Information Systems, Information Technology or Comp. Science preferred or equivalent work experience
· Must be skilled in organizing technical information based on reviewing meeting notes, business specifications, interviewing clients, architects and business analysts; Must have the ability to work effectively with clients, IT management and other team members
· Must be adept working in SQL Server environments using T-SQL with knowledge of the software development life-cycle, test scripting and deployment practices; Experience with data warehouse best practices, design, and data modeling
· Must be skilled in organizing technical information based on reviewing meeting notes, business specifications, interviewing clients, architects and business analysts; Must have the ability to work effectively with clients, IT management and other team members

Nice to Haves:
· Tableau
· Cognos Report Development
· SAP Data Services