Senior Data Engineer

About

Integrated Information Systems has been a provider of analytical, software development, and business intelligence development services to manufacturers of highly complex products in the defense and aerospace industry for over 20 years. We design and create complex decision support tools, analytics, and custom-tailored applications built on Web and Office platforms which integrate data from ERP systems, web services, and human input with the larger goal of fully automating the back-end of complex manufacturing and supply chains. Our team is a relatively small but elite group of software consultants and engineers working in Middletown, KY.

Job Responsibilities

• Database Architecture - Design and develop highly efficient, robust, and scalable database architecture on an MS SQL Server platform
• Query Authoring - Construct complex optimized MS SQL stored procedures in support of higher-level applications and analysis tools
• Data Intake Process Design - Create and automate reliable processes which handle regular and frequent extracts, transformations, and loads of large volumes of data from a wide variety of external sources
• Standards and Guidance - Develop, contribute to, and improve our standard database development and architecture practices and styles.
• Performance Optimization - Monitor, detect, and correct poor performing queries and processes. Optimize overall database performance through intelligent indexing, partitioning, normalization, process redesign, and performance tuning
• Data Analysis - Analyze and understand underlying data for the purposes of improving accuracy and meaningfulness

Great Traits

• Honest
• Creative
• High Agency. You think for yourself, work autonomously, and take extreme ownership of the problems in your domain.
• Low Ego. Skeptical of your own beliefs and ways of operating. Always open to considering new and better approaches.
• Contrarian. You aren't afraid to think in ways that deviate from prescribed norms
• EV-based thinking and decision making. You consider how much X will help Y, the value of Y, and the cost of X when deciding how to allocate your time and resources.
• Appreciation for beauty in code, design, & presentation

Skills and Experience

There is no specific experience requirement, but it is unlikely that you would be successful in this role without a minimum of 3 years of professional experience in complex MS SQL database architecture and development.

Outside of SQL It isn't critical that you know any particular language or tool but we do care that you are able to write clean, understandable code and that you are able and willing to learn new technologies quickly. The software world is constantly evolving and we need engineers who can evolve with it. That said, here are some of the skills and technologies most relevant to us right now:

• Database Architecture Design & Development (MSSQL)

• Analysis Services Cube Design & Development

• Snowflake, AWS, & other cloud database platforms

• SAP R/3 & SAP S/4 HANA

• Securing complex data systems to US Gov. standards.

• Manufacturing & Supply Chain; particularly in aerospace, defense, and electronics.

• MS Excel (Highly advanced, Including VBA)

• Microsoft PowerBI

What We Can Offer:

A chance to work with other excellent people on building software that is radically transforming complex manufacturing and making the world a more technologically capable and productive place.

A rapidly scaling fast paced environment with high expectations, top of market pay, and a high degree of autonomy.

Exposure to every piece of technology in our stack and the opportunity to acquire skills outside your specialty

Potential for equity stake in a small but rapidly growing company

Benefits: Health, Dental, Vision, flexible spending account, retirement contribution matching

Position Type:

Full Time