Data and Analytics Engineer

The Data and Analytics Engineer develops and supports the company’s data and analytics environment across the full data lifecycle. This role combines data engineering, business intelligence, and analytics to deliver dependable data, usable dashboards, and decision-support capabilities for internal teams.

Core Responsibilities

• Design, build, and maintain scalable data pipelines and automated workflows to extract, ingest, integrate, and process data from multiple sources, including applications, APIs, databases, and external systems.
• Develop and maintain data warehouses, data lakes, and related data platforms that enable reliable, efficient, and accessible storage and analytics.
• Implement data quality tests, document data definitions, optimize SQL queries, and manage dependencies between data models to support accuracy, consistency, and performance.
• Monitor pipeline performance, data freshness, and reliability; troubleshoot failures; and manage data security, access controls, and infrastructure costs.
• Respond to inquiries submitted through the Data Team Help Line by troubleshooting and resolving day-to-day system and data-related issues to support operational efficiency and data accuracy.
• Partner with business stakeholders to understand needs and deliver actionable data products.
• Contribute to internal documentation, playbooks, and knowledge-sharing to strengthen team practices.
• Stay current on tools and methods, recommending improvements to platforms, processes, and governance.
• Transform raw warehouse data into clean, structured, and reusable datasets used to build and maintain BI dashboards, reporting, and analytical initiatives.
• Perform predictive analytics and statistical analysis to identify trends, forecast outcomes, and generate actionable insights for data-driven decision-making.
• Follow and adhere to the DMP Data Classification Standard.

Required Qualifications

• Bachelor’s degree in computer science, data science, information systems, or a related field, or equivalent professional experience.
• 3+ years of experience in analytics engineering, data engineering, BI development, or a closely related role.
• Demonstrated experience building and maintaining data pipelines, models, and BI solutions in production environments.
• Experience working cross-functionally with business teams to translate requirements into data products.
• Proficiency in SQL for data modeling, transformations, and performance optimization.
• Experience working with APIs for data ingestion, integration, and automation.
• Familiarity with medallion/lakehouse architectures and transformation pipelines (Bronze, Silver, Gold).
• Strong skills in BI and data visualization tools such as Power BI, Tableau, Domo, Looker, or equivalent platforms.
• Experience with version control tools (such as Git) and modern data development practices.
• Experience administering BI platforms, including governance, permissions, and content management.
• Knowledge of data governance, metadata management, and data quality practices.
• Ability to communicate technical concepts clearly to non-technical audiences.
• Strong problem-solving skills and comfort taking ownership across the full data lifecycle.
• Ability to develop and execute complex research projects with minimal supervision.

Technologies

• SQL
• Python
• APIs
• Power BI
• Tableau
• Domo
• Looker
• Git

Location and Experience

Location: Springfield, MO (onsite)

Minimum Experience: 3 years

Benefits

• Onsite medical clinic for employee, spouse and family members 18 and under living at home
• Medical
• Dental
• 401k
• Life Insurance
• Short and Long Term Disability
• Paid vacation/holidays
• Free security system
• Free UPS shipping

About the Role

The Data and Analytics Engineer plays an important role in developing and supporting the company’s data and analytics environment. The position works across data engineering, business intelligence, and analytics to manage the full data lifecycle, from collecting and transforming data to building dashboards, maintaining BI platforms, and helping employees use data effectively.

Team Overview

This position is with an established company with more than five decades of experience in security manufacturing. The role supports efforts to improve how information is collected, managed, and used across the business, helping strengthen a more data-driven organization.