SQL Developer

$75,000 - $95,000/Yr

Elco Mutual Life And Annuity - Lake Bluff, IL

Full-time - Entry Level

Remote - Lake Bluff, IL

About the position

We are seeking an accomplished SQL Programmer with expertise in data integration and processing. The ideal candidate will implement seamless data integration solutions for our enrollment and claims processing system, collaborating with cross-functional teams to develop and maintain sophisticated data management strategies.

Responsibilities

• Continuously exhibit and uphold company core values.
• Develop and maintain ETL packages.
• Manage monthly data loads received from various third parties.
• Create ad hoc reports for various business units.
• Facilitate the process of onboarding a new third-party interface, debugging the data.
• Learn and maintain the existing ETL interface.

Requirements

• BS in Computer Engineering, Computer Science, or related degree program from an accredited institution.
• 5+ years of IT experience as MS SQL Server Developer.
• Experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Experience in Data warehouse development; Logical and Physical Database design & development.
• Experience in working with SSIS packages, creating jobs and linked servers for MS SQL Server.
• Strong knowledge and understanding of SQL databases and Transact query language.

Nice-to-haves

• Experience in industry verticals like Insurance/Finance.
• Experience with Microsoft Power BI and other report development packages.
• Experience in writing MDX queries to work with cube data.
• Working knowledge of Secure Coding practices.
• Experience with PowerShell or similar scripting languages.
• Skilled in working with DevOps platforms like Azure DevOps.

Benefits

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Tuition reimbursement