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
The Advanced Data Engineer - Actimize is a key position within the Data Management team, responsible for the design, development, test and implementation of best-in-class ETL/Data Processing solutions for the organization. This is an advanced role that will be engaged in all phases of the Data Enablement lifecycle, and will be called upon to mentor less experienced team members as necessary. Successful candidate will have a proven track record demonstrating in-depth technical and business knowledge.
Key Accountabilities

• 70% of time: Design, develop and maintain SSIS ETL packages using SSIS and MS SQL Server 2016 or higher. Support/enhance/create ETL packages to address AML ETL business requirements, ensuring all related ETL processes meets best-in-class standards offering high performance. Responsible to address all ETL defects related to AML data loads. Required to work in other areas of Data Warehousing ETL efforts as needed.
• 10% of time: Primary resource for AML ETL Production Support, address all Audit Related questions with respect to AML ETL processes. Create/Enhance technical documentation and ensuring all documentation is up to date.
• 10% of time: Serves as resource to internal and third-party team members on escalated issues and analyzing and designing specifications for less experienced team members
• 10% of time: Pursues self-development and effective relationships with others by sharing resources, information, and knowledge with coworkers and customers. Seeks opportunities to deliver continuous process improvement

Qualifications

• Bachelor's degree with 7+ experience or Master's degree with 5+ years' experience in Computer Science, Engineering, Math, or other quantitative field.
• 7+ years' experience in Data Engineering - designing, implementing data persistence, data processing and MS SQL Server DW Solutions.
• Experience in designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, Data Warehousing and Data Marts.
• Proficient in T-SQL development (complex queries, stored procedures and user defined functions) and performance tuning.
• Experience with dynamic package configurations, error handling, checkpoints, auditing and balancing using SSIS and T-SQL Stored Procedures.
• Support and maintain the existing ETL processes (SSIS) and SQL Server Data Warehouse for operational and analytical applications.
• Strong understanding of DW concepts including 3NF and Dimensional data models.
• Experience with processing semi structured and unstructured files using SSIS ETL tool with custom C# coding.
• Perform peer reviews and take ownership of the ETL processes to ensure quality of data in data warehouse and downstream data marts.
• Experience with building CICD pipelines for SSIS ETL packages using Visual Studio and Azure DevOps is a plus.
• Experience with source control repository system such as TFS or GIT is preferred.
• Efficiently work in Agile environment. Familiarity with tracking tools such as JIRA is a plus.
• Experience with running python programs using SSIS and visual studio is a plus.
• Experience working on Banking and Financial domain is preferred.
• Proven ability to work within a team environment and interacting with data professionals and business data SME's throughout the organization
• Desire to work in a fast growing environment with strong time management ability
• Demonstrates strong analytical and problem solving skills.
• Must be self-directed and have excellent initiative and organization skills.
• Proven track record of meeting commitments with the highest standards of ethics and integrity.

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.