See Job Openings

ETL Developer

  • Location: Sauk City, Wisconsin
  • Type: Direct Hire
  • Job #3207

Are you a proactive problem solver with analytical skills? Are you able to understand and discuss technical software issues with both internal customers and external vendors? Are you looking for a new challenge in the field of data warehousing? If so, Carex’s partner in WI has the opportunity for you.

Our partner is seeking an ETL Developer to join their Enterprise Data Management Department. This position will collaborate with data analysts, database administrators, and BI Developers within the company to design, develop and deliver ETL (Extract, Transformation, and Load) applications using data warehouse design best practices. This role will also analyze data requirements, complex source data, target data models and is responsible for the design, development, and maintenance of ETL processes for the EDW (Enterprise Data Warehouse), data marts, and outbound data delivery.

Benefits:

  • Team-oriented work environment that fosters high performance and employee engagement with a customer focus, while ensuring a healthy work-life balance.
  • Option to work in-person, hybrid, or telecommute available
  • Starting Salary Range based upon skills and experience: $71,000 – $90,000 / year

What you’ll do:

  • Translate data movement requirements into technical ETL design
  • Develop ETL workflows and mappings to extract, transform, and load data into target environments
  • Develop test plans and perform unit testing of own work
  • Create supporting documentation for new ETL processes
  • Identify opportunities for improving efficiency and effectiveness of processes and controls
  • Use standard ETL toolsets to develop and test ETL workflows
  • Determine impacts of data warehouse structures and information flows due to changes in business or technical requirements
  • Perform root cause analysis and contribute to the remediation planning and implementation
  • Perform data quality analysis, report data quality issues, and propose solutions for data quality management

 

What you’ll bring:

  • Bachelor’s degree in computer science or related field (relevant experience and continuing education related to the position will be considered in lieu of education requirement)
  • 3+ years of Information Technology experience
  • 3+ years of experience using ETL software or equivalent data integration processes
  • 3+ years of experience working with normalized relational databases and dimensional data warehouse implementations
  • 3+ years of complex SQL query development experience, preferably on multiple database management platforms
  • 3+ years of experience translating business and data requirements into technical solutions
  • Working knowledge of data warehousing concepts, data structures, and ETL best practices concepts
  • Proficiency in ETL tools (Informatica PowerCenter preferred, IBM InfoSphere DataStage, Pentaho, Talend or similar)
  • Ability to manage multiple projects simultaneously and delivery results in a timely manner
  • Ability to understand and discuss technical software issues with others
  • Ability to work independently, under pressure, and be adaptable to change
  • Effective interaction with external and internal parties, including vendors and contractors

#LI-TB1

Attach a resume file. Accepted file types are DOC, DOCX, PDF, HTML, and TXT.

We are uploading your application. It may take a few moments to read your resume. Please wait!