Data Analytics Engineer II
Builds and optimizes SQL reports, Power BI dashboards, and data models for Missouri LAGERS, a public pension system, partnering with business stakeholders to deliver accurate, governed analytics that drive decision-making. Hybrid role based in Jefferson City, MO paying $88,606-$106,328.
- Compensation
- $88.6K–$106.3K / yr
- Location
- Jefferson City, MO
- Work setup
- Hybrid
- Seniority
- Middle
- Employment
- Not specified
- Experience
- Not specified
- Category
- Data analytics
- Posted
Skills
Must have
- 3-5 years of experience in data engineering, analytics, or related field (or equivalent combination of education and experience)
- Develop and optimize SQL reports and queries
- Implement and maintain scalable data models, warehouses, and analytics platforms
- Ensure data integrity, accuracy, and security via quality assurance and governance standards
- Collaborate with business users to gather requirements and translate them into data solutions
Nice to have
- Bachelor's degree in data science, computer science, or related field
- Develop dashboards, reports, and visualizations (Power BI preferred)
- Contribute to best practices for data management, analytics, and reporting
Full description
Data Analytics Engineer II
Joining the Missouri LAGERS, team as a Data Analytics Engineer II offers the opportunity to leverage your experience to develop analytics solutions and deliver actionable insights that drive informed decision-making. This position focuses on developing and optimizing SQL queries, reports, dashboards, and data models; improving data quality, consistency, and accessibility; and maintaining data definitions, documentation, and governance standards to ensure accurate, reliable organizational reporting.
As a Data Analytics Engineer II, you will partner with business stakeholders and IT team members to assess reporting needs, identify opportunities for meaningful analysis, and translate business requirements into practical, effective reporting solutions. Success in this role requires strong analytical and problem-solving skills, a commitment to data accuracy, and a proactive approach to improving reporting processes, operational efficiency, and the organization’s overall analytics capabilities.
LAGER’s vision is to enhance the lives of our 83,000+ members by providing financial stability for their future through a protected, defined benefit retirement. Our team members value excellence, embody dedication and exemplify leadership. We work together, take ownership of our actions, and thrive in an environment of continuous improvement.
Salary: $88,606 to $106,328 starting annual salary is negotiable and will depend on experience and identified value brought to the organization.
LAGERS benefits include:
- Hybrid work environment with collaborative in-office days and work-from-home days as designated.
- 12 paid holidays per year.
- Annual Leave: Starting at 15 days per year.
- Sick Leave: 15 days per year.
- Health insurance options effective DAY 1 of your employment.
- Vision, Dental, Life, Long-term Disability, and IDShield protection for you on
- DAY 1 of your employment.
- Defined Benefit Retirement Plan providing lifetime monthly retirement benefits at no cost to you.
- Deferred Compensation Plan with employer match.
- Professional development reimbursements and more…
Data Analytics Engineer II Job Functions:
- Develop dashboards, reports, and visualizations to present insights in a clear and actionable manner. (Power BI preferred)
- Implement and maintain scalable data models, warehouses, and analytics platforms.
- Ensure data integrity, accuracy, and security by applying quality assurance and governance standards.