MS SQL Developer

Join ELCO Mutual, a stable and growing Lake Bluff life insurance company with over 75 years of experience in life insurance and annuities. We have doubled our size since 2020 and need a motivated and experienced MS SQL Programmer to serve our growing employee base. This family-oriented business understands the importance of work life balance and providing opportunities for our employees to stretch to reach their potential.

Position Summary

The MS-SQL Developer will be responsible for designing, implementing, and managing database systems and reporting solutions within the life insurance domain. The ideal candidate will have a strong background in SQL development, data modeling, and experience with MS reporting tools like SSIS and SSRS.

Job Responsibilities:

• Design, develop, and maintain MS-SQL databases, ensuring optimal performance and reliability.
• Create and manage data models to support reporting and analytical needs within the life insurance sector.
• Develop, test, and deploy ETL processes using SQL Server Integration Services (SSIS).
• Create and manage reports and dashboards using SQL Server Reporting Services (SSRS).
• Collaborate with business analysts and stakeholders to gather requirements and deliver effective data solutions.
• Optimize SQL queries and database performance to ensure efficient data retrieval.
• Conduct data analysis and troubleshooting to resolve database issues.
• Document database designs, ETL processes, and reporting solutions for future reference and compliance.

Success Factors:

• Adaptability—the individual adapts to changes in the work environment, manages competing demands, and can deal with frequent change, delays, or unexpected events.
• Dependability—the individual is consistently at work and on time, follows instructions, responds to management direction, and solicits feedback to improve performance.
• Strong Oral / Written communication skills. The individual is comfortable when in positive /negative situations, group presentations, and meetings.
• Planning/organizing— able to prioritizes, plan work activities, demonstrates effect use of time to develop realistic action plans and workflows.
• Problem solving—the individual identifies and resolves problems in a timely manner and gathers and analyzes information skillfully.
• Quality management—the individual manages continuous improvement process to improve and promote quality and demonstrates accuracy in the business.
• Safety and security—the individual actively promotes and personally observes safety and security procedures and uses equipment and materials properly.

Qualifications:

• Bachelor’s degree in computer science, Information Technology, or a related field.
• 3-5 years of experience in MS-SQL development, preferably in the life insurance industry.
• Proficiency in SQL, T-SQL, and database design principles.
• Strong database administration experience.
• Experience with data modeling and data warehousing concepts.
• Strong knowledge of SSIS and SSRS for ETL and reporting tasks.
• Familiarity with life insurance data structures and regulatory requirements is a plus.
• Knowledge of additional database technologies (e.g., Oracle, MySQL) is a plus.
• Experience with data visualization tools (e.g., Power BI, Tableau) is a plus.
• Understanding of cloud-based database solutions (e.g., Azure SQL Database).

Physical Demands and Work Environment:

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

*Physical demands: Constant use of both hands, arms reaching handling/ grasping/fingering while keyboarding, using phone, calculator, and other office equipment, writing instructions, filing, and performing other administrative duties. Employee may occasionally lift and/or move up to 50 pounds. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception and the ability to adjust focus.

*Work Environment: The noise level in the work environment is usually minimal.

Benefits:

• Competitive Pay
• 90% company contributions towards employee health coverage and 80% company contributions towards dependent health coverage
• Dental and Life Insurance plans fully covered by ELCO
• Annual Performance Bonuses
• Paid Time Off
• 401K Contribution
• Tuition Assistance

Job Type: Full-time

Pay: $85,000.00 - $100,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Professional development assistance
• Tuition reimbursement
• Vision insurance

Compensation Package:

• Performance bonus

Schedule:

• 8 hour shift
• Monday to Friday

Application Question(s):

• Do you currently live within a 35 mile radius of Lake Bluff, IL?

Experience:

• MS SQL Developer: 3 years (Required)

Work Location: In person

Salary : $85,000 - $100,000