*Client Name: Department of Public Instruction* *Tracking Number: TSS-000964*
*Location: Raleigh, NC* *Duration: 12 Months* * * *Description:* The Common Education Data Analysis and Reporting System (CEDARS) will be the first state level education data warehouse in North Carolina. It will collect data from roughly 23 systems of original entry and feed them into databases designed for both Operational and Longitudinal analysis. The position will be the primary Database Reports Developer for the CEDARS Reports Project and will require strong analysis with report writing DBA skills. As such, the candidate will be charged with understanding how data is mapped from source systems, through the Extraction Transform Load (ETL) process, to the data warehouse. Additionally, the candidate is expected to understand how data maps from source systems to the various DPI reports that are generated from the data warehouse. The candidate will be the key resource that DPI will depend upon to coordinate data structural changes with the CEDARS data warehouse vendor, including but not limited to the addition of new data fields from existing and new source systems, deletion of data fields from the data warehouse, and changes to the format of data fields in the data warehouse. Finally, this candidate will support the modification of existing CEDARS reports and the creation of new reports to meet end user business needs. *Knowledge, Skills, and Abilities Requirements: * *Minimum 3 years skills/knowledge/experience with the following: • Report Writing, with experience using Oracle Business Intelligence Enterprise Edition (OBIEE) tools. *• Data Warehousing schema and concepts *• Extraction Transform Load (ETL) processing* *• Database-to-Enterprise Service Bus (ESB) integration* • Database design and Database modeling • Creation of data marts • Connectivity of database infrastructure to other system components & applications • Database Performance Analysis and database performance tuning, particularly for Data Warehouse database configurations. • SQL tuning • Ability to effectively provide technical documentation • Ability to work independently • Possess good organization and communication skills. *Must possess traits that are critical for successful performance in this position: Reliability, initiative, attention to detail and professionalism. * *Preferred:* • Prior use of automated software/bug-tracking software • Ability to use defect and change tracking software tools. • Excels in documenting code. If this sounds interesting kindly send me the following details: - *Resume in Word Format* ** - *Full Name:* ** - *Hourly Rate:* ** - *Current Location:* ** - *Visa Status (H1-B/Green Card/U.S Citizen):* ** * * *Best Regards,* * * *Ram* *MGL Americas Inc.,* *1249 South River Road**, * *Suite** 102**, Cranbury, NJ 08512* *Phone: 609-395-8562* *Fax: 609-860-6414* *E-mail:[email protected] <e-mail%[email protected]>* ** *www.mgl.com * * * *Disclaimer: If you do not wish to receive these emails in the future, please reply with "REMOVE" in the subject line and include all email addresses to be removed in the message text. We apologize for the inconvenience*. -- To unsubscribe, reply using "remove me" as the subject.
