Data Engineer 3

In this onsite role in Chicago, you’ll design and operate advanced data pipelines and structures that support reliable, compliant data for business and analytics use cases.

Responsibilities

• Design and build data architectures and pipelines to standardize, transform, and protect data integrity for business insights
• Maintain data quality across ingestion, processing, and loading, including monitoring standards throughout the pipeline lifecycle
• Create ingestion frameworks that support multiple data types, with ongoing data quality reporting
• Deliver accessible data consumption options such as APIs, database views, and data extracts for user applications
• Implement data solutions across platforms including Kubernetes, Teradata, and cloud services such as AWS and Databricks
• Select data storage platforms based on data sensitivity, privacy requirements, and access needs
• Manage data lineage and apply transformation rules to support change management and issue resolution
• Partner with cross-functional teams to improve data sourcing and processing while optimizing quality and efficiency
• Apply independent judgment and discretion for matters of significance
• Maintain regular, consistent, and punctual attendance; able to work nights and weekends and on variable schedules as required
• Perform other duties and responsibilities as assigned

Requirements

• 5-7 years of relevant work experience
• 5+ years minimum experience
• Bachelor’s Degree
• Strong SQL proficiency
• Programming language proficiency (Python preferred)
• Experience with distributed computing frameworks (for example, Apache Spark)
• Cloud Data Warehouse management experience
• Knowledge of at least one cloud provider: AWS, GCP, or Azure
• Familiarity with data pipeline design patterns
• Knowledge of data observability

Technologies

• SQL, Python
• Apache Spark
• AWS, GCP, Azure
• Kubernetes, Teradata
• Databricks
• dbt, Airflow
• Snowflake
• Looker
• Data lineage
• Data observability
• APIs, database views, data extracts
• Data Lakehouse Architecture

Exposure (Desired)

• Embedded Business Intelligence such as Looker (desired but not required)
• Modern data stack exposure including dbt, Airflow, Snowflake, and Apache Spark (highly desired)
• Exposure to data consumption challenges and solutions (highly desired)

Employee Expectations

• Understand and apply Operating Principles
• Own the customer experience and enable seamless digital options
• Know your stuff and act as an enthusiastic learner and advocate
• Win as a team by collaborating and welcoming new ideas
• Participate in the Net Promoter System through feedback loops (for example, huddles and call backs)
• Drive results and growth
• Support a culture of inclusion
• Do what’s right for each other, customers, investors, and communities

Compensation

USD 103,643 - 170,271 per year

Location

Chicago, IL (onsite)

Benefits

• Best-in-class Benefits to eligible employees
• Array of options with expert guidance and always-on tools personalized to meet individual needs

Disclaimer: This information describes the general nature and level of work for this role and is not a complete inventory of all duties, responsibilities, and qualifications.