Sr Software Engineer

Our client, a leading Medical Device company is looking for a

• 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.
• Design, develop and maintain SQL Server Reporting Services reports.
• 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 standard best practices.

• BS in Computer Science or Information Systems

• 8+ years of experience working with Microsoft SQL Server with emphasis on database code, ETL and Reporting Services development.

• Database design skills including normalization and data warehouse design.
• Strong hands-on T-SQL development skills including stored procedure, function, and trigger creation.
• Excellent query optimization and performance tuning skills.
• Extensive experience developing SSRS reports.
• Strong SSIS skills.
• Detailed analytical skills.
• Structured troubleshooting skills.
• Experience with data modeling tools such as ER/Studio or ERWin.
• Experience using version control systems (e.g., TFS, Git).
• Familiar with Agile software development process.
• Working experience with Azure DB technologies and Azure deployments is a plus.
• Experience in the healthcare industry is a plus.

• Microsoft SQL Server 2012 and above
• Microsoft SQL Server Integration Services (SSIS)
• Microsoft SQL Server Reporting Services (SSRS)
• Microsoft Visual Studio 2012 and above
• Embarcadero ER/Studio is a plus