Job Description :
Direct End Client: State of Pennsylvania
Job Title: Senior SQL Reports Developer
Duration: 8 months
Start Date: 10/29/2018
Location: Dauphin County,PA
Position Type: Contract
Interview Type: Webcam or In Person or Telephonic
Requirement ID: SPA_SSRS268_VB

Required Skills:
12 Years Experience Application design
4 year college degree or equivalent technical study with advanced study
8 Years Extensive experience with Microsoft tools, with in-depth SSRS development knowledge and SQL Server Integration Services to perform ETL operations
8 Years Experience with Microsoft Visual Basic
8 Years Experience handling large datasets and reporting based on various data sources
5 Years Experience working with Oracle databases and PL/SQL using TOAD or SQL Developer
5 Years Experience working with SQL Server databases and T-SQL using SQL Server Management Studio
5 Years 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
Experience with report server configuration and security

Department: Pennsylvania Department of Environmental Protection

Description: 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:
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 tho oughly 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 skillsEnsures 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


V Group Inc. is an IT Services company which supplies IT staffing, project management, and delivery services in software, network, help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/contracts with the following states: AR, CA, DE, FL, GA, IL, KY, MD, ME, MI, NC, NJ, NY, OH, OR, PA, SC, TX, VA, and WA. If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant. Please share my contact information with others working in Information Technology.

Website:
Twitter: VGroupITServices@VGroupITService
Facebook:
             

Similar Jobs you may be interested in ..