Senior 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:

Leads the design, development, and optimization of the enterprise data warehouse and ELT processes. Responsible for defining and executing data mapping, building robust data ingestion and transformation pipelines, and designing scalable data models. Analyzes source data for quality, implements systemic improvements, and performs code reviews to ensure best practices. Defines advanced reporting needs, optimizes queries, writes lightweight applications, and collaborates with the team on data governance and asset management.

Serves as a strategic resource by providing recommendations for data strategies, leading knowledge sharing within the Data Strategy COE, and monitoring industry trends and cost implications to drive high‑performing, cost‑effective data solutions across the organization.

• Design and execute requirements for data mapping and ELT processes.
• Provide and design solution elements for data strategies and out‑of‑scope processes.
• Build data ingestion, transformation, and loading processes for the enterprise data warehouse.
• Analyze source system data for quality and design process improvement solutions.
• Develop and maintain the data model(s) for the data warehouse.
• Define and scope advanced reporting needs.
• Build views and optimize queries for visualization tools.
• Write code for lightweight applications.
• Investigate and remediate systemic data issues to ensure accuracy and reliability.
• Assists in developing and executing data governance roadmap efforts within data engineering processes.
• Provide comprehensive end‑user support and training on developed data products, fostering widespread adoption and data literacy.
• Assist the team in managing data assets.
• Perform design and code reviews to ensure best practices and standards are followed.
• Monitor industry trends, software versions, and backend tools to enhance team capabilities.
• Track cost implications of front‑end tooling and recommend cost‑effective solutions.
• Consider performance improvement implications across the tech stack and enterprise data strategy.
• Support discussions and collaboration with the Data Strategy Center of Excellence for knowledge sharing.
• Lead training on processes and tooling for the Data Strategy Center of Excellence.
• Guide the team in defining project timelines, expectations, and outputs.
• Monitor the project backlog and prioritize business needs communicated by 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 of 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 foster teamwork.
• Proficient in Microsoft Office suite applications.

#LI-DD1

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

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, .