Analytics Engineer II

Safety National•Saint Louis, MO

1d•$88,000 - $113,500•Hybrid

About The Position

At Safety National, we don’t just offer jobs – we build careers with purpose! Since 1942, we’ve been an industry leader, valuing integrity, teamwork, and stability while providing competitive rewards, top-tier benefits, career growth opportunities, and flexible work options that promote balance. With tuition reimbursement, wellness perks, and a strong community impact, we invest in your success—both personally and professionally. Ready to grow with us? Apply today! Follow this link to view all of our available careers and apply: https://www.safetynational.com/careers-page/ This opportunity is in the Advanced Analytics department. Interested in building data products that power advanced analytics and AI? Our Advanced Analytics department seeks those passionate about using data to tell business stories, inform decision making and solve business problems. If you are a curious professional with education or experience in data science, artificial intelligence, statistics, and machine learning, this is an excellent opportunity to be part of a highly impactful, innovative and diverse team. Role Description: As an Analytics Engineer II, you will play a key role in building and scaling the data foundation that powers advanced analytics and AI initiatives across the organization. You’ll design and maintain robust data models, develop reusable transformation frameworks, and create reliable data pipelines that support both batch and near real-time use cases. Working closely with Data Scientists, AI Engineers, IT, and business stakeholders, you will help bring complex analytical solutions to life in production environments. In this role, you will contribute to and enhance CI/CD processes, ensuring efficient deployment, monitoring, and lifecycle management of data products and AI-enabled systems. You’ll contribute to architectural decisions, implement best practices in orchestration and testing, and support cutting-edge capabilities such as LLM-enabled applications, RAG systems, and vector data workflow solutions. Your work will directly impact the organization’s ability to leverage data for strategic insights, while also mentoring junior team members and driving technical excellence across projects.

Requirements

3 or more years of experience supporting production data systems or analytics platforms or an equivalent combination of education and experience
Advanced SQL proficiency including the ability to write complex queries
Strong Python programming skills
Experience designing scalable data models
Experience building orchestration workflows for batch and/or streaming pipelines
Experience implementing data quality checks, testing frameworks, or observability practices
Experience working in Git-based environments and CI/CD pipelines
Strong communication and stakeholder management skills
Must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by our company for this position now or in the future

Nice To Haves

Experience with Snowflake or similar cloud-native data platforms
Experience with dbt or similar data transformation frameworks
Exposure to cloud platforms such as Azure, AWS, or GCP
Experience with distributed processing tools (e.g., Spark)
Familiarity with vector databases and AI deployment architectures
Experience working in insurance or other regulated industries

Benefits

generous health, dental, and vision coverage
health savings accounts
a 401(k)-retirement savings match and an annual profit sharing contribution
family forming benefits for adoption, fertility, and surrogacy
generous paid time off and paid holidays
paid parental and caregiver leave
a hybrid work environment
company-paid life insurance and disability
professional growth and development opportunities in addition to employee recognition and well-being programs
tuition reimbursement
wellness perks