Job id : PA-572580 (96590813)
SSRS Developer with SSIS, Visual Basic, Oracle, PL/SQL, TOAD, T-SQL, SQL Server Management Studio, data modeling, report server configuration and security Experience
Location: Harrisburg, PA (DEP)
Duration: 10 months
Positions: 1 (1/2)
SkillRequired / DesiredAmountof Experience
Application designRequired12Years
4 year college degree or equivalent technical study with advanced studyRequired
Extensive experience with Microsoft tools, with in-depth SSRS development knowledge and SQL Server Integration Services to perform ETL operationsRequired8Years
Experience with Microsoft Visual BasicRequired8Years
Experience handling large datasets and reporting based on various data sourcesRequired8Years
Experience working with Oracle databases and PL/SQL using TOAD or SQL DeveloperRequired5Years
Experience working with SQL Server databases and T-SQL using SQL Server Management StudioRequired5Years
Experience with data modeling and the ability to analyze and understand database designRequired5Years
Clear and precise communication needed to present data results and train business usersRequired
Experience with report server configuration and securityHighly desired
A SQL Server Reporting Services (SSRS) Developer creates reports that efficiently fulfill the requirements of the business users within the departments which the Conservation & Environment Service Center, Bureau of Information Technology (IT) supports. This developer develops complex queries within Oracle and SQL Server environments and optimizes queries for faster performance. The developer also provides data analysis and data integration activities to ensure that data is complete, accurate and available for delivery via an SSRS report.
Responsibilities include:
•Develops new SSRS reports and database objects against complex enterprise databases (both SQL Server and Oracle) and modifies or enhances existing SSRS reports and database objects as assigned
•Demonstrates experience with the design of relational and multidimensional database
•Demonstrates proficiency in performance tuning to ensure quality and performance of SSRS reports
•Tests the SSRS reports and database objects created and maintained by the service center thoroughly prior to user testing.
•Applies Agile development principles
•Works with business users to gather and document requirements and ensures solutions meet their business needs
•Assists in designing reporting database solutions for the service center and configuring report servers and security
•Researches functionality in new software releases and performs, documents, and assists other staff in the upgrade processes.
•Uses Visual Studio Team Foundation Services for source control and work items and provides project statuses and project time estimates to the reporting section supervisor
•Adheres to any standards set by the Service Center and the Governor’s Office of Adminstration
•Demonstrates analytical and customer service skills
•Demonstrates excellent verbal and written communication skills
•Ensures that best practices are maintained and mentors team members on the best practices, standards, and IT processes
•Documents all work for future reference
•Independently executes all tasks and work assignments
Skills required:
•Extensive experience working with Microsoft tools, with in-depth SSRS development knowledge and SQL Server Integration Services to perform ETL operations
•Experience with Microsoft Visual Basic
•Preferred experience with report server configuration and security
•Extensive experience handling large datasets and reporting based on various data sources
•In-depth experience working with Oracle databases and PL/SQL using TOAD or SQL Developer
•In-depth experience working with SQL Server databases and T-SQL using SQL Server Management Studio
•In-depth experience with data modeling and the ability to analyze and understand database design
•Clear and precise communication needed to present data results and train business users on report functionality
•4 Year College Degree