Description

You will design and manage the Child Welfare Data Warehouse to support federal reporting, including NYTD, AFCARS, and NCANDS.

Responsibilities

• Design and load the data warehouse database model to support reporting and analytic needs.
• Develop ETL processes to move data from operational systems into a cleansed, consolidated warehouse.
• Collaborate with SACWIS/CCWIS developers to ensure operational databases support data extraction requirements.
• Build business intelligence applications, including dashboards, visualizations, and information analysis tools.
• Provide technical support and training to developers and end users on Teradata and BI development tools.

Required Skills

• 3+ years of experience with Teradata Cloud.
• 3+ years of experience with Business Objects XI and/or Power BI.
• 3+ years of experience performing ETL processes.
• Proven experience in Data Warehouse architecture and design.
• Ability to design and improve complex database queries.
• Bachelor's degree in a relevant field.

Preferred Skills

• Experience working within a Teradata Cloud version 17.20 environment.
• Familiarity with Business Objects XI 4.2 SP4 on Windows platforms.

Key Skills

Education

Any Gradute