SQL (SSRS) Report Writer

Ohio  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

Beacon Hill Technologies has a 3 month contract opportunity for a SQL Report Writer. 

Position Summary & Essential Duties:
The Report Writer works with customers and peers to design, develop, modify and test data reports and models that meet the customer's needs. The role requires the complete understanding of complex large scale data models for enterprise systems and the underlying business processes.

Other duties:

  • Works with Business and Technical teams to understand requirements, analyze data and provide valid report designs
  • Develops reports using Microsoft SQL Reporting Services platform (SSRS), MS Excel, Pivot tables and other intuitive graphical add-ons
  • Writes data retrieval programs to import, extract, and transfer or load data from heterogeneous data sources including Oracle, SQL Server, Interface Engine, Microsoft Access, Text files, etc.
  • Implements reliable data extraction processes, schedules for generating standard reports, and methods of efficient distribution based on agreed upon timelines and according to specification
  • Provides technical support in retrieving data from SQL and MS Access databases in T-SQL as may be required.
  • Proactively identifies and address scalability and performance bottlenecks to support fast-growing data volumes
  • Coordinates efforts with DBA in scheduling jobs and processes
  • Ensures report products are efficient and meet all regulatory and security requirements
  • Documents data extraction and output specifications for reports based on analysis of end-users' requirements.
  • Creates and maintains functional and technical documentation including Report Design Specifications, Operation Manuals, Release Notes, Security Requirements, etc.
  • Partners with the Project Management Office and participates in all phases of project implementation
  • Utilizes and maintains appropriate change control procedures and standards
  • On-call duties as required

Education:
Bachelor degree in Computer Science/Business Management required.

Experience & Knowledge:
1+ years experience in IT Healthcare desired.
Ability to research and analyze information.
A minimum of 2 years of experience with report development using Microsoft SQL Server Reporting Services (SSRS)
Must work at a very high level of accuracy and have a broad knowledge of technical workings of database structure and reporting protocols.
Experience using report writing best practices (optimization, use of joins and sub-queries)
In depth understanding and experience with Crystal Reports server and SQL Server Reporting services.
Experience writing stored procedures, T-SQL, functions, and SQL Queries
Ability to use complex expressions to calculate, group, filter, parameterize, optimize and format custom reports
Experience pulling data from Microsoft SQL Server databases for reports
Experience with reports development using current SSRS technology

Start date
n.a
Duration
3 months
From
Generic Network
Published at
15.11.2011
Project ID:
268219
Contract type
Freelance
To apply to this project you must log in.
Register