Data Warehousing SQL Data Management Relational Database Developer

Data Warehouse Developer III (DCF Child Care Child Welfare Section)

Location:

Madison, WI | Type:
Contract | Duration: 12 months | Start: 7/1/2026 | End: 06/30/2027

Responsible for ETL design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Understand user requirements and implement solutions ensuring high-quality deliverables. Develop ETL mapping specifications for loading information into the data warehouse and for ensuring reliability of information loaded. Seek continuous improvement in performance & tuning of data warehouse and ensure data security. Monitor technological advancements to ensure solutions are continuously improved, supported, and aligned with industry and company standards.

Conduct highly complex work critical to the organization. Work with other IT technical teams and business users to understand requirements and recommend/implement solutions. Work with moderate supervision with latitude for independent judgment. Assist less experienced peers by providing technical guidance. Requires advanced skill sets and developing proficiency within discipline. Typically requires 6-9 years experience or equivalent education.

• Established data warehouse best practice standards
• Strong skills working with relational and dimensional data models
• Experience with slowly changing dimensions
• Data management and analysis using SQL
• Verbal and written communication skills, including facilitation of meetings with customers and technical staff
• Requirements gathering knowledge and skills
• Effective interpersonal relations skills, ability to collaborate and work as part of a team
• Navigation of large organization to accomplish results
• Initiation and follow-through on complex projects of short and long term duration
• 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 supervisor informed
• Ability to complete substantial depth and complexity projects and work with customers at many levels in the organization

• Problem resolution (development and implementation): 7 years
• Respond to customer requests (verbally and in writing): 7 years
• Self-directed: 7 years
• Work independently: 7 years
• Analytical/problem solving skills: 7 years
• Technical writing and documentation: 7 years
• Excellent oral and written communication skills: 7 years
• Implementation of large complicated models and processes: 5+ years
• Data analysis: 7 years
• Data Warehouse design and development: 7 years
• Data Warehouse requirements gathering: (years unspecified)

EOE. Protected Veterans/Disability.