Search Our Career Opportunities

Senior Data Engineer

Date: May 10, 2019

Location: Milwaukee, WI, 53202

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

Data Engineer – Job Description

 

As a Data Engineer for Northwestern Mutual, you will focus on the design, implementation, and operation of secure reporting solutions for the Investments Product & Services (IPS) team.  The reporting and analytics team is responsible for the promotion of self-service capabilities to improve our internal client experience. 

 

About the Role:

  • Opportunity to interact with internal IPS end users to understand their needs.
  • Work in an agile environment to design, build, and deliver highly visible and innovative reporting solutions.
  • Using ETL and SQL, assemble the data required for business reporting solutions.
  • Opportunity to build innovative tabular models for business reporting solutions.
  • Using PowerBi, build self-service reporting solutions for IPS end users.

About You:

  • 3+ years Microsoft Business Intelligence (MSBI) skills especially with AWS analysis services, PowerBI
  • Design and develop tabular models in AWS cloud using analysis services
  • Design and develop PowerBI dashboards in AWS cloud
  • Solid analytical & dev experience using SSIS
  • 5+ years SQL queries for data analysis
  • 5+ year’s experience in developing ETL frameworks to pull data from different sources
  • Exposure & dev experience on SSAS (tabular model) using DAX
  • Sound visualization experience using PowerBI
  • Sound experience in Agile development process
  • Sound knowledge on evaluating the technical assessment to modernize/migrate/move application to cloud
  • Evangelize self-service BI and visual discovery while helping to change Excel/Business Objects-based culture
  • Experience in writing C# code for implementing ETL operations, developing and maintaining of processes and associated SQL scripts/tools for automated build, testing and deployment of the products to various developments.
  • Involved in database design, data modeling, development, programming, implementation, ETL and Reporting in SQL server
  • Experience in data warehousing, writing complex MDX queries, SSAS (Tabular & Multi-dimensional) for creating cubes, development of applications and building data marts, operational data store (ODS) OLAP using MS SQL Server
  • Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS) OLAP Cubes, Star and Snowflake schema using DM tools like ERWIN, VISIO, SQL Diagrams.
  • Java, Big Data, and Informatica experience is a plus
  • Financial Industry experience with focus on investments is preferred

 

 

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.

 

Req ID: 24921
Position Type: Regular Full Time
Education Experience: Bachelor's Required
Employment Experience: 6-8 years
Licenses/Certifications: Not Applicable
FLSA Status: Exempt
Posting Date: 03/25/2019