Analytics Engineer II — AI-Driven Data Pipelines

Description 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: 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. 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. 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. Total Rewards That Put Employees First 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. Apply today to learn more. 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 one 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. #LI-Hybrid Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor. #J-18808-Ljbffr Safety National