Analytics Engineer II

Advanced Analytics Department This opportunity is in the Advanced Analytics department. 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. Qualifications Education Bachelor's degree in Engineering, Computer Science, Artificial Intelligence, Information Systems, Data Analytics, or a related field is preferred. Required Qualifications 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 This position allows for a hybrid work schedule which includes a minimum of 3 days per week in our St. Louis Corporate Office, located at 1832 Schuetz Rd. Saint Louis, MO. All employees are required to submit work from home requests and follow our Work From Home policy, which will be provided to all candidates selected to interview. Preferred Qualifications 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 Protect the confidentiality, integrity and availability of information and technology assets against unauthorized disclosure, destruction and/or alteration, in accordance with Safety National policies, standards, and procedures. Benefits Safety National is a leading specialty insurance and reinsurance provider. Our culture is built upon relationships, which allow us to demonstrate our expertise gained through our rich 80-year history. As a wholly-owned subsidiary of Tokio Marine, Inc., we appreciate the benefits and support provided by our affiliation with one of the top 10 insurance companies in the world. In our vision to be First with Co‑Workers, compensation that includes base salary, holiday bonus, and incentive awards is only a small portion of the comprehensive total rewards package we offer. Our total rewards approach recognizes and rewards the time, talents, efforts and results of our valued employees. Highlights of our exceptional benefits include generous health, dental, and vision coverage, health savings accounts, a 401(k)-retirement savings match and an annual profit sharing contribution. We proudly offer family forming benefits for adoption, fertility, and surrogacy, generous paid time off and paid holidays, paid parental and caregiver leave, a hybrid work environment, and company-paid life insurance and disability. To support employees in their career journeys, we provide professional growth and development opportunities in addition to employee recognition and well-being programs. Safety National is committed to fair, transparent pay and we strive to provide competitive, market-based compensation. In our vision to be First with Co‑Workers, compensation is only a piece of the comprehensive total rewards package we offer. The target base salary range for this position is $88,000 to $113,500. Compensation for the successful candidate will consider the candidate’s particular combination of knowledge, skills, competencies, experience and geographic location. #J-18808-Ljbffr Safety National