Senior Data Engineer

Posted Wednesday, January 14, 2026 at 11:00 AM

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:

• Designs and executes requirements for data mapping and ELT processes.
• Provides and designs solution elements for all data strategies and out of scope processes.
• Designs and builds data ingestion, transformation, and loading processes for the enterprise data warehouse.
• Analyzes data in source systems to assess data quality and design process improvement solutions for addressing within the source systems or as part of the ELT process.
• Designs and participates in the development of the data model(s) for the data warehouse.
• Defines and scopes advanced reporting needs.
• Builds views and optimizes queries for visualization tools.
• Writes code for light-weight applications.
• Investigates and identifies systemic data issues ensuring data accuracy and reliability.
• Assists in development and execution of data governance roadmap efforts within data engineering processes.
• Provides comprehensive end-user support and training on developed data products, fostering widespread adoption and data literacy.
• Assists the team in management of data assets.
• Performs design and code reviews to ensure best practices and standards are being followed by all team members.
• Monitors and learns about the latest data industry trends, software versions, and back-end tools to enhance capabilities.
• Tracks the cost implications of front-end tooling and provides recommendations regarding cost effective solutions to business and reporting needs.
• Identifies and considers the implications and decisions for performance improvement by being aware of overall tech stack and enterprise data strategy.
• Supports conversations and collaboration with the Data Strategy Center of Excellence for team knowledge sharing.
• Supports training on processes and tooling for the Data Strategy Center of Excellence.
• Guides the team in defining project timelines, expectations, and outputs.
• Monitors the project backlog and prioritizes the business needs communicated from stakeholders.

• Bachelor's Degree in IT Management, Computer Science, Data Science, Engineering, or a related field; or an equivalent combination of education and experience
• Five (5) or more years of requirements gathering, data analysis, report development, or related experience
• One (1) or more years of Insurance industry experience

• Advanced knowledge of SQL, Python, and relational databases
• Advanced knowledge in system integrations and database structures
• Excellent verbal and written communication skills
• Sharp analytical and problem-solving skills
• Strong ability to manage multiple projects simultaneously and adapt to rapidly changing priorities
• Proven ability to work in a team and to foster teamwork
  
  Proficient in Microsoft® Office suite applications

#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 and let us know the nature of your request and contact information.

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