Lead Data Engineer
New York, NY  / Franklin, WI 
Posted 9 days ago
Job Description
At Northwestern Mutual, we are strong, innovative and growing. We invest in our people. We care and make a positive difference.


The ideal candidate has prior work history in anETL/relational database platform in a financial industry that has become a springboard to continued growth and strong track record delivering data solutions in new cloud-based technologies.The right candidate will be fearless when it comes to data solutions, excited by the prospect of working on our next generation of investment data product/initiatives and delivering new product features, optimizing ourdata solution and helping build the teamsnew tech stack and reusable patterns.

The Lead Data Engineer is responsible for designing and solutioning complex software products and services.Identify problems with minimal information, understand and evaluate alternatives and develop solution options to deliver on business needs.Contribute to technology and product road maps, leads data solution designs, mentor and grow data engineers. Willing to jump in and develop solution as needed. Lead POC efforts to prove solution patterns that will help to address business and technical problems.The team member must be analytical and detail oriented.They must be able to work independently and then also instruct more junior engineers and developers to achieve desired team results.


Understand and align to the business and technology strategy

  • Maintain an understanding of Investment products business priorities
  • Ensure alignment proactively; escalate work not aligned with the strategy
  • Understand the latest technology alternatives and apply them as appropriate

Evolve technology products to meet and exceed needs

* Understand and contribute to the "full stack" of development (designs and products)

* Review and provide feedback for quality code, releases and fixes

  • Provide conceptual overviews and detailed engineering solutions to development teams
  • Build complex platforms and products

Deliver technology products according to business needs

* Build resilient products/features which are easily maintainable

* Optimize application development and product quality

* Solve problems and relate solutions to others

* Communicate to leadership and development staff

* Participates in peer reviews and QA on code and design

Collaborate in a high performing team and a strong technology community

  • Recruit talent
  • Mentor team members; understand strengths and motivations
  • Hold accountable yourself, your subordinates, peers, and managers for failure to meet commitments
  • Continuously grow his/her skills and technology expertise

Understand development budgets and resources, compliance, security and risk

  • Understand value metrics (job costing, comp versus productivity/output)
  • Improve cost efficiency and manage costs
  • Optimize platform and application stability

Non-technical skills:

* High sense of ownership

* Independent achiever

* Detail oriented

* Set and maintain high standards

* Problem solving

* Excellent documentation skills

Technical skills:

* Understanding of development platforms and modeling (AWS, UML, etc)

* Expert in coding various languages (Informatica, Python, Java, Java/Script, HTML/CSS, etc)

* Continuous Integrations/Continuous Development

* Agile method

* Risk Management

* Financial Analysis

* Well-versed in enterprise architecture patterns

* Able to establish new patterns to meet business needs

What this role needs:

* 5+ years of experience in data engineering

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

* Batch and near real-time data integration experience

* ETL and/or Informatica

* Experience working with relational databases including DB2 LUW, MySQL, Postgres SQL, Sybase, DB2 z/OS

* Strong SQL - writing and reviewing complex SQL statements, performance tuning

* Unix/Linux scripting

* Python, Java

* Ansible

* Data security experience

* Previous experience working with cloud data solutions

* Database administration background a plus

* Investment Industry background a plus

* Experience with different engineering eco systems (Hadoop, relational, big data, complex data)

* Code spectrum - python, Scala, java, Bash

* Cloud experience a strong plus

* Analytics understanding is a must, experience a plus

* Big picture approach - macro management needed only

* Can execute alone but is an awesome team player

* Big Data a plus

* Kafka a plus

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

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.

EEO/AA Employer/Vets/Disability


Job Summary
Start Date
As soon as possible
Employment Term and Type
Regular, Full Time
Required Experience
5+ years
Email this Job to Yourself or a Friend
Indicates required fields