SSIS SSRS Developer

  • location: Raleigh, NC
  • type: Permanent
easy apply

job description

SSIS SSRS Developer

job summary:
This is a direct hire full time role with a company who has been here since the 1960's.

Salary and Bonus along with:

Benefits:

  • Medical
  • Prescription Drug
  • Dental
  • Vision
  • Health Care Reimbursement Account
  • Dependent Care Reimbursement Account
  • Wellness Programs
  • Employee Assistance Plan
  • Paid Holidays and Vacation
  • 401(k) - with Company matching
  • Pension
  • Salary Continuation -- Short-term Disability
  • Long-Term Disability Options
  • Employee Life Insurance
  • Spouse & Dependent Life Insurance
  • Business Travel Accident Insurance
  • Direct Deposit Payroll
  • Educational/Tuition Assistance Plan
  • College Scholarship Program - for dependent children
  • Matching Gift Program
  • New Auto Purchase Discount Plan
We are seeking a ETL SSIS/SSRS developer at our corporate headquarters in Raleigh, NC. Reporting to the Manager, you will design, develop and deploy ETL software, and reports needed to support a variety of business needs. This position requires extensive work with T-SQL and PL/SQL in a SQL Server and Oracle database environments and mentoring of junior engineers.

 
location: Raleigh, North Carolina
job type: Permanent
work hours: 9am to 5pm
education: Bachelors
 
responsibilities:
  • Leverage Microsoft SQL Server Integration Services to design and develop solutions to integrate with internal applications and also with customers' and vendors' applications
  • Create reports per requirements using SQL Server Reporting Services or Crystal Reports
  • Create technical specification documents
  • Create documentation for new and existing solutions
  • Participate in QA and user acceptance testing
  • Troubleshoot ETL and other processes and supporting software/infrastructure, including services and drivers
 
qualifications:
  • Bachelor's degree in Computer Science / MIS or equivalent experience required
  • Master's degree in a related discipline prefered
  • 5+ years' experience writing stored procedures/functions, creating tables, indexes and views in Transact-SQL.
  • 5+ years' experience using Microsoft Technologies (SQL Server 2008/2008 R2/2012/2016, Visual Studio 2008/2010/2012/2015)
  • 5+ years' experience writing stored procedures/functions, creating tables, indexes and views in Oracle PL/SQL
  • 5+ years' experience implementing SSIS and SSRS
  • 1+ years' experience in writing complex reports in Crystal Reports
  • Strong experience building ETL processes using SQL Server Integration Services (SSIS)
  • Strong experience in SQL Server Reporting Services (SSRS)
  • Strong analytical skills and the ability to learn new technologies
  • Experience with scripting languages such as Powershell and VBscript
  • Experience with other Microsoft languages and technologies, including VB.Net, C#.Net preferred
  • Experience with version control software such as TFS and Git preferred
  • Experience with leading Middleware solutions preferred
  • Experience deploying, integrating, and supporting ECM solutions such as Docuware and Onbase preferred
  • Experience with application and database security preferred
  • Experience with Issue Tracking systems like JIRA, ServiceNow, etc. preferred
  • Experience working in a large corporate environment preferably in a manufacturing sector
  • Must have great problem solving and troubleshooting skills, must be attentive to detail, and understand implications for the business
  • Ability to work independently, or in groups, while maintaining a courteous attitude when dealing with customers and users
  • Ability, and willingness, to complete several concurrent tasks in a fast-paced, detail-oriented, multi-tasking environment
  • Ability to set objectives, manage project timelines and see projects to completion
  • Ability to explain technical terms in everyday language
  • Continually updates skills and knowledge
  • Experience with Change Control Management, ITIL methodology and best practices
 
skills:
  • Bachelor's degree in Computer Science / MIS or equivalent experience required
  • 5+ years' experience writing stored procedures/functions, creating tables, indexes and views in Transact-SQL.
  • 5+ years' experience using Microsoft Technologies (SQL Server 2008/2008 R2/2012/2016, Visual Studio 2008/2010/2012/2015)
  • 5+ years' experience writing stored procedures/functions, creating tables, indexes and views in Oracle PL/SQL
  • 5+ years' experience implementing SSIS and SSRS
  • 1+ years' experience in writing complex reports in Crystal Reports

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

easy apply

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs