Earnbetter

Job Search Assistant

Logo

LEAD DATA ENGINEER

Northwestern Mutual • Milwaukee, WI 53201 • Posted 1 day ago

Boost your interview chances in seconds

Tailored resume, cover letter, and cheat sheet

Hybrid • Full-time • $123,552-$224,250/yr • Senior Level

Job Highlights

Using AI ⚡ to summarize the original job post

The Lead Data Engineer at Northwestern Mutual Life Insurance Company in Milwaukee, Wisconsin will be responsible for designing, building, deploying, and maintaining various ETL jobs and data pipelines. This role involves influencing team members through lean agile leadership, leading and driving work to completion, mentoring technical team members, and working closely with engineering, data science, and analytics teams to enable business use cases through the delivery of data products. The position also includes production support, upgrade, and building self-healing data pipelines using CI/CD, and migrating data from various databases to AWS using PySpark and SQL.

Responsibilities

  • Design, build, deploy, and maintain various ETL jobs and data pipelines.
  • Influence team members through lean agile leadership.
  • Lead and drive work to completion and assign workload to junior team members.
  • Work closely with engineering, data science, and analytics teams to enable business use cases through delivery of data products.
  • Mentor technical members of team on Software Craftsmanship and Quality Standards.
  • Assist with production support, upgrade, and build self-healing data pipelines using CI/CD.
  • Translate raw data into usable business information to achieve business value.
  • Practice Agile methodologies to implement technical application requirements, analyze project requirements, and establish relationships with data owners and experts.
  • Set standards, identify new patterns, and establish best practices for data engineering teams.
  • Migrate data from various databases and sources to AWS using PySpark and SQL.
  • Utilize Big Data tools and technologies including Erwin to create data models, Databricks, Spark, and Python to create schema design, load data, and optimize data query results, then use Airflow to orchestrate data.
  • Participate in code reviews and provide feedback to the team.

Qualifications

Required

  • Master’s degree in Data Analytics, Computer Science, or a related field plus 2 years (or a Bachelor’s degree plus 6 years) of experience as a data engineer or related occupation.
  • Experience with Scala, Java, C#, or R.
  • Experience with Cloud platforms including AWS, S3, EMR, EC2, RDS, Redshift, or Lambda.
  • Experience with Data Integration Patterns and Tooling, including ELT/ETL, EII, Replication, Event Streaming, and Virtualization.
  • Experience with databases including PostgreSQL, SQL server, and DB2.
  • Experience with big data frameworks and computing tools including Spark, Hive, and Databricks using Python and SQL.
  • Experience with CI/CD pipelines, GitHub, Docker, and Kubernetes.
  • Knowledge of Agile Scrum principals, Task meetings, and Retrospectives.
  • Experience with the software development life cycle including requirement gathering, debugging, analysis, and software documentation.

About Northwestern Mutual

Northwestern Mutual is a leading American financial services company specializing in life insurance and financial planning services. Operating primarily in the United States, the company offers a range of products including life insurance, disability income insurance, annuities, and investment products. With a strong reputation and commitment to customer-centric offerings, Northwestern Mutual is known for its comprehensive financial planning services and strategic investments in innovation and digital transformation.

Full Job Description

At Northwestern Mutual, we are strong, innovative and growing. We invest in our people. We care and make a positive difference.Job Description: The Lead Data Engineer at Northwestern Mutual Life Insurance Company in Milwaukee, Wisconsin will design, build, deploy, and maintain various ETL jobs and data pipelines. Influence team members through lean agile leadership. Lead and drive work to completion and assign workload to junior team members. Work closely with engineering, data science, and analytics teams to enable business use cases through delivery of data products that expand availability and usability of data while ensuring quality of data. Mentor technical members of team on Software Craftsmanship and Quality Standards. Assist with production support, upgrade, and build self-healing data pipelines using CI/CD. Translate raw data into usable business information to achieve business value. Practice Agile methodologies to implement technical application requirements, analyze project requirements, and establish relationships with data owners and experts. Set standards, identify new patterns, and establish best practices for data engineering teams. Migrate data from various databases and sources such as Netezza, Postgres, Redshift, DB2, MySQL to AWS using PySpark and SQL. Utilize Big Data tools and technologies including Erwin to create data models, Databricks, Spark, and Python to create schema design, load data, and optimize data query results, then use Airflow to orchestrate data. Participate in code reviews and provide feedback to the team. Telecommuting permitted. Salary $123,552- $224,250 per year.Minimum Requirements: Master’s degree in Data Analytics, Computer Science, or a related field plus 2 years (or a Bachelor’s degree plus 6 years) of experience as a data engineer or related occupation. Experience must include 2 years with each of the following: (1) Scala, Java, C#, or R; (2) Cloud platforms including AWS, S3, EMR, EC2, RDS, Redshift, or Lambda; (3) Data Integration Patterns and Tooling, including ELT/ETL, EII, Replication, Event Streaming, and Virtualization; (4) databases including PostgreSQL, SQL server, and DB2; (5) big data frameworks and computing tools including Spark, Hive, and Databricks using Python and SQL; (6) CI/CD pipelines, GitHub, Docker, and Kubernetes; (7) Agile Scrum principals, Task meetings, and Retrospectives; and (8) software development life cycle including requirement gathering, debugging, analysis, and software documentation.Interested candidates send resume to apply@northwesternmutual.com. Reference code 419 in the subject line.Any wage range listed here supersedes corresponding wage ranges listed within the Pay Transparency Guide.Grow your career with a best-in-class company that puts our client’s interests at the center of all we do. Get started now!We are an equal opportunity/affirmative action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender identity or expression, sexual orientation, national origin, disability, age or status as a protected veteran, or any other characteristic protected by law.If you work or would be working in California, Colorado, New York City, Washington or outside of a Corporate location, please click here for additional information pertaining to compensation and benefits.SummaryLocation: Milwaukee, WI CorporateType: Full time