Senior Data Engineer (34454)

Who We Are

At KLS Martin, we offer a unique opportunity to contribute to the success of a dynamic and thriving company whose products are used daily across the world to help surgical patients.

The KLS Martin Group is a worldwide leader in creating surgical solutions for the craniomaxillofacial and cardiothoracic fields. Surgical innovation is our passion, and we are constantly working with surgeons to improve surgical care for their patients. Our product portfolio includes titanium and resorbable implants for reconstruction, innovative distraction devices to stimulate bone lengthening, over 4,000 surgical instruments, and other surgical products designed specifically for CMF and cardiothoracic surgeons.

KLS Martin is an innovative leader in the treatment of CMF deformities and trauma cases. We use Individual Patient Solutions (IPS) by using our proprietary IPS products where CT scans are used to custom design implants that are created specifically for that individual patient. This technology allows our surgeons to provide the best-in-class treatment for their patients.

KLS Martin Guiding Principles

• Established, Privately Held Business Group – Responsive to customers, not shareholders. KLS Martin has manufactured medical products since 1896, and we have sold our products in the United States under the KLS name since 1993. We have always been, and always will be, privately owned.
• Patient Focus – We design products with the patient in mind – CMF, Thoracic & Hand
• Product to Table – Integrated planning, design, manufacturing and distribution process
• Educational Partner – Our primary focus for support is on education
• Inventory Alliance – Inventory management is critical to patient treatment/outcome
• Surgical Innovation is Our Passion – More than just a tagline

What We Offer

• We provide full-time employees with a competitive benefits package, including paid parental leave
• In-house training and professional development opportunities
• A culture of creativity and innovation by drawing on diverse perspectives and ideas to drive surgical innovation

Job Summary

This position will lead the design, evaluation, implementation, and testing of a scalable, high-performance enterprise data warehouse. In this role, you will be responsible for developing dimensional data models, ETL/ELT pipelines, and cloud-based data solutions that enable robust analytics and reporting. You will collaborate with cross-functional teams to ensure data quality, governance, and security while optimizing performance for large-scale datasets. The ideal candidate has a strong background in SQL, cloud data platforms (AWS, GCP, or Azure), and data pipeline automation and is enthusiastic about building modern data architectures and enabling data-driven decision-making.

Essential Functions, Duties, and Responsibilities

• Data Warehouse Design & Architecture
  • Lead the end-to-end design and implementation of a scalable, high-performance data warehouse.
  • Define data architecture principles, strategies, and best practices to ensure optimal performance and maintainability.
• Dimensional Modeling & Data Modeling
  • Design and implement robust dimensional models (star and snowflake schemas) to optimize analytical queries.
  • Develop conceptual, logical, and physical data models to support reporting, analytics, and business intelligence (BI).
  • Ensure data models align with business requirements and support self-service analytics.
  • Leverages existing data infrastructure to fulfill all data-related requests, perform necessary data housekeeping, data cleansing, normalization, hashing, and implementation of required data model changes.
• ETL/ELT Development & Data Pipelines
  • Design, develop, and optimize ETL/ELT pipelines to ingest, transform, and load structured and unstructured data from various sources.
  • Ensure data pipelines are scalable, efficient, and maintainable while handling large datasets.
  • Implement incremental data processing strategies to manage real-time and batch workloads.
• Data Governance, Quality, and Security
  • Establish data governance practices, including data cataloging, lineage tracking, and metadata management.
  • Implement data validation, anomaly detection, and quality monitoring to ensure accuracy and consistency.
  • Collaborate with security teams to enforce role-based access control (RBAC), encryption, and compliance standards (GDPR, HIPAA, etc.).
• Performance Tuning & Optimization
  • Optimize database performance by indexing, partitioning, caching, and query tuning.
  • Monitor and troubleshoot slow queries, ensuring efficient use of resources.
  • Analyze data to spot anomalies, trends and correlate similar data sets.
• Cloud Technologies
  • Architect and implement cloud-based data warehouse solutions (e.g., Snowflake, AWS Redshift, Google BigQuery, Azure Synapse).
• Collaboration & Cross-Functional Work
  • Work closely with business stakeholders & analysts to translate requirements into scalable data solutions.
  • Partner with software engineers and DevOps teams to ensure seamless data integration and infrastructure reliability.
• Monitoring & Incident Response
  • Establish monitoring solutions for data pipeline failures, schema changes, and data anomalies.
  • Set up logging and alerting mechanisms to proactively identify and resolve issues.
• Mentorship & Best Practices
  • Guide and mentor other members of the data team on best practices in data modeling, ETL, and architecture.
  • Define and document standards for data warehouse development, maintenance, and governance.
• Data Science & Machine Learning
  • Designs, develops, and implements statistical models to carry out various novel aspects of classification and information extraction from data.
  • Designs, develops, and implements natural language processing software modules.