Senior ETL(SSIS) developer

Job Description: This Developer position has design, development and maintenance responsibility for the software applications and processes associated with our insurance oriented company. Specifically this role will initially focus on the ETL processes needed to support and develop integration with various partners at the firm. The position provides exposure to multiple business units in a dynamic insurance firm. The role requires functioning as a member of an Agile Scrum team and will require direct interaction with business users. Candidates must be able to attend daily scrum calls that last from 10-20 minutes every day. Minimum experience required: 6+ years. Candidates must be able to provide proof of experience. Qualifications: • Experience designing, building and supporting ETL processes • Strong database engineering skills on the MS SQL Server platform and knowledge of SSIS required • Experience delivering software as part of an Agile delivery team and/or experience in a financial services environment a plus • Solid knowledge of modern software design principles, concepts, and practices • Outstanding analytical and quantitative skills; Must have the ability to collaborate and communicate effectively in a dynamic work environment Responsibilities: • Design, build, and support ETL processes in support of the insurance domain • Build integration solutions leveraging SSIS for batch integration • Maintain, enhance, and develop new stored procedures, functions, views, tables within MS SQL Server • Work collaboratively as part of an Agile Scrum project team • Build reporting solutions leveraging SSRS • Design and build web based UIs to support business workflows and backend ETL processes • Partner with various teams to research, resolve, and document production issues