For over 40 years, our Orthodontics Manufacturing client has embodied exceptional quality and service. As a manufacturer, they focus on owning everything they do with a level of accountability not found elsewhere. From sourcing raw materials to final inspection, they control every step and stand behind our products with a Pain-Free Guarantee.
Located near Franklin, Indiana, they proudly design and manufacture products in the USA, and are registered to sell them in 93 countries. In addition to a global presence and the ability to scale production as needed, they are committed to fostering authentic relationships and actively solving the problems of the doctors and patients they serve.
Key Responsibilities
Are you looking to bring your mid-level SQL expertise to a dynamic environment where your insights will directly impact orthodontics operations? We are seeking a SQL Server Developer with 5 years of experience to design, develop, and maintain efficient database solutions with experience in a manufacturing environment. You will work closely with cross-functional teams-especially in the manufacturing domain-to ensure data accuracy, reliability, and accessibility. The ideal candidate will bring an "authentic ownership" approach to their work and contributions.
SQL Development: Design, develop, and optimize SQL queries, stored procedures, and functions tailored to manufacturing and production data needs.
Data Analysis: Conduct in-depth data analysis to support decision-making, focusing on identifying trends and improving manufacturing processes.
Ad-Hoc Requests: Respond to time-sensitive data requests by writing ad-hoc queries, ensuring quick turnaround and clear insights.
Collaboration: Work alongside developers, business analysts, and manufacturing stakeholders to gather requirements and build robust database solutions.
Database Integrity & Security: Implement and maintain best practices for data integrity, performance optimization, and security within a manufacturing context.
Troubleshooting: Diagnose and resolve database performance issues to minimize downtime and maximize efficiency.
Required Qualifications & Skills
Bachelor's Degree in Information Systems, Computer Science, and/or Engineering
5 Years' Experience: Demonstrable track record as a SQL Server Developer with a focus on T-SQL.
Manufacturing Knowledge: Familiarity with manufacturing processes, workflows, and related systems (e.g., ERP, production, inventory management).
Database Expertise: Solid understanding of database management, optimization techniques, and performance tuning.
Reporting & BI: Working knowledge of SSIS, SSRS, and Power BI to create and deliver actionable insights.
Analytical Mindset: Strong problem-solving skills and the ability to translate complex data into strategic business recommendations.
Team Collaboration: Excellent communication skills for working effectively with cross-functional teams and stakeholders.
Preferred Qualifications & Skills
Advanced T-SQL: Deep knowledge of T-SQL, including complex queries, indexing, and query optimization.
VB.Net: Experience developing applications or utilities using VB.Net to complement SQL solutions.
Data Visualization: Familiarity with leveraging visualization tools to make manufacturing data readily understandable.
ETL & Reporting: Advanced understanding of SSIS for ETL processes and SSRS for comprehensive reporting solutions.
Data Warehousing: Experience with data warehousing concepts, including data modeling and ETL best practices.