Engineer Lead

Northwestern Mutual•Milwaukee, WI

1d•$193,835 - $248,400•Remote

About The Position

The Engineer Lead at Northwestern Mutual Life Insurance Company in Milwaukee, Wisconsin will serve as a technical hands-on Engineering Lead. Guide a team and participate in manual and automation testing of various data and analytics-based efforts. Lead, implement and drive data and analytics strategy across the organization. Conduct research to construct a presentable testing strategy for ongoing projects. Collaborate with all development and product leads to understand technology and product roadmap. Present a list of gaps, process improvements, goals, and hiring plans and implement the same. Work with landscape of data and data movement within Career Distribution. Build out entire features leveraging our current automation test framework and infrastructure (written in nodejs). Lead and mentor teams specific to engineering. Apply technical expertise in data testing and ETL. Work with live data streams. Utilize PowerBI, Informatica, SSIS, data modeling, data design, data management, Spark, Python, and AWS. Responsible for data framework architecture, data migration strategy and performance as well-as monitoring production performance and ensuring the accuracy of ongoing reporting layer for CRM Book of Business. Analyze, design, develop, deploy, and support software solutions and -frameworks on their supporting infrastructure. Set overall direction for data testing and quality within the Book of Business domain. Accountable for setting direction of metadata testing, data completeness testing, data quality testing, data transformation testing, incremental, performance and regressions data testing. Implement Python and Spark to accommodate new features in every PI by tracing test sets and test cases leveraging XRAY. Develop, review and debug T-SQL code, SSIS (SQL Server Integration Services) packages, SSAS (SQL Server Analysis Services) Cubes and Power BI reports with advanced row level security to integrate with CRM (Microsoft Dynamics) application. Work with Agile methodologies/DevOps environments. Coordinate performance testing, security testing and environment management across multiple integrated data streams. Build up CI/CD pipelines in GIT from scratch with quality gates that pull tests from JIRA.

Requirements

Bachelor's degree in Computer Science, Electronic Engineering or related field
Five years of experience as a test engineer or related occupation
Three years of experience with PL/SQL
Three years of experience with Unix shell scripting
Three years of experience with Informatica
Three years of experience with SSIS packages data testing
Three years of experience with Big data and Hive data testing
Three years of experience with Python and Spark
Three years of experience with AWS S3
Three years of experience with ETL and data warehouse concepts and testing
Three years of experience with GIT package creation
Three years of experience with Testing Maturity Model and SDLC leadership
Two years of Databricks experience

Responsibilities

Serve as a technical hands-on Engineering Lead.
Guide a team and participate in manual and automation testing of various data and analytics-based efforts.
Lead, implement and drive data and analytics strategy across the organization.
Conduct research to construct a presentable testing strategy for ongoing projects.
Collaborate with all development and product leads to understand technology and product roadmap.
Present a list of gaps, process improvements, goals, and hiring plans and implement the same.
Work with landscape of data and data movement within Career Distribution.
Build out entire features leveraging our current automation test framework and infrastructure (written in nodejs).
Lead and mentor teams specific to engineering.
Apply technical expertise in data testing and ETL.
Work with live data streams.
Utilize PowerBI, Informatica, SSIS, data modeling, data design, data management, Spark, Python, and AWS.
Responsible for data framework architecture, data migration strategy and performance as well-as monitoring production performance and ensuring the accuracy of ongoing reporting layer for CRM Book of Business.
Analyze, design, develop, deploy, and support software solutions and -frameworks on their supporting infrastructure.
Set overall direction for data testing and quality within the Book of Business domain.
Accountable for setting direction of metadata testing, data completeness testing, data quality testing, data transformation testing, incremental, performance and regressions data testing.
Implement Python and Spark to accommodate new features in every PI by tracing test sets and test cases leveraging XRAY.
Develop, review and debug T-SQL code, SSIS (SQL Server Integration Services) packages, SSAS (SQL Server Analysis Services) Cubes and Power BI reports with advanced row level security to integrate with CRM (Microsoft Dynamics) application.
Work with Agile methodologies/DevOps environments.
Coordinate performance testing, security testing and environment management across multiple integrated data streams.
Build up CI/CD pipelines in GIT from scratch with quality gates that pull tests from JIRA.

Benefits

100% Telecommuting available from anywhere in the U.S.
Salary $193,835- $248,400 per year.
Grow your career with a best-in-class company that puts our clients' interests at the center of all we do.
Northwestern Mutual is an equal opportunity employer that welcomes talented individuals of all backgrounds.
We are committed to creating and maintaining an environment in which each employee can contribute creative ideas, seek challenges, assume leadership and continue to focus on meeting and exceeding business and personal objectives.
At Northwestern Mutual, we believe relationships are built on trust. That our lives and our work matter.
These beliefs launched our company over 160 years ago.
Today, they're just a few of the reasons why people choose to build careers at Northwestern Mutual.
What started in Milwaukee, WI has grown into 7,000+ home office professionals split across 3 campuses: New York City, Franklin and downtown Milwaukee (HQ) - each one bringing with it its own unique talent and culture.
In a company with such a long and storied history, this may be the most exciting and important time to be a part of Northwestern Mutual as we are growing our digital and tech capabilities and are always on the lookout for bright, tech-savvy candidates.