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

• Data Management 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 Senior Data Architect is a key position within the Data Management team, responsible for the design, development, test and implementation of best-in-class Data solutions for the organization. This is an architecture role that will be engaged in all phases of the Data Integrations lifecycle, and will be called upon to mentor less experienced team members as necessary. Successful candidate will have a proven track record of being a Subject Matter Expert for the data domain.

What You’ll Do

• Design, develop and maintain data solutions using best practices.

• Provide architectural analysis for data integrations including definition of standards for scalability, security, error handling, and auditing.

• Assist in estimating and scoping of all data integration related implementations.

• Analyze the requirements and prepare technical specifications and detail level design documents.

• Drive the Design, Development and Deployment of data flows.

• Implement DevOps for all data integrations, participate in all types of testing, including unit testing, point-to-point testing, end-to-end testing and UAT.

• Support/enhance/create integrations to address business requirements, ensuring all related processes meets best-in-class standards offering high performance.

• Designing, prototyping and delivering Batch integrations and applications in varied deployment models - cloud based, on premise and hybrid.

• Build continuous improvement process for complex data systems, tools and reports

• Required to work on other areas of data integrations including batch processes using SQL Server and SSIS ETL/ELT.

• Serves as resource to internal, offshore team and third-party team members on escalated issues, 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

Qualifications

• IT Professional with 7-10 years’ experience and Bachelor’s degree in Computer Science, Engineering, Math or other quantitative field.

• 3+ years’ experience in an architect role.

• Experience with Microsoft SQL Server BI ecosystem (SSIS, SSAS, and PowerBI).

• Held an architect role on multiple complex Data Warehousing Projects.

• Experience in defining, modeling, building and optimizing data architecture for Modern Data Warehousing and Analytics Platforms.

• Experience with specifying technical solutions involving complex data transformations rules using a combination of narratives, data flow diagrams, process diagrams, pseudo code and technical documentation

• Should have worked with enterprise architects, data engineers, database administrators, BI engineers and business analysts to determine project requirements and capabilities, and strategized development and implementation timelines

• Experience in leading the design and implementation of data models to support multiple ongoing company projects.

• Experience in developing standards and procedures as well as programming architectures for code reuse

• Experience with design and implementation of OLTP and ODS data models in 3rd normal form; and OLAP star schema models.

• Experience with Data Modeling tools such as Erwin, ER/Studio, and Visio.

• Establish methods to maintain the integrity and security of the company data

• Experience with data integrations using SQL Server and SSIS is a plus.

• Good understanding of Data Warehousing, Middleware, MDM and Data Governance concepts.

• Experience with relational SQL and NoSQL databases.

• Experience with working on Onsite and Offshore model.

• Experience working on Banking and Financial domain is a plus.

• Experience with Data Lake Implementation is a plus.

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

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

#LI-REMOTE

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.