Senior Data Analyst

Wintrust Wealth Management serves the financial needs of private clients, including high net worth individuals, business owners, and institutions. Since our founding in 1931, we have been helping clients meet their increasingly complex financial goals with the highest standards of service and integrity. Through our four companies, Wintrust Investments LLC, The Chicago Trust Company N.A., Great Lakes Advisors LLC, and The Chicago Deferred Exchange Company LLC, we offer comprehensive wealth management solutions, including investment, trust, and asset management services. Wintrust Wealth Management is a division of Wintrust, a financial services company with more than $50 billion in assets.
Location:
Wintrust Investments LLC, Chicago, IL. Hybrid position-some telecommuting flexibility, but a requirement to physically be in the Chicago office occasionally/as needed.
Responsibilities:

• Project-based and ad-hoc data analysis and reporting requests
• Compile complex data sets from various source systems
• Assist with data governance initiatives, identifying and documenting key data elements and source systems
• Performs data quality control checks and validation processes on housed data
• Follow procedures for data preparation and analysis including data standardization, cleansing, and validation
• Educate front line data entry individuals on data quality standards required for effective database management
• Create various exception and control reports to improve the quality of data
• Monitor the receipt and transfer of data to/from third parties and internal sources; ensuring that ETL processes are timely and accurate.
• Work with existing team members to continuously evaluate and improve upon the technology and methodologies utilized
• Discover, troubleshoot, and resolve errors and discrepancies in data and report issues to impacted stakeholders
• Perform data analysis in support of strategic initiatives
• Identify, analyze and interpret patterns in complex data sets
• Develop and document business requirements that are addressed with data solutions and analytics
• Prepare ad-hoc reporting and analysis for various functional areas within the organization
• Maintain monthly, quarterly and annual data reports for various firm functions that are available on demand through self-service reporting portals and tools

Requirements:
Master's degree in Computer Science, Engineering, Mathematics, Finance, Management Information Systems or related and 3 years relevant experience required. In the alternative, a Bachelor's degree Computer Science, Engineering, Mathematics, Finance, Management Information Systems or related and 5 years of experience will also be considered.
The position also requires:

• 3 years of experience developing in SQL, C#, or Python
• 3 years of experience with database management and analysis (data profiling, data architecture, data governance)
• 3 years of experience developing and maintaining ETL processes
• 3 years of experience working with data visualization tools such as PowerBI, Tableau, or Qlik, etc.
• Experience with translating business objectives into technical requirements

EEOC Statement
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.