Complete Description:
RESPONSIBILITIES
Provide support to Business Analyst(s) in gathering and/or clarifying data and reporting requirements from business owners
Experience designing and developing reports including tabular reports, scorecards and dashboards
Ability to understand business needs and information and translate into a creative reporting solution
Develop reports in accordance with client requirements using Microsoft SQL Server Reporting Services (SSRS) 2008r2
Develop and maintain database stored procedures
Develop SQL queries and support ad hoc requests for data
Identify and troubleshoot business process or data quality issues that show up in the reports and subsequently communicate to resolve and eliminate problems.
Experience writing stored procedures, T-SQL, PL-SQL, functions, and SQL queries
Experience utilizing report writing best practices (optimization, use of joins and sub-queries)
Experience with manual testing to include User Acceptance Testing (UAT)
Ability to use complex expressions to calculate, group, filter, parameterize, optimize and format custom reports
Experience pulling data from Microsoft SQL Server 2008r2 and ORACLE databases for reports
Experience with cubes and drill down reports
Qualifications:
BS/BA in a technical field: Computer Science, Engineering or IT related discipline
2 years working in a data warehouse environment with business intelligence applications
5+ years of experience with report development using Microsoft SQL Server Reporting Services (SSRS) 2008r2
5+ Experience with SSRS Business Intelligence Developer Studio, Visual Studio, SQL Server Integration Services (SSIS), and/or other (non-Microsoft) reporting platforms
1yr Experience with Crystal Enterprise and migrating Crystal Reports to SSRS a plus
Interviews 2/6-2/9
Skills:
Skill
Required / Desired
Amount
of Experience
Experience working in a data warehouse environment with business intelligence applications
Required
2
Years
Experience with report development using Microsoft SQL Server Reporting Services (SSRS) 2008r2
Required
5
Years
Experience w/SSRS BI Developer Studio, Visual Studio, SSIS, and/or other (non-Microsoft) reporting platforms
Required
5
Years
Experience with Crystal Enterprise and migrating Crystal Reports to SSRS a plus
Desired
1
Years