Database analyst Jobs in Lansing, MI

Description of the requested work, including deliverables and knowledge transfer Technical support is required to assist with the following tasks: Maintaining and enhancing the current OEAA Secure Site. Maintaining data quality and migrating data between all data sources. Develop interfaces with contractor systems. Preparing and validating test case scenarios throughout the contractor transition. Retrieve data from a variety of data sources: , SCM, Graduation Rate/Drop Out Rate, School Improvement, Indicator Data, etc. Analysis and manipulation of AYP data. Maintaining and enhancing the current Adequate Yearly Progress (AYP) website. Create Ad-hoc queries in response to MDE data requests. Execution of system environment testing. Develop and execute SQL Server 2000/2005 DTS/SSIS packages. Share developed technology solutions with the OEAA team as needed. Adhere to documentation processes and procedures identified within OEAA methodology. Adhere to source code management processes and procedures. Monitoring data received from vendors, schools and districts. Generate and create public reports with data received from contractors. Provide technical support for other education-related applications, as needed. D. Location where the work is to be performed Lansing, MI 48933 E. Hours Monday to Friday, 8:00 am to 5:00 pm G. The numbers of personnel by skill set (classification), Two Senior Programmer Analysts Programmer – Analyst Senior (two) Programmer-Analyst capabilities with 8 or more years of experience, relies on experience and judgment to plan and accomplish goals, performs a variety of complicated tasks, may lead and direct the work of others, may report directly to a project lead or manager, a wide degree of creativity and latitude is expected. Minimum of 5 years experience with: · Visual Basic/ 1 ASP/ 2 HTML 3 MS SQL Server 2000/2005, Minimum of 2 years experience with: · Educational assessment data and systems is preferred 1 Maintaining data quality and migrating data between all data sources. 2 Documentation processes and procedures 3 Source code management processes and procedures 4 Test-Driven Development 5 Object Role-Modeling 6 Entity Relational Modeling Certifications: Bachelor of Science in Computer Science or equivalent Required Other skills/experience: Must have thorough experience with software system development life cycle (SDLC) including thorough experience with software development quality assurance and testing. Ability to work in a team environment Ability to work independently Excellent written and verbal communication skills Must be willing to work extra hours, as necessary Must be able to mentor and train H. Start and End Dates for the work August 19, 2008 to August 18, 2009 (2,080 hours), Best Regards, Description of the requested work, including deliverables and knowledge transfer Technical support is required to assist with the following tasks: Maintaining and enhancing the current OEAA Secure Site. Maintaining data quality and migrating data between all data sources. Develop interfaces with contractor systems. Preparing and validating test case scenarios throughout the contractor transition. Retrieve data from a variety of data sources: , SCM, Graduation Rate/Drop Out Rate, School Improvement, Indicator Data, etc. Analysis and manipulation of AYP data. Maintaining and enhancing the current Adequate Yearly Progress (AYP) website. Create Ad-hoc queries in response to MDE data requests. Execution of system environment testing. Develop and execute SQL Server 2000/2005 DTS/SSIS packages. Share developed technology solutions with the OEAA team as needed. Adhere to documentation processes and procedures identified within OEAA methodology. Adhere to source code management processes and procedures. Monitoring data received from vendors, schools and districts. Generate and create public reports with data received from contractors. Provide technical support for other education-related applications, as needed. D. Location where the work is to be performed Lansing, MI 48933 E. Hours Monday to Friday, 8:00 am to 5:00 pm G. The numbers of personnel by skill set (classification), Two Senior Programmer Analysts Programmer – Analyst Senior (two) Programmer-Analyst capabilities with 8 or more years of experience, relies on experience and judgment to plan and accomplish goals, performs a variety of complicated tasks, may lead and direct the work of others, may report directly to a project lead or manager, a wide degree of creativity and latitude is expected. Minimum of 5 years experience with: · Visual Basic/ 1 ASP/ 2 HTML 3 MS SQL Server 2000/2005, Minimum of 2 years experience with: · Educational assessment data and systems is preferred 1 Maintaining data quality and migrating data between all data sources. 2 Documentation processes and procedures 3 Source code management processes and procedures 4 Test-Driven Development 5 Object Role-Modeling 6 Entity Relational Modeling Certifications: Bachelor of Science in Computer Science or equivalent Required Other skills/experience: Must have thorough experience with software system development life cycle (SDLC) including thorough experience with software development quality assurance and testing. Ability to work in a team environment Ability to work independently Excellent written and verbal communication skills Must be willing to work extra hours, as necessary Must be able to mentor and train H. Start and End Dates for the work August 19, 2008 to August 18, 2009 (2,080 hours), Best Regards,