Skip to content

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

Summary:

Northwestern Mutual is looking for a Lead Data Integration professional to join our integration engineering team! We grow data engineering practice, to initiate and lead the data integration engineering process including, enable overall data integration strategy & architecture by demonstrating NM technical best practice and solution service. This individual will lead, develop and handle the enterprise IT risk data model, enable end to end data integration process from source data mapping/extracting, conduct business transformation logic, and enable Enterprise Information Risk & Cybersecurity data lake. Strong data modeling, ETL and data architecture knowledge using modern cloud technology & architecture. Deep knowledge in DveOps of data solution and understanding the concept of MLOps and ModelOps. Capable working with enterprise level data service product teams matrix with Risk Analytic product owners. Key person leads the SLA of data lake data subscription service, including platform, downstream applications, and ETL operation. API connection to source systems. Partner with Analytic MLOps Engineering team to operationalize analytical data model build by data science practice.

Responsibilities:

  • 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 build data model of EIRC data lake and data integration solutions to move and transform data from Source systems to on premise ODS, Data Warehouse environments and to the AWS cloud.

  • Lead the change of data model, metadata, mapping and data dictionary

  • 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

  • 8+ 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

  • Erwin data modeling.

  • 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 implementing 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

  • Proven success in coaching/mentoring others

  • Individuals who show a solid 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

  • Risk and Cybersecurity Services industry background

  • Service Now

#LI-Post

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!

W e 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 Colorado or outside of a Corporate location, please click here for information pertaining to compensation and benefits.


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.