Wintrust Financial Corporation - Rosemont, IL

posted about 2 months ago

Full-time - Mid Level
Rosemont, IL
Credit Intermediation and Related Activities

About the position

The Senior Data Engineer is a pivotal role within the Data Management team at Wintrust, a financial holding company with a strong commitment to community banking and advanced technology solutions. This position is responsible for the design, development, testing, and implementation of top-tier Data Processing solutions that are essential for the organization. The role encompasses various aspects of data management, including Data Modeling, Data Loading, Data Delivery, Data Availability, Performance, and Security. As a senior member of the team, the Senior Data Engineer will engage in all phases of the Data Enablement lifecycle, ensuring that data systems are robust, efficient, and aligned with the company's strategic goals. Additionally, this role involves mentoring less experienced team members, sharing knowledge, and fostering a culture of continuous improvement. In this position, the Senior Data Engineer will design and develop complex data systems that support the Wintrust Digital Journey, which includes enterprise applications such as BSA, Enterprise Data Hub, CRM, Digital Banking, and Enterprise LOS. The engineer will build processes that facilitate data transformations, manage data structures, and oversee metadata, dependency, and workload management. A critical aspect of the role is to ensure compliance with data governance policies by implementing and validating data lineage, quality checks, and classification. The Senior Data Engineer will also support and enhance existing ETL/ELT processes to ensure business continuity and high performance across all data pipelines. The successful candidate will have a proven track record of technical and business acumen, demonstrating the ability to create enterprise data sets for analytics and data science teams. They will be responsible for creating Conceptual, Logical, and Physical Data Models for all data solutions and will actively seek opportunities for process improvement, automating manual processes, and optimizing data delivery. This role is essential for maintaining the integrity and performance of data systems that drive decision-making and strategic initiatives within the organization.

Responsibilities

  • Design, develop and continuously improve complex data systems.
  • Build processes supporting data transformations, data structures, metadata, dependency and workload management.
  • 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.
  • Create enterprise data sets for analytics and data scientist team members for advanced analytics.
  • Create Conceptual/Logical/Physical Data Models for all data solutions.
  • Seek opportunities to deliver continuous process improvement, automating manual processes and optimizing data delivery.

Requirements

  • Bachelor's degree with 7+ years of experience or Master's degree with 5+ years of experience in Computer Science, Engineering, Math, or other quantitative field.
  • 5+ years of experience in designing and building complete data pipelines moving and transforming data for ODS, Staging, Data Warehousing and Data Marts, MDM, including Middleware Integrations.
  • Strong understanding of DW concepts including 3NF and Dimensional data models, and MDM Concepts.
  • Experience with processing semi-structured and unstructured files using different traditional SQL and modern object-oriented scripting languages such as Python, Scala, etc.
  • Experience with building CICD pipelines for data pipelines using Azure DevOps is a plus.
  • Experience working in the Banking and Financial domain is preferred.

Benefits

  • Medical Insurance
  • Dental Insurance
  • Vision Insurance
  • Life Insurance
  • Accidental Death and Dismemberment Insurance
  • Short-term and Long-term Disability Insurance
  • Parental Leave
  • Employee Assistance Program (EAP)
  • Traditional and Roth 401(k) with company match
  • Flexible Spending Account (FSA)
  • Employee Stock Purchase Plan at 5% discount
  • Critical Illness Insurance
  • Accident Insurance
  • Transportation and Commuting Benefits
  • Banking Benefits
  • Pet Insurance
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service