Data Analyst - 14709

The Data Analyst position is responsible for working within the Information Technology group, participating in a team responsible for report generation and data analysis utilizing database management software/tools against various database platforms. Job Description: Responsible for regularly scheduled reporting (daily, weekly, monthly) for internal and external purposes, as well as ad-hoc reports for internal departments utilizing various DB reporting tools, such as MSSQL, Crystal Reports Enterprise, Oracle SQL Developer, Access, Excel, etc. Develops processes for reports, creates wiki documentation and provides training on said processes to satisfy reporting requests and/or to automate manual processes for efficiency and accuracy. Creates and implements solutions which may include database objects, custom report design (utilizing SSRS for example) and automation of reporting tasks (via a regularly scheduled MSSQL job calling multiple stored procedures for example). Contributes to the development of project plans and may assign and monitor tasks. Assists in the development and generation of new reports to be provided to senior management across functional departments. Requirements: Bachelor’s degree in Information Systems or related discipline required. 3+ years of experience in mastering database management software/tools, including proficiency in SQL query building and report writing. Must be proficient with MSSQL stored procedure creation, job creation, and general report automation. Familiarity with advanced MSSQL features (linked servers, dbmail, bcp) to use in automating data delivery, file creation, notifications. Must be proficient with MSSQL Server tools (SSIS/Integration Svcs, SSRS/Reporting Svcs). Must be proficient with creating and modifying Crystal Reports. Familiarity with Business Objects/Crystal Reports Enterprise Server, scheduling reports. Familiarity with Open Database Connectivity (ODBC) creation/usage. Familiarity with Microsoft Access table creation, queries, macros, forms and reports, Visual Basic for Applications (VBA). Familiarity with MSSQL (2000/2005/2008) and Oracle (10G/11G) Databases.