Report Writer / Analyst

DEPARTMENT: Information Technology
REPORT TO: IT Manager
STATUS: Full Time
UNION AFFILIATION: Non-Union

ESSENTIAL FUNCTIONS:
1. Gather reporting requirements from the requestor, share report options with the requestor

2. Create mock-up reports for review.

3. Validate and test data sets used in all reporting Work with internal customers to extract data from multiple data sources

4. Ensures that deliverables are met within project plan guidelines

5. Provide information regarding report findings to supervisor

6. Conduct research and analysis of application, system and customer data per request from other business groups

SKILLS REQUIRED:
1. Excellent working knowledge of data structure, relational data bases, stored procedures and views, Microsoft SQL 2000, 2005

2. Strong analytical ability

3. Ability to work independently as well as in a Team environment

4. Ability to write routine reports and correspondence

5. Excellent oral and written communication skills

6. Creating reports in dynamic web pages a plus

7. Assist with other tasks as needed

EXPERIENCE REQUIRED:
1. 3 years experience writing reports using a variety of reporting tools, Crystal, SQL Reporting Services preferred

2. 2+ years using SQL to query complex relational databases and validate reporting results

3. Minimum 2-3 years of custom reporting design and implementation experience with PS Query, SQL Crystal Reports

EDUCATION REQUIREMENTS: BA/BS or equivalent experience