ETL Engineer (MS SQL Server)

SQL Server Etl Engineer Digital Intelligence Solutions (DISYS) is seeking a talented SQL Server ETL Engineer to provide clinical data solutions for healthcare informatics efforts as part of that team that designs, develops, and delivers a large-scale Data Mart solution. This position will provide opportunities to work in a team of motivated and dedicated individuals. The ETL Engineer will be responsible for the design, development and delivery of a large scale ETL solution. We are looking for a highly motivated professional with strong technical, organizational, analytical and problem-solving skills. Responsibilities: Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities for SQL Server. Work with several data source owners to import various data elements via ETL process to support the clinical application. Work with other team members, especially database engineers and implement solution using best known methods and domain knowledge. Work with business users to understand and document business and technical requirements to drive design and development. Strong relational database and SQL skills required, with MS SQL/Server and Oracle preferred. An understanding of DB2 is a plus. Perform problem assessment, resolution, and documentation in existing ETL packages, mapping, and workflows in production. Be the gate keeper to maintain the data quality of the data warehouse. Performance tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques. Monitor and support scheduled production ETL processes. Requirements: Minimum of 5 years of experience developing complex ETL solutions using SQL Server 2012/2014/2016 SSIS framework. In depth ETL knowledge using other ETL tools outside SQL Server is an added plus. Must have strong experience using advanced SSIS tools to develop a robust ETL framework to handle mission important clinical application. Must have strong knowledge and experience with database design, stored procedures, functions, triggers. Detail oriented, friendly with some experience working with business teams with no/limited technical expertise. Be able to adapt and learn technologies involving source control, release management and quality analysis. Self-starter, to able to present multiple solutions to the same problem and work with peers to implement best scalable solution. Demonstrated ability to take ownership of incidents, and drive improvements through root cause analysis and lessons learned. Experience: 5 years of hands-on SSIS development experience using SQL Server 2012/2014/2016. Experience working with mainframe DB2/Oracle/Teradata databases is a plus. Experience working in Unix/Linux environment is very helpful. Knowledge of XML is definitely a big factor. Healthcare domain knowledge is an advantage. Excellent oral and written communication skills. Education: BS or equivalent in engineering or related technical area Samprasoft