Data and Analytics Engineer
Analytics
Analytics Engineer
Automation Developer
Business Analytics
Business Intelligence
Business Intelligence Tools
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Architecture
Data Engineer
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Visualization Tools
Data Viz
Data Warehouse
Database
Databases
Dataviz
Digital Marketing
ETL
Hr Technology
Informatica
Information Technology (IT)
Looker
Microsoft
Microsoft 365
Microsoft Power Platform
Power BI
Power Platform
Product Management
Reporting and Analytics
Software Development
SQL
Tableau
Visual Design
Job Description
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.