Data Engineer

SMS is part of the Alliant family of companies. SMS is a full-service insurance marketing organization (IMO) dedicated to helping independent insurance agents leverage time, make more money, and put their business in a position of distinction. With products and agents in all 50 states, SMS offers the industry's most complete IMO experience. We support every facet of an agent's business, from our comprehensive senior product portfolio to our technology, services, and marketing programs.

More information is available on the company's website at: www.seniormarketsales.com

SUMMARY Responsible for the design, development, and testing of object-oriented and service-oriented software applications, databases, and proprietary reporting tools specific to underwriting program needs. Provides program and underwriting support, including market research, to enhance operational and technical efficiencies and capabilities.

ESSENTIAL DUTIES AND RESPONSIBILITIES Design, develop, test, and implement business software applications in order to provide underwriters and program leaders with multi-functional reporting tools.

Design, establish, and maintain infrastructure for databases for collection of data.

Audit system processing to track and correct software errors, hardware errors, and performance issues.

Serve as a resource for general problem-solving of any program level issues in the areas of operations, efficiencies, etc.

Support the development of cross-program client services.

Participate in the research and development of program differentiators.

Provide data collection, aggregation, and research of new program opportunities.

Establish and manage the distribution of program production and profitability analysis.

Support the development of annual rate plans for each program.

Review and assist with large account placement; including evaluation of underwriting and profitability.

Assist in comparative analysis of various program guidelines and rates.

Provide competitor research and coverage comparisons.

Follow through on communications of program differentiators.

QUALIFICATIONS EDUCATION / EXPERIENCE Bachelor's Degree in computer technology or equivalent combination of education and experience

Two (2) or more years of experience in software development using object oriented languages; primary development language is C#, and other languages and protocols including R and Python.

Two (2) or more years of experience using .Net framework

Experience with carriers, MGA's, and wholesale brokerages

Experience and knowledge of SQL and VBA

Experience with designing and developing reporting and underwriting tools

SKILLS

Understanding of specific program underwriting, database infrastructure, and general data needs

Knowledge and experience with catastrophe modeling platforms including RMS and AIR

Understanding of relational database design, normalization models, and advanced understanding of SQL

Skilled in developing n-tier .NET applications in a service oriented architecture

Skilled in planning, organizational and prioritization with attention to detail

Proficient in Microsoft Office; skilled in data driven Microsoft Office document generation

Excellent verbal and written communication skills

Excellent leadership, problem solving and time management skills

Advanced analytic skills

#LI-DD1

"Successful people do those things that failures refuse to do."

Equal Opportunity Employer; SMS participates in the E-Verify system.

We are proud to provide comprehensive, high quality employee programs to meet employees' needs now and in the future, including a very competitive financial package. We encourage you to explore what we have to offer.

For immediate consideration for this position, please click on the "Apply Now" button.

Alliant Insurance Services, Inc. is an equal opportunity employer. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, age, religion, gender, sexual orientation, gender identity, national origin, disability, protected veteran status or any other protected status.

If you are applying for a job and need a reasonable accommodation for any part of the employment process, please call our Career Center at 1-877-901-9473 and let us know the nature of your request and contact information.

For more information on Alliant Insurance Service's benefits, click here.