Search Our Career Opportunities

Business Intelligence Developer

Date: Aug 12, 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. 

What's the role?

The Business Intelligence Developer role (BI) at Northwestern Mutual Life Insurance Company will help drive data-driven people decisions and tell the underlying story behind the data by providing strategic reporting and analytics.

The BI Developer will support this by expanding and optimizing our data model and architecture and visualizing this data through the creation of Tableau dashboards. This role will develop, construct and maintain large, complex data models by combining, transforming, and structuring data from HR, Finance and other data sources in a SQL environment.  Additionally, this role will create and maintain dashboards and other visualizations using Tableau to meet business needs.  The BI Developer will support leaders, data scientists and analysts to drive strategic reporting, predictive analytics and workforce planning activities.

Specific responsibilities will include (but is not limited to) the following:

 

  • Participate in the design, development, and analysis of data architecture and warehousing approaches.
  • Build and execute ETL processes from multiple, disparate data sources such as flat files, web services, SQL Server DB, etc.
  • Create technical documents to document database contents, concepts, and mapping between databases.
  • Design, code, test, and aggregate results from SQL queries to provide information to users.
  • Design advanced enterprise dashboards to support areas such as talent acquisition, leader development, performance, and retention.
  • Assist in the creation of insightful reports that interpret data, not simply restating it.
  • Works with minimal supervision on large, complex projects.
  • Contributes to the innovation of software solution development.
  • Consults on right-sizing decisions, software solutions, and services.
  • Recognized as having expert knowledge.
     

Bring Your Best! What this role needs:

  • Bachelor's degree in Data Analytics, Computer Science, Software Engineering, Information Technology or other directly related analytical field
  • 3+ years experience in complex ETL using SQL in Enterprise environment, including 1+ years of experience in SSIS and Microsoft SQL Server usage on large, frequently updated databases.
  • 1+ years of experience using Tableau or other BI tools.
  • 2+ years of experience in HR, marketing, finance or other related field developing and maintaining reports, forecasting models and various analyses.
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
  • Full end-to-end experience in data warehousing, including data modeling, loading, transformation, scripting and process auditing.
  • Experience with designing complex dashboards taking advantage of all Tableau functions including level of detail calculations, data blending, actions, parameters etc.
  • Experience with engineering best practices to include analyzing, designing, developing, and deploying and supporting software solutions and/or infrastructure implementations/upgrades.
  • Strong problem solving skills.
  • Strong sense of ownership and the ability to work with a limited set of requirements.
  • Ability to explain technical solutions to technical teams and non-technical teams. 

 

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: 25890
Position Type: Regular Full Time
Education Experience: Bachelor's Desired
Employment Experience: 3-5 years
Licenses/Certifications: Not Applicable
FLSA Status: Exempt
Posting Date: 08/12/2019