If you are interested in this position:
Download the skills matrix using the button below and fill it out.
Email us and attach the completed skills form and your most recent resume to us at:
email@example.com Please include '8308WI Skills Form' and your name in the subject line.
Wisconsin Department of Children and Families (DCF)
Phone, Webcam, or On-Site
Local candidates or willing to relocate at their own expense. This position is currently 90% Remote (hybrid). However, subject to change. Candidate must be available to be on-site as needed. On call hours may be required. Must reside in Wisconsin from day one.
Our client is looking for a Data Warehouse Developer to be responsible for assisting in ETL design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. This is a Career-Development position within field. Requires moderate skill sets and developing proficiency within discipline.
Understand user requirements and implement solutions that ensure requirements can be achieved through high quality deliverables.
Candidate will 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 security of data. Works with other IT technical teams and Business users to understand requirements and recommend & implement solutions.
Design, develop, and maintain relational databases for data storage and data mining.
Perform data warehouse design and testing, including data design, database architecture, metadata, and repository creation.
Develop processes and procedures for entering information into data warehousing systems and for ensuring reliability of information entered.
Conducts tasks and assignments as directed.
Ideal candidate will have
Knowledge in data warehouse best practice standards
Moderate skills working with relational and dimensional data models
Moderate skills working with slowly changing dimensions
Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff
Knowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support)
Demonstrated knowledge and skills in requirements gathering
Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team
Skills in navigating a large organization in order to accomplish results
Ability to initiate and follow through on complex projects of both 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, researching and resolving questions and problems, requesting supervisor input and keeping supervisor informed
Proficiency with MS Office suite, MS Visio, and MS Outlook
Excellent organization, analytical and communication skills
4-5 years - Experience in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suite
Developing skills in the architecture of data warehouse and data integration strategies and solutions
Knowledge in relational database technologies, e.g. Oracle, DB2, SQL Server
Strong data management and data analysis using SQL
2 years - Expertise in implementation of large, complicated models and processes
3 years - Experience in technical writing and documentation
3+ years - Develop design specifications
4+ years - Data Analysis
4+ years - Experience in data warehouse design and development
4+ years - Experience in requirements gathering for data warehouse
4+ years - Experience in Data Warehouse Performance tuning
4+ years - Informatica
2 years - DB2
2+ years - Knowledge of Kimball data warehouse design principals
3+ years - Ability to navigate and query a relational database (Oracle) to develop reports
2+ years - Demonstrated experience in the design and utilization of performance measures and reports
3+ years - Business Objects or other BI tools
2+ years - Dashboarding/Business Objects Xcelsius
3+ years - Respond to customer requests (verbally and in writing)
3+ years - Develop Test Plans, Test Cases, and Test Procedures
3+ years - Identify defects
3+ years - Ability to develop and implement quality assurance processes and procedures including test/use cases
3+ years - In-depth knowledge of system development life cycle deliverables for each phase of development