Qualifications and Responsibilities

• Demonstrates leadership, self-motivation, problem-solving, and excellent written and verbal communication skills.
• Works independently as a self-starter as well as in collaboration with a team in a fast-paced environment.
• Designs and develops ETL pipelines to integrate various sources of data, including Excel, Flat Files and REST API sources into MSSQL Server using SQL Server Integration Services (SSIS).
• Utilizes critical thinking and creativity in coordination with stakeholders in the development of T-SQL Database Solutions to meet various business requirements.
• Creates and maintains reports using SQL Server Reporting Services (SSRS).
• Monitors SQL Server Agent jobs, diagnosing problems and implementing resolutions as needed.
• Improves and maintains existing database solutions.
• Provides operational support, investigating problems that arise in database solutions and business applications.
• Identifies new technologies and resources to improve the information and technology landscape.
• Maintains reference and standards documentation.
• Troubleshoots issues with Access Databases and Google forms.
• Knowledge in C#, XML and JSON.

Skills, Experience, and Education

• BS or MS in Computer Science or Information Systems, or comparable professional experience.
• 5+ years of experience in an MSSQL environment with strong working knowledge of Microsoft SQL Server 2017 and later.
• Proficient in T-SQL programming.
• Proficient in the use of MSSQL tools, including SQL Server Management Studio, SSIS, SSRS.
• Working understanding of Microsoft Access and Microsoft VBA.
• Knowledge of API creation a plus.
• Familiarity in working with MySQL databases.
• Experience with Microsoft Azure a strong plus.
• Strong working knowledge of relational database design and best practices.

Job Type: Full-time

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Schedule:

• Day shift

Experience:

• SSIS: 5 years (Preferred)
• SQL Server Management Studio: 5 years (Preferred)
• SSRS: 5 years (Preferred)
• C#: 1 year (Preferred)
• XML: 1 year (Preferred)
• JSON: 1 year (Preferred)

Ability to Commute:

• Burnham, IL 60633 (Required)

Ability to Relocate:

• Burnham, IL 60633: Relocate before starting work (Required)