Job Description:

Wintrust is a financial holding company with approximately $62 billion in assets whose common stock is traded on the NASDAQ Global Select Market. Guided by its “Different Approach, Better Results” philosophy, Wintrust offers the sophisticated resources of a large bank while providing a community banking experience to each customer. Wintrust operates more than 200 retail banking locations through 16 community bank subsidiaries in the greater Chicago, southern Wisconsin, west Michigan, northwest Indiana, and southwest Florida market areas. In addition, Wintrust operates various non-bank business units, providing residential mortgage origination, wealth management, commercial and life insurance premium financing, short-term accounts receivable financing/outsourced administrative services to the temporary staffing services industry, and qualified intermediary services for tax-deferred exchanges. Our unique business model is a competitive strength and value driver, powered by our talented colleagues who put our customers first and achieve better results for our clients.

Job Title:                   

Advanced Data Engineer

Location:                   

Job location –Rosemont, IL- Hybrid position-some telecommuting flexibility, but a requirement to physically be in the Rosemont, IL office occasionally/as needed.

Responsibilities:

Design, development, and maintain Data Solutions following the best practices and coding standards.

Building out data pipelines including collecting and transformation of the data for Analytics.

Build processes supporting data transformations, data structures, metadata, and workload management.

Plans and executes unit test to ensure the developed code is free of functional defects.

Complete Design and Development of a small to medium sized task independently.

Ensure data governance policies are followed by implementing and validating data Lineage, quality checks, classification etc.

Support/enhance/create Daily/Monthly ETL/ELT processes to ensure business continuity, ensuring all related data pipelines meets best‐in‐class standards offering high Performance.

Work in other areas of Data Enablement lifecycle, including batch and real time processes using SQL Server, SSIS ETL/ETL, as needed.

Analyze the requirements and prepare technical specifications.

Create Conceptual/Logical/Physical Data Models for all data solutions.

Support and maintain existing data warehouse for Operational and analytical applications.

Perform root cause analysis on internal and external data and processes to answer Specific business questions.

Identify bottlenecks in existing processes and recommend solutions for improvement.

Serves as resource to internal and third party team members on escalated issues and analyzing and designing specifications for less experienced team members.

Pursues self‐development and effective relationships with others by sharing resources, information, and knowledge with coworkers and customers; and seeks opportunities to deliver continuous process improvement.

Requirements:

Bachelor's degree or foreign equivalent in Computer Science, Information Systems, Engineering, Math, or a related quantitative field plus 5 years of relevant experience.  As an equivalent alternative, employer will also accept a Master's degree in Computer Science, Information Systems, Engineering, Math, or a related quantitative field plus 3 years of relevant experience.

The position also requires:

• 3 years of experience in Data Engineering ‐ designing, data modeling, data processing, and data integration.




• 3 years of experience in designing and building complete ETL pipelines moving and transforming data for ODS, Staging, Data Warehousing and Data Mart using Microsoft SSIS.




• 2 years of experience with medium‐scale data and t-sql query optimization techniques.




• Experience with Data Warehouse concepts including 3NF and Dimensional data models.




• Experience with establishing standards and best practices for SQL server database and SSIS ETL development.




• Experience with the tools like SQL profiler to debug and diagnose issues in any type of database environment is required.




• 3 years of experience in processing structured and semi - structured files using Microsoft SSIS and SQL.




• 2 years of Experience with source control repository system such as TFS.

From our first day in business, Wintrust has been proud to serve a variety of unique communities and people from all walks of life. To be Chicago’s Bank® and Wisconsin's Bank®, we need to reflect that diversity both in all the communities we serve, the people we employ, the organizations we work with, and our banking and lending practices. 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, 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.