The Data and Analytics Engineer develops and supports the company’s data and analytics environment across the full data lifecycle, from collection and transformation to dashboards and ongoing platform maintenance.
Location
Springfield, MO (onsite)
Key Responsibilities
- Design, build, and maintain scalable data pipelines and automated workflows to extract, ingest, integrate, and process data from applications, APIs, databases, and external systems.
- Develop and maintain data warehouses, data lakes, and related data platforms to 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.
- Handle inquiries submitted through the Data Team Help Line, troubleshooting and resolving day‑to‑day system and data‑related issues.
- 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 to support BI dashboards, reporting, and analytical initiatives.
- Perform predictive analytics and statistical analysis to identify trends, forecast outcomes, and generate actionable insights.
- 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 or lakehouse architectures, including development of transformation pipelines (Bronze, Silver, Gold).
- Strong skills in BI and data visualization tools such as Power BI, Tableau, Domo, Looker, or equivalent platforms.
- Experience using 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 clearly communicate technical concepts 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
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
This position works across data engineering, business intelligence, and analytics to manage the full data lifecycle, including collecting and transforming data, developing dashboards, maintaining BI platforms, and supporting employees in using data effectively.
Why Join the Team
This is an opportunity to contribute to an established company with more than five decades of experience in security manufacturing, improving how information is collected, managed, and used across the business.