Principal Software Engineer

Description

The Software Technology Solutions department is responsible for developing and maintaining on-premise and hosted software solutions that provide integration, reporting, and analytics capabilities for the company’s portfolio of products. Using industry best practices, the department is responsible for delivering high-quality, robust software applications that meet present and future requirements.

Specific Duties, Activities, and Responsibilities

• Understand and apply database design and development principles for both transactional and dimensional schemas to support application requirements.
• Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems.
• Maintain source code for database and ETL projects. Ensure that projects build successfully in a continuous integration environment.
• Diagnose and resolve database performance issues.
• Follow and improve development processes including but not limited to conducting peer/code reviews, complying with organizational standards, ensuring code maintainability, following build processes, implementing unit tests, and following other industry standards best practices.
• Experience with automatic code deployment (Octopus) tool is a plus

Position Requirements

• Education or Equivalent
• BS in Computer Science or Information Systems
• Experience or Equivalent
• 9+ years of experience working with Microsoft SQL Server with emphasis on database code development.
• Knowledge, Skills, and Abilities Requirements
• Data modeling tools such as ER/Studio or ERWin
• Database design skills including normalization and data warehouse design
• T-SQL development skills including stored procedure, function, and trigger creation
• Excellent query optimization and performance tuning skills
• Strong SSIS skills
• Detailed analytical skills
• Structured troubleshooting skills
• Experience in the healthcare industry is a plus
• Toolset
• Microsoft SQL Server 2014 and above
• Microsoft SQL Server Integration Services (SSIS)
• Microsoft Visual Studio 2014 and above
• Microsoft SQL Server 2014 to 2019 migration experience is a plus
• Embarcadero ER/Studio is a plus
• Microsoft SQL Server Reporting Services (SSRS) is a plus
• Experience with automatic code deployment tools (Octopus) is a plus
• Physical/Mental Requirements
• Ability to communicate clearly both verbally and in writing.
• Ability to analyze complex application and business operational issues.

Additional/Important Information

• The database developer will be additionally be responsible for the following tasks:
• Analyzing requirements to create software designs
• Estimation and timely completion of tasks
• Documenting developed modules
• Supporting application developers and software testers
• Creating and executing unit tests for developed code
• Following quality assurance processes