Colorful Dots, LLC Albany , NY 12201
Posted 1 week ago
Senior Database Architect: Special Supplemental Nutrition Program for Women, Infants & Children (WIC)
Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
Senior 60-84 Months:
Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education.
Daily Tasks will include but not be limited to the following:
Work in conjunction with the project data migration lead to conduct data analysis of both current and to-be WIC systems, in order to maintain an understanding of current and future needs.
Collaborate with customers, vendors, and technical workgroups to identify and document data and reporting requirements, reporting processes, gap analysis, and prioritization of reporting needs.
Create documents describing business flow and function using flow charts and data/process models describing these business functions.
Develop ETL mappings for migration of data from SYBASE, MS ACCESS to Oracle.
Create report and dashboard prototypes.
Participate in development of solutions to meet end user reporting requirements
Develop data test protocols, including test plans, creation and execution of test scripts, scenarios, and test plans that validate initial business requirements. Test report accuracy and document test results.
Evaluate implementation strategies and document issues requiring resolution.
Schedule, facilitate, and record report development meetings as needed.
Colorful Dots, LLC