SQL Report Writer with SSRS

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

Keywords

Description

Our Irving, TX Client is seeking a Report Writer for a 6 Month Contract to hire position.

The candidate for this open Report Writer position in our client's HRIS group must have the following experience to be considered.

True experience within an HRIS group would be nice.

Must be able to provide clear examples of each of these items, demonstrated throughout their career:
Ability to understand the full scope of their job & set priorities to accomplish the most important items in his/her cue.
Clear examples of strong relationship skills with business users outside of their IT/HRIS group. The ability to ask the tough questions in order to understand what the business user (customer) is requiring and level of importance associated with the task.
The ability to set realistic expectations; there is nothing wrong with saying I need help. No one person can do it all!
Clear examples of how she/he gathers the full list of requirements for a task from business users without the availability of a Business Analyst.
Ideally is strong in the Microsoft SSRS and has an understanding of the Cognos (or similar) reporting tool, can test the items she/he creates.

All candidates will need to be able to demonstrate strong skills in each of these areas in order.

Major Responsibilities:
Execute ad-hoc data analyses to support various data needs from internal and external HR requests.
Develop and publish important HR reporting requirements using Cognos, SQL and Microsoft SSRS.
Write select statements against SQL database.
Design and develop reports, scorecards and dashboards.
Gather and document reporting requirements from end users, then develop reports, dashboards or scorecards as needed.
Analyze data to identify anomalies and/or trends that will aid in driving key HR initiatives linked to business goals.
Educate and advise internal clients on how to leverage available data, reports, and tools.

Requirements:
2+ years experience in analytical activity.
3 5 years of SQL experience (must be able to write reports and be proficient in SQL queries and Transact SQL)
Deep understanding of relational database including data modelling and table structure.
Strong database development skills using Microsoft Transact-SQL (tables, views, stored procedures).
Candidate must be proficient in reporting using SSRS and querying relational databases.
Candidate must be proficient in reporting using MS Access, advanced MS Excel, including Pivot Tables and VLookups.
Must have knowledge or exposure to SQL Server 2005, SQL Server 2008, MS Analysis Services.
Proficiency with Cognos 8 report writing is highly desired.
Experience with UltiPro data is highly desired.
Data mining experience is a plus.

Exceptional verbal and written communication skills are required.

The ideal candidate will possess: a strong dedication to customer service, organizational skills, and the ability to deliver high quality results working under pressure, ability to work independently as well as within a team setting.

It is important that the candidate possess the ability to interact with internal and external customers and operations teams and be a strong analytical thinker with the ability to frame and execute analytics around business questions.

Candidate must be detail oriented with the ability to manage multiple projects at the same time.

Application Requirements
  • Client will not accept subcontractors
Required Qualifications:
  • SSRS
  • SQL
Benefits/Perks
  • Medical
  • Dental
  • Vision
  • and Life Insurance for Full-time W2 Consultants. Supplemental Disability and Long-Term Care Insurance
  • Dependent Care Assistance. 401(k) with Roth feature. Free E-learning Courses
Start date
n.a
Duration
6 Month
From
MATRIX Resources, Inc.
Published at
22.03.2012
Project ID:
336433
Contract type
Freelance
To apply to this project you must log in.
Register