You are viewing a preview of this job. Log in or register to view more details about this job.
Email

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 ownership.
  • Low Ego. Skeptical of your own beliefs. Always improving. Always open to new and better approaches.
  • Contrarian. You think in ways that deviate from prescribed norms.
  • Rational. You have 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.
  • Taste. You appreciate aesthetics and beauty in code, design, & presentation

 

Skills and Experience

 It isn't critical that you be expert with 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