Job summary

Location:
Greater Lansing Area, United States, North America
Career Level:
Mid Career (2+ years of experience)
Education:
Diploma
Job type:
Full time
Positions:
1
Salary:
$75K+
Apply before:
10 Nov, 2017
Cancel

ETL Developer

  Bookmark this job About this job

Our client is a growing Insurance Company and is going through a complete business transformation and core system replacement effort that will encompass the conversion of existing legacy systems and introduction of new third party software to the environment.  The company is moving from a product based development and support focus l to a shared services model and has the need for an ETL Developer to join their to join their Data Services team.

The following are high level requirements for this role:

  • 4+ years of ETL Development Experience with SQL & ETL Tools (must have experience with SSIS)
  • 2+ years of .NET Development Experience (C# preferred)
  • Experience in a production and support capacity, troubleshooting and performing issue resolution -ability to reconfigure the database
  • Ability to work with a team but capable of running independently on tasks through completion.

Responsibilities:

  • Work with data analysts and project management team to qualify technical requirements and develop ETL packages.
  • Troubleshoot and resolve data integrity and performance issues.  Build and maintain scalable relational database schemas, indexes, views, and queries.  Tracks performance counters and metrics to diagnose and resolve issues.
  • Design and implement dimensional (star schema) models for warehousing purposes.  Create packages that provide reliable and timely updates.
  • Pull and transform data from multiple sources e.g. (XML, JSON, CSV, API’s, SQL) using a variety of tools such as SSIS and C#. 
  • Creates technical design documents and specifications on change requests and assignments within a project while maintaining documentation and abstracts in conformance to standards.
  • Deploy data to a variety of services such as SSRS, Business Objects, API’s, FTP. 
  • Design and implement logging frameworks for data validation and package completion. 
  • Owns problem management process and ensures resolution to completion, including identifying discrepancies between systems.
  • Periodically review and assess third party tools for reporting and ETL development.
  • Installs and configures SQL Server and SSIS instances.  Applies updates to the instances as necessary.
  • Develops and maintains reporting semantic layers in Business Objects.  Creates dashboards, reports, and data exports as necessary.

Required Experience

  • Bachelor's degree in computer science or related field.  Combinations of relevant education, certifications, and experience may be considered in lieu of a degree.
  • Experience with SSIS and Microsoft SQL Server platform.
  • Advanced T-SQL query skills e.g. (pivots, CTE’s, triggers, functions, stored procedures, transactions, etc.)
  • Solid understanding of API’s, particularly REST.

Preferred Experience

  • Knowledge of non-relational databases such as MongoDB and Cosmos DB and their limitations and benefits compared to SQL.
  • Experience with cloud based data services such as Azure or AWS.
  • 2+ years of .NET development experience, preferably with C#.
  • Experience with Big Data tools like Hadoop and its ecosystem.
  • Ability to analyze data and build machine learning models in a production environment. 
  • Experience with SSAS and Excel Data Model.  Ability to build and deploy tabular and multi-dimensional models.

Job keywords/tags:  ETL Developer , SQL , ETL , SSIS , .Net , Database , SQL Server , T-SQL T SQL , API , Rest