Description

You will design and maintain the data warehouse architecture to support federal reporting, analytics, and business intelligence requirements.

Responsibilities

• Design and load data warehouse models to support reporting and analytics needs.
• Implement and maintain ETL processes for data migration from operational systems.
• Develop business intelligence applications, reporting dashboards, and data visualizations.
• Adapt the warehouse structure to align with evolving SACWIS/CCWIS systems.
• Optimize database queries and provide technical support for federal reporting such as NYTD, AFCARS, and NCANDS.
• Conduct training sessions on Teradata and BI tools for developers and end users.

Required Skills

• 3+ years of experience with Teradata Cloud (version 17.20 preferred).
• 3+ years of experience with Business Objects XI 4.2 SP4 and/or Power BI.
• 3+ years of experience performing ETL processes in a data warehouse environment.
• Deep knowledge of data warehouse modeling, data integration, and data architecture principles.
• Hands-on experience supporting federal reporting initiatives including NYTD, AFCARS, and NCANDS.
• Proven ability to work with SACWIS/CCWIS system developers and contract staff.
• Strong communication skills for technical training and cross-departmental coordination.

Preferred Skills

• Experience in government or public sector data environments involving SACWIS/CCWIS.
• Familiarity with Windows 2012 virtual platforms and shared data environments.
• Teradata, Business Intelligence, or Data Warehousing certifications.

Key Skills

Education

Any Gradute