Apply for this job now

Advanced MDM Engineer

Rosemont, Illinois
Job Type
1 Sep 2022

Wintrust is a financial holding company with approximately $50 billion assets under management and traded on the NASDAQ:WTFC. Built on the "HAVE IT ALL" model, Wintrust offers sophisticated technology and resources of a large bank while focusing on providing service-based community banking to each and every customer. Wintrust operates fifteen community bank subsidiaries with over 170 banking locations in the greater Chicago and southern Wisconsin market areas. Additionally, Wintrust operates various non-bank business units including commercial and life insurance premium financing, short-term accounts receivable financing, out-sourced administrative services, mortgage origination and purchase, wealth management services and qualified intermediary services for tax-deferred exchanges.

Why join us?

  • An award-winning culture! We are rated a Top Workplace by the Chicago Tribune (past 8 years) and Employee Recommended award by the Globe & Mail (past 6 years)

  • Competitive pay and discretionary or incentive bonus eligible

  • Comprehensive benefit package including medical, dental, vision, life, a 401k plan with a generous company match and tuition reimbursement to name a few

Why join this team?

  • We hold ourselves accountable to high standards, share wins, operate ethically, and have fun

  • Master Data Management (MDM) team members play a key part in the Wintrust Digital Journey supporting enterprise applications including CRM, Digital Banking, Account Opening Platform, LOS etc.

Position Summary

The Advanced Data Engineer is responsible for the design, development, test and implementation of best-in-class Data Processing solutions for the organization, including Data Modeling, Data Loading, Data delivery, Data availability, Performance and Security. This is an advanced role in Data Management - MDM team and the ideal candidate 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

  • Design, development and continuous improvement of complex data systems.

  • Build processes supporting data transformations, MDM Match and Merge Process, Trust and Survivorship Rules, User Exits, ActiveVOS Workflow, Composite Services, BES API's, etc.

  • Plan and execute unit test to ensure the developed code is free of functional defects.

  • Support and maintain existing data solutions within MDM for operational and analytical applications.

  • Required to 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 and detail level design documents.

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

  • 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.

  • Seeks opportunities to deliver continuous process improvement, automating manual processes and optimizing data delivery.


  • Bachelor's degree with 5+ years' experience or Master's degree with 3+ years' experience in Computer Science, Engineering, Math, or other quantitative field.

  • 3+ years' experience in Data Engineering - designing, implementing data persistence, data processing, data integration and MDM Solution.

  • Experience in designing and building MDM Solution for enterprise needs.

  • Experience working with Informatica MDM 10.x tool is preferred.

  • Experience writing User Exits and has strong Java background is preferred.

  • Experience in developing ETL pipelines using SSIS is preferred.

  • Has mastered the tools needed to debug and diagnose issues in any type of environment.

  • Perform peer reviews and take ownership of the data processes to ensure quality of data is of high standard in MDM.

  • Experience with building CICD pipelines for data pipelines using Azure DevOps is a plus.

  • Experience with source control repository system such as TFS or GIT is preferred.

  • Experience working on Banking and Financial domain is preferred.

  • Passionate about learning new technologies and solving hard problems in a fast-paced environment.

  • Proven ability to work within a team environment and interacting with data professionals and business data SME's throughout the organization

  • Demonstrates strong analytical and problem solving skills.

  • Proven track record of meeting commitments with the highest standards of ethics and integrity.

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.

Apply for this job now


  • Job Reference: 701412671-2
  • Date Posted: 1 September 2022
  • Recruiter: Wintrust Financial
  • Location: Rosemont, Illinois
  • Salary: On Application
  • Sector: Engineering
  • Job Type: Permanent