remote
Principal Data Engineer - Wintrust Financial Corporation
Data Engineer
Lead the design and implementation of enterprise data solutions, driving architecture, data pipelines, and cloud-based analytics using Python, SQL, Spark, and AWS to support business intelligence and decision‑making across the organization.
About the role
Key Responsibilities
- Architect, develop, and maintain scalable data pipelines and lakehouse solutions on AWS, ensuring high availability and performance.
- Lead data modeling initiatives, designing dimensional models and star schemas to support reporting and analytics.
- Collaborate with data scientists, analysts, and business stakeholders to translate requirements into robust ETL workflows using Python and Spark.
- Implement data quality, governance, and security controls, enforcing compliance with regulatory standards.
- Mentor and coach junior engineers, fostering best practices in coding, testing, and documentation.
Requirements
- 10+ years of experience in data engineering, with a proven track record in large‑scale data platform design.
- Expertise in Python, SQL, and Apache Spark for data processing and transformation.
- Hands‑on experience with AWS services (S3, Redshift, Glue, Athena, EMR).
- Strong understanding of data modeling, ETL design, and data warehousing concepts.
- Excellent communication skills and ability to work cross‑functionally in a fast‑paced environment.
Skills
pythonsqlapache sparkaws