SQL Developer/Business Analyst

SUMMARY: The SQL Developer/Business Analyst is responsible for the on-going support and enhancement of College Success Foundation's reports, data collection, and data mapping for our SQL system. The SQL Developer/ Business Analyst will be expected to complete and implement reports using SQL Server 2005/2008, SQL Reporting Service, and Microsoft Excel as assigned with minimal supervision. This position will also work collaboratively with the Information Technology (IT) Data team, Research & Evaluation team, and Foundation staff to support the operation and report needs of the Foundation.

PRIMARY DUTIES AND RESPONSIBILITIES:

• Review reporting requests and works with the Research & Evaluation team and customers to determine basic characteristic requirements such as report type and layout, data design and source origin and reporting frequency, distribution and purpose or function of the reports.
• Design and develop complex SQL Server stored procedures, functions, views and triggers to be used with ETL and reporting processes.
• Design, construct, test, implement and enhance reports, develop subscriptions while delivering on-time and in accordance with established reporting standards. Design and develop reports in MS SQL Reporting Services (SSRS) using Visual Studio and other report tools as required.
• Maintain and update existing reports to reflect changing business requirements.
• Recommend new or modified reporting methods and procedures to improve report content and accuracy.
• Develop, design, tune and maintain SSIS packages to perform the ETL process.
• Backup and restore databases across multiple virtual servers.
• Monitor monthly data warehouse staging loads to insure complete loads troubleshoots and documents when errors occur.
• Manage the deployment of SSAS cubes and troubleshoots issues as needed.
• Clean and manipulate large data sets using Excel formulas, maps and updates data in transactional databases using UI tools, SQL statements and ETL packages.
• Correct end user errors.
• Recommend and develop new SQL jobs to audit data entry and maintain data integrity.
• Contributes to census reporting.
• Maintain and create system documentation, track projects, and change control management in Team Foundation Services.
• Interact with all teams within the organization and provide them with reporting templates, reporting needs, and data storage requirements for data systems.
• Attend weekly meetings to report on the status of assigned projects.
• Performs other duties as assigned.