Brunswick ETL Developer in Fond Du Lac, Wisconsin

It is our people behind life’s passions who will make the big difference. If you are interested in becoming part of a company that delivers market leading products, driving your own career and working with brands committed to active lifestyles, then you’ve found your fit.

Have what it takes? Join us.

BASIC ACCOUNTABILITY STATEMENT The main role of this position will be to provide technical and analytical expertise for development, support and administration for the Mercury Marine and Brunswick data warehouse applications and/or development tools. The ETL developer handles development and delivery of data from operational systems and files into staging area, Data Warehouse, and downstream subject areas and files. This position reports to the Business Intelligence Manager.

DUTIES AND RESPONSIBILITIES

  • Work closely with the Data architect to develop plans for transactional data extraction and loads into to data warehouse

  • Design, build and maintain ETL processes using Informatica PowerCenter

  • Day-to-day maintenance, support, and enhancement of the existing reporting environment. The candidate must be a professional self-starter who has a strong data warehouse background and can translate customer's needs into technically sound data warehousing and reporting.

  • Ensure data quality through creation of proactive monitoring and data cleansing techniques

  • Need to be able to write and/or evaluate SQL to ensure proper implementation of business rules and assist the test team with data validation

  • Identify and recommend database performance solutions for slow running code and SQL

  • Be on call for data warehouse ETL problems that require immediate resolution

WHAT YOU NEED TO BRING TO OUR WINNING TEAM:

Basic Qualifications:

  • College degree in computer science, information systems, or computer engineering

  • Working knowledge of Oracle e-business Order Management or Financial modules

  • 5+ years of deployment experience in Business Intelligence and Data Warehouse tools

  • Possess understanding and familiarity with Data Warehouse design concepts and Multidimensional Modeling.

  • Ability to convert technical specifications into ETL mappings

  • Strong experience in relational Databases (SQL Server/Oracle 11g, 12c)

  • Strong experience in Informatica PowerCenter, TOAD, Visio, Excel, Word, PL-SQL, SQL

  • Strong technical experience in one or more of the following Oracle Business Intelligence (OBIEE), Business Objects, Discoverer, Cognos

  • Ability to work in a complex and changing environment.

  • Excellent communication and interpersonal skills required

  • Possess good analytical and problem solving abilities

  • Strong team collaboration skills to ensure an efficient development and implementation process

  • Familiarity with the complete data warehouse development life cycle and best practices

  • Troubleshooting performance related issues with reports and data

  • Migration of repositories, reports and connections to different environments

Preferred Qualifications:

  • Experience using OBIEE with a data warehouse, relational table structures, and OLAP data structures

  • Pre-built OBIEE Financial, Order Management, or Enterprise Asset Management Analytics Apps

  • DAC (Data warehouse Access Control)

  • Experience with Agile project management methodologies

  • Analytics design and OBIEE Answers development

  • In-depth technical knowledge of network, PC, and platform operating systems, including AIX, Unix, Linux

  • Configuring dynamic aggregation with logical dimensions and facts

  • Interest and/or experience using Data Lake technologies such as Hadoop, Sqoop, Hive, Impala

We are the people behind life’s passions.

Brunswick does not accept applications, inquiries or solicitations from unapproved staffing agencies or vendors. For help, please contact our support team at: hrservicecenter@brunswick.com or 1-888-735-4767.

Equal Opportunity Employer: Minorities/Women/Protected Veterans/Disabled

EEO is The Law - click here at http://www1.eeoc.gov/employers/upload/eeocselfprint_poster.pdf for more information

Brunswick at http://www.brunswick.com/privacy.php and Workday Privacy Policies

#Brunswick Corporation - Mercury Marine

Brunswick Corporation (NYSE:BC) is home to the people behind life’s passions. Our company is made up of some of the world’s leading lifestyle brands in categories such as recreational boats, marine engines, fitness equipment, active recreation, and activated workplace products. While we are family to 14,000 employees around the world, three divisions in more than 30 countries create a local environment, with our global headquarters in the Chicago suburb of Mettawa, IL.