Skip to main content

Data Warehouse Developer III

Technology
Codetech
Madison, United States1 week ago
Service contract

Job description

Candidates MUST be WI residents or willing to relocate to WI at their own expense prior to starting. This position can work 100% remotely (within the state of WI).

This recruitment is seeking an experienced ETL developer to work within the Enterprise section. The incumbent will be responsible for ETL design, development, testing, maintenance, metadata and implementation of data warehouse initiatives.

Skills

This developer must understand user requirements and be able to implement solutions that ensure requirements can be achieved through high-quality deliverables that support critical work to the organization. This will require working closely with other technical teams as well as program area partners in a collaborative manner. This person will work with minimal supervision and latitude for independent judgement.

They should have strong communication, organization, and leadership skills, be willing and able to assist peers, and demonstrate ability to mentor users who are less familiar with the system. Being a team player is a key skill for this role.

This person will develop ETL mapping specifications for loading information into the data warehouse and for ensuring reliability of information loaded. They will seek continuous improvement in performance and tuning of data warehouse processes and will work with the team to ensure warehouse data remains secure and all DCF security standards are followed. This developer will monitor technological advancements to ensure that solutions are continuously improved, supported, and aligned with industry and organizational standards.

Key responsibilities of the data warehouse developer include:

  1. Establishing and/or implementing data warehouse best practice standards, in collaboration with other Enterprise units or BITS teams.
  2. Demonstrate and leverage excellent analytical and problem-solving skills
  3. Working with relational and dimensional data models and slowly changing dimensions
  4. Providing strong data management and data analysis using SQL
  5. Exhibiting strong verbal and written communication, including facilitation of meetings and requirements gathering with technical and non-technical stakeholders.
  6. Showing effective interpersonal relationship management and the ability to collaborate with others and work as part of a team, as well as being able to communicate at many levels of the organization.
  7. Managing and tracking tasks to ensure on-time delivery of critical data warehouse or reporting products through excellent organizational and time management skills.
  8. Strong ability to work independently, assume responsibility for the timeliness and quality of work, research and resolve questions and problems individually or as part of the team.
Top 3-4 desired skills required for the position:
  1. Strong skills in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suite.
  2. Demonstrated skills in understanding and implementing data warehouse architecture, including programming in relational database technologies (e.g., Oracle, DB2, SQL Server)
  3. Clear knowledge of data integration strategies and solutions
  4. Exceptional experience building and supporting Collection-focused business intelligence products and experience with the State of Wisconsin referral/investigation lifecycle and claims processing is required.
Problem resolution, development and implementation

8 years

Excellent clear and concise communication skills, both technical and non-technical, written and verbally

8 years

Ability to self-direct and work independently using excellent organizational and analytical skills

8 years

Analytical/problem solving skills, including during pots-production periods

8 years

Experience in requirements gathering and analysis for data warehouses, including data analysis

8 years

Expertise in implementation of large, complex models and processes; experience with data warehouse design, development, and performance tuning

8 years

Experience with DB2

5 years

Experience in extract, transform, and load coding using Informatica PowerCenter and/or Data Management Cloud

8 years

Knowledge of Oracle PL/SQL

8 years

Ability to navigate and query a relational database (oracle) to develop and modify reports

8 years

Develop design specifications and demonstrate knowledge of Kimball data warehouse design principles

8 years

Develop test plans, test cases, and test procedures; conduct unit and system tests; interpret results

8 years

Ability to identify and resolve defects

8 years

Hands-on experience with Business Objects, Tableau or other business intelligence reporting tools

5 years

Required Skills : Data Analysis

Basic Qualification

Additional Skills

Background Check : No

Drug Screen : No

Interested in this role?