Data Warehouse Developer III

Codetech•Madison, WI
•Remote

About The Position

The Data Warehouse Developer III assists with the design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. The role translates user requirements into high-quality deliverables, develops ETL mapping specifications for loading information into the data warehouse, and ensures the reliability and security of loaded data. The developer works with IT technical teams and business users to understand requirements, recommend solutions, and implement them. The work is closely supervised, with some latitude for independent judgment. Candidates must be Wisconsin residents or be willing to relocate to Wisconsin at their own expense before starting. The position can be performed 100% remotely within Wisconsin.

Requirements

  • Typically requires at least 4 to 5 years of experience or equivalent education.
  • Knowledge of data warehouse best-practice standards and experience in data warehouse design and development, requirements gathering, and performance tuning.
  • Experience with IDMC (Informatica Intelligent Data Management Cloud) and Informatica PowerCenter.
  • Moderate skills working with relational and dimensional data models and slowly changing dimensions.
  • Knowledge of Kimball data warehouse design principles.
  • Experience programming mainframe applications using technologies such as COBOL and DB2 databases to maintain and enhance mainframe functionality.
  • Experience with DB2 and the ability to navigate and query relational databases, including Oracle, to develop reports.
  • Knowledge and skills in the project development life cycle, including planning, analysis, design, coding, testing, implementation, and support, and in system development life-cycle deliverables for each phase.
  • Demonstrated knowledge and skills in requirements gathering.
  • Expertise implementing large, complicated models and processes.
  • Ability to develop design specifications and perform data analysis.
  • Strong verbal, oral, and written communication skills, including facilitating meetings with customers and technical staff.
  • Effective interpersonal skills and the ability to collaborate and work as part of a team.
  • Ability to navigate a large organization to accomplish results.
  • Ability to initiate and follow through on complex short- and long-term projects.
  • Excellent organizational and time-management skills.
  • Excellent analytical and problem-solving skills.
  • Ability to work independently, assume responsibility for job development and training, research and resolve questions and problems, request supervisor input, and keep the supervisor informed.
  • Proficiency with the MS Office suite, MS Visio, and MS Outlook.
  • State of Wisconsin privacy regulations.

Nice To Haves

  • Demonstrated experience designing and using performance measures and reports.
  • Experience with Business Objects or other business intelligence tools.
  • Experience with dashboarding or Tableau.

Responsibilities

  • Assist with ETL design, development, testing, maintenance, metadata, and implementation for data warehouse initiatives.
  • Understand user requirements and implement solutions that meet them through high-quality deliverables.
  • Develop ETL mapping specifications for loading information into the data warehouse and ensuring the reliability of loaded information.
  • Seek continuous improvement in data warehouse performance and tuning, and ensure data security.
  • Work with IT technical teams and business users to understand requirements, recommend solutions, and implement them.
  • Gather requirements and develop design specifications.
  • Develop test plans, test cases, and test procedures; identify defects; and develop and implement quality assurance processes and procedures, including test and use cases.
  • Respond to customer requests verbally and in writing.
  • Navigate and query relational databases to develop reports.
  • Research and resolve questions and problems, follow through on complex projects, and keep the supervisor informed while requesting input as appropriate.
  • Prepare technical writing and documentation.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service