Skip to main content

Sr. ETL Developer/Analyst

Permanent Position in Appleton, Wisconsin

Post Date: 02/13/2019

Rate: Not Specified

Education Level: Not Specified

Reference: Job # 158696


W2 Candidates only please

Title:  Sr. ETL Developer/Analyst

Location: Appleton, Madison WI or Minneapolis, MN or possible remote once established

Full-time Permanent position

Role and Responsibilities

The Solution Developer works to enhance and support the analytic products.

·         Implement ETL processes that populate star schemas using a variety of source data on data warehouse implementations supporting a product

·         Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process

·         Participates in the requirements gathering process and assist with designing the business process dimensional models 

·         Work with data providers to fill data gaps and/or to adjust source-system data structures to facilitate analysis and integration with other company data

·         Perform data profiling and source to target mappings

·         Perform analysis on source data to determine the feasibility of using this data to solve business needs

·         Write scripts for automated testing of data in the target facts and dimensions

·         Capture audit information during all phases of the ETL process

·         Write and maintain documentation of the ETL processes via process flow diagrams

·         Whatever else asked for the good of the company goals and initiatives

Qualifications and Education Requirements

·         Bachelor’s Degree in Computer Science or STEM majors, or 7+ years of equivalent work experience

·         Excellent verbal and written communication skills

·         Experience with relational database design/modeling

·         Experience interfacing with business users and gathering and understanding their requirements 

·         SQL coding/querying skills in SQL Server and/or MySQL, Oracle, Postgres

·         Experience in an Agile environment

About MATRIX

Whether you are actively pursuing new job opportunities, or simply seeking market insight or career advice, MATRIX has you covered. At over $200 million in revenue, we offer access to top-tier client companies, value-added services and benefits that rival or exceed those of even our largest competitors. To learn more about how MATRIX is making your job search experience better, click the banner below or visit https://www.matrixres.com/sites/default/files/infographic/index.html.

Please Note: Your resume will never be submitted to a client company without your prior knowledge and consent to do so.

MATRIX Infographic

Sr. ETL Developer/Analyst

Permanent Position in Appleton, Wisconsin

Job Overview

Post Date

02/13/2019

Rate

Not Specified

Education Level

Not Specified

Reference

Job # 158696

W2 Candidates only please

Title:  Sr. ETL Developer/Analyst

Location: Appleton, Madison WI or Minneapolis, MN or possible remote once established

Full-time Permanent position

Role and Responsibilities

The Solution Developer works to enhance and support the analytic products.

·         Implement ETL processes that populate star schemas using a variety of source data on data warehouse implementations supporting a product

·         Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process

·         Participates in the requirements gathering process and assist with designing the business process dimensional models 

·         Work with data providers to fill data gaps and/or to adjust source-system data structures to facilitate analysis and integration with other company data

·         Perform data profiling and source to target mappings

·         Perform analysis on source data to determine the feasibility of using this data to solve business needs

·         Write scripts for automated testing of data in the target facts and dimensions

·         Capture audit information during all phases of the ETL process

·         Write and maintain documentation of the ETL processes via process flow diagrams

·         Whatever else asked for the good of the company goals and initiatives

Qualifications and Education Requirements

·         Bachelor’s Degree in Computer Science or STEM majors, or 7+ years of equivalent work experience

·         Excellent verbal and written communication skills

·         Experience with relational database design/modeling

·         Experience interfacing with business users and gathering and understanding their requirements 

·         SQL coding/querying skills in SQL Server and/or MySQL, Oracle, Postgres

·         Experience in an Agile environment

About MATRIX

Whether you are actively pursuing new job opportunities, or simply seeking market insight or career advice, MATRIX has you covered. At over $200 million in revenue, we offer access to top-tier client companies, value-added services and benefits that rival or exceed those of even our largest competitors. To learn more about how MATRIX is making your job search experience better, click the banner below or visit https://www.matrixres.com/sites/default/files/infographic/index.html.

Please Note: Your resume will never be submitted to a client company without your prior knowledge and consent to do so.

MATRIX Infographic