SSRS Report Developer

Location: Minneapolis, Minnesota
Date Posted: 07-24-2017
NorthShore Resources has a contract opportunity for a SSRS Report Developer in Minneapolis, MN!

Project background:Our Client has a need for up 24 weeks for an experienced SSRS report developer with additional skills in SSIS ETL. Candidate must have significant experience with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).

Scope of services/description of work to be performed
  • Develop and enhance SSRS reports, perform SSIS ETL alterations, respond to break/fix requests.
  • Identify data sources, ETL scripts and packages necessary to troubleshoot data issues, evaluate data credibility, and resolve report discrepancies.
  • Develop SSIS code to automate business processes between multiple systems, applications, and databases. Develop stored procedures, tables, views, functions, and triggers.
  • Work with functional business users to determine reporting requirements and develop reports to specification using specified requirements
​Skills/experience required:
  • Three or more years of experience developing business reporting solutions with SSRS.
  • Two or more years of experience:
    • Using SQL, developing stored procedures, views, triggers, tables, and other database objects.
    • Writing complex T-SQL queries including dynamic SQL.
  • Developing ETL processing using SSIS, utilizing SQL scripts and transformations objects, deploying and documenting SSIS packages, creating/scheduling SQL agent jobs.
  • Experience creating and optimizing Oracle (PS/SQL) stored procedures as well as Oracle PS/SQL to PL/SQL conversions.
  • Fundamental understanding of database design principles.
  • Familiarity with modeling and cube development with SQL Server Analysis Services (SSAS) preferred but not required.
  • Excellent interpersonal, verbal and written communication skills. Ability to alter communication styles to accommodate diverse personalities with varied levels of technical understanding.   
  • Work independently (full SDLC) with minimal supervision in a team environment.
  • Accurately estimate level of effort and time intervals for project tasks.
  • Investigate, identify, troubleshoot and resolve complex application, system, data, and interface related issues.
Project deliverables:
  • ­Develop and maintain varied and highly specialized reporting solutions using SSRS.
  • Develop SSIS code to automate business processes between multiple systems, applications, and databases. Develop stored procedures, tables, views, functions, and triggers.
  • Create and maintain support and project lifecycle documentation
  • Documentation of requests, requirements, issues/incidents, customer communications, steps to resolution and solutions.
  • Move development and change requests through various processes processes, environments and stages of approval.
  • Root-cause analysis of customer-facing technology problems.
this job portal is powered by CATS