Analytics Engineer II
About The Position
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
- 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.
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
Responsibilities
- Design and maintain robust data models
- Develop reusable transformation frameworks
- Create reliable data pipelines that support both batch and near real-time use cases
- Contribute to and enhance CI/CD processes
- Implement best practices in orchestration and testing
- Support cutting-edge capabilities such as LLM-enabled applications, RAG systems, and vector data workflow solutions
- Mentor junior team members and driving technical excellence across projects
Benefits
- Competitive rewards
- Top-tier benefits
- Career growth opportunities
- Flexible work options that promote balance
- Tuition reimbursement
- Wellness perks
- 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
- Company-paid life insurance and disability
- Professional growth and development opportunities
- Employee recognition and well-being programs
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
501-1,000 employees
