Founded in 1991 with the idea to be the alternative to the big banks, Wintrust has since grown into a financial services company with more than $45 billion in assets, headquartered in Rosemont, Illinois. Through our multiple companies and divisions, we provide traditional community banking and commercial banking services, wealth management solutions, commercial and life insurance premium financing, mortgage origination, and short-term accounts receivable financing and certain administrative services, such as data processing of payrolls, billing, and treasury management services. We provide community-oriented personal and business banking services to customers located in the greater Chicagoland area, northwest Indiana, and southern Wisconsin through more than 175 community bank locations.
Position Summary
Seeking an Advanced SSIS / SSRS developer with a strong understanding of Data Warehousing / ETL strategy and best practices as well as a the ability to develop SSIS packages and SSRS reports. The candidate must be detail-oriented and have analytical and problem-solving skills, with the ability to spot problems that may otherwise be overlooked, finding a problem's source and finding resolutions to issues as they arise. The developer should demonstrate teamwork working closely with the IT and cross functional teams on different projects, and remain professional at all times. Must have ability to independently and logically walk through and understand existing SSIS/ETL packages. Must clearly and timely communicate information to cross functional team members.
Responsibilities

• Understand and help refine business requirements provided by business analysts.
• Help Business Analysts identifying technical solutions.
• Translate business requirements into systems, applications and process designs.
• Provide team with business and technical support.
• Drive design, development and maintenance of SSIS processes and SSRS reports.
• Create and modify stored procedures.
• Create standard application documentation.
• Analyze and resolve production issues.
• Work independently and under the direction of or in collaboration with other team members

Qualifications

• Bachelor's degree in Computer Science, Software Engineering or equivalent work experience.
• 5+ years of Microsoft SQL Server with SSRS and SSIS experience.
• Ability to work on multiple small tasks alongside major deliverables in the rapidly changing environment.
• Unit test writing experience.
• Source control good practices.
• C#, or ASP.Net, Power BI is a plus.
• DevOps familiarity.

Wintrust Financial Corporation, including community banking and financial services subsidiaries, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, citizenship status, sex, sexual orientation, gender identity and expressions, genetic information, marital status, age, disability, or status as a covered veteran or any other characteristic protected by law.