Skip to content

Lead Data Engineer

At Northwestern Mutual, we are strong, innovative and growing. We invest in our people. We care and make a positive difference.

To support our growing team, we are looking for a Lead Software Engineer.

Your are the right fit if you are the best of the best and have yet to meet a problem you could not solve. We need someone that loves to write elegant code but more than that, is passionate about making things work. We need a lead engineer who’s eager to grow but already sees things through the eyes of an architect - someone who keeps the big picture in mind no matter the task. We need an engineer that always designs and codes with performance, scalability, and concurrency in mind.

You will be working on the systems that provide the foundational platform of our client and field experiences at Northwestern Mutual. Our team provides core client data for the enterprise and is experiencing growth and focus around maturing our core data platforms. We need engineers who can help us mature our space and take our API and service ecosystem to the next level.

What you’ll get to do:

  • Define data integration frameworks, methods, guidelines and principles. Apply subject matter expertise to data integration processes to make improvements and recommendations for change including execution.

  • Collaborate with source system technical owners, Product Owners, and Infrastructure resources to create data integration solutions to move and transform data from Source systems to on premise ODS, Data Warehouse environments and to the AWS cloud.

  • Ability to create designs following established data integration patterns and establish new patterns to meet business needs

  • Provide data integration subject matter expertise to the team covering ETL/ELT, replication, streaming, and virtualization. Can explain complex concepts to others and establish business value of solutions

  • Complete design, code review and test case reviews to improve and set the bar for the quality of the delivery. Providing guidance for the engineering team while designing the data integration applications

  • Maintain ETL/Data integration agile management stories with delivery to dates to ensure Safe Agile processes are adhered to

  • Provide guidance to ETL team members and other users of the Informatica production across the enterprise

  • Remain current on industry specific knowledge and emerging technologies

  • Hands on development with various technologies including Informatica, AWS capabilities, Kafka, Java and others

What we’re looking for:

  • Bachelor's degree in Computer Science, MIS, or related field

  • 7+ years of experience in data engineering or related field

  • Data systems architecture experience, designing larger scale data engineering solutions, break down to smaller goals, prioritization

  • Experience with relational data engineering eco systems (preferably complex disbursed data)

  • Understand batch and real-time data integration patterns include ETL experience (Informatica, SSIS, DataStage, etc), data replication, data streaming, virtualization, etc

  • Experience in writing and executing complex SQL’s

  • AWS Cloud experience with Kafka, API’s, Ansible etc.

  • Able to build CICD pipeline for deployments

  • Experience in end to end data engineering solutions

  • Demonstrated success in coaching/mentoring others

  • Individuals who show a strong sense of ownership for their deliverables

  • Ability to work across the organization and communicate effectively to various levels

Desired:

  • Database administration experience

  • Cloud experience, preferably AWS, is a strong plus

  • Financial Services industry background

#LI-POST

Benefits

  • Tuition reimbursement, commuter plans, and paid time off

  • Highly competitive compensation that include base salary plus bonus

  • Medical/Dental/Vision plans, 401(k), pension program

This job is not covered by the existing Collective Bargaining Agreement.

Required Certifications:

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.


FIND YOUR FUTURE

We’re excited about the potential people bring to Northwestern Mutual. You can grow your career here while enjoying first-class perks, benefits, and commitment to diversity and inclusion.