SSIS ETL Database Developer

MS SQL Server v 2014, SSIS, Visual Studio 2013, ASP.NET, C#, VB.NET
Full Time
$85K - $100K/year
Telecommuting not available Travel not required

Job Description

Cirdan Health Systems provides actuarial analysis, healthcare finance, strategic planning, and data management services to the healthcare and insurance industry. The company has been in business since 2001, with offices in downtown St. Paul, Minnesota.

 

Job Summary

The SSIS Developer will work on a small development team in a dynamic healthcare actuarial and data warehousing environment and will support our many and varied ETL operations with an emphasis on improved standardization, accuracy, efficiency, automation and documentation in our data warehouse operation.

 

As with any small, growing company, specific duties may vary according to specific client needs. The responsibilities of the SSIS Developer will include, but will not be limited to:

• Performance of recurring ETL tasks that utilize SSIS and SQL

• Development of new SQL Server Integration Services (SSIS) ETL packages, and migrating current ETL processes into SSIS infrastructure

• EDI X12 Encounter data submissions to state and federal government agencies

• Data analysis and validation

• Documentation of code, user instructions, data elements, and process flow

• Using source code management software

• Software testing

• T-SQL queries, views and stored procedures

• Performance tuning of processes

 

The ideal candidate will have:

• 4-yr degree in computer/information science or similar

• Excellent written and verbal communication skills

• Strong analytical abilities

• Strong attention to details

• 3-4 years of professional experience in the following: o Visual Studio 2013 or later

  • MS SQL Server 2014 or later Integration Services (SSIS)
  • Writing queries and designing tables, stored procedures and other database objects using T-SQL, index-tuning

 

 

Additional experience in the following applications is preferred:

  • SQL Server 2014 (or later) Reporting Services (SSRS)

 

Additional experience in the following applications is useful:

  • ASP.NET, C#, VB.NET and SSRS Expressions
  • Development/maintenance of both internal and client-facing ASP.NET web applications

 

Dice Id : 501431588
Position Id : 689326
Have a Job? Post it