• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

ETL Lead

In Texas / United States

Save this job

ETL Lead   

Click on the below icons to share this job to Linkedin, Twitter!
JOB TITLE:
ETL Lead
JOB TYPE:

JOB SKILLS:
JOB LOCATION:
Texas City Texas / United States

JOB DESCRIPTION :

Job responsibilities will span ETL development/data transformation and database modeling with heavy data analysis skills. The candidate will be responsible for taking the project through the entire SDLC, working with the business users to determine the business requirements and apply the business rules to the data. The candidate will also work with vendors and partners to establish API-based data exchange mechanisms to satisfy business requirements.

This candidate should be an expert in creating, modifying, and maintaining SSIS packages which will be used to move data from source systems to the data warehouse backend. Advanced skills in writing complex Structured Query Language (SQL) queries are required. Expertise with Microsoft development toolsets and industry-standard API technologies is required.

Experience working with a large variety of data, demographic, personal, numeric data and identify normal ranges, outlier data, typical and non-typical data results. Experience with open data standards and/or education data is desirable.

ETL/API developer that will make extensive use of data flow tasks that extracts large volumes of data from disparate data systems.

Candidate 
• Proficient in development of SQL Server Integration Services (SSIS) packages.
• Proficient using MS SQL 2014 or later and writing relational database queries and stored procedures using SQL
• Experience extracting data from a large variety of sources, transforming, and loading to a SQL data warehouse
• Experience with MVC, Microsoft development tools (ASP.NET, C#.NET, Entity Framework), RESTful APIs, and integrated authentication methods
• Experience converting data to and from relational stores and JSON or XML formats
• Evaluate and address data quality issues
• Developing error checking and resolution routines
• Experience in interacting with customers regarding application requirements.
• Strong business writing and interpersonal skills necessary for customer contact.

Requirements
• Develop, modify, and optimize SSIS packages - 5 years of experience 
• SQL 2008 – 5 years of experience 
• Experience building SSIS packages using built-in SSIS components - 5 years of experience 
• Experience writing complex T-SQL
• Experience analyzing, profiling, manipulating data from a large variety of sources
• Experience loading data into a SQL Data Warehouse
• Troubleshoot abstract data, profile, analyze and optimize data
• Develop error checking and resolution routines
• Data modeling experience
• Analyze and optimize table design
• Ability to work with end users to extract business requirements
• Ability to analyze data and apply business rules and requirements
• Agile Project experience is highly desired

Desired Skills: 
• MS SQL Server 2017
• ASP.NET (C# & VB.NET)
• Entity Framework
• API's
• REST
• JSON
• JavaScript
• Embedding work in SSIS packages
• Authentication and Authorization
• Data acquisition, load, profile, clean, QA, transform
• Relational data
• Document store unstructured data
• Customer interaction for requirements and resolution
• Writing and interpersonal skills

 

Additional Details :

Owner : Jordan Lucas

Owner Email : jklucas@apexsystems.com

Projected Start Date : 06-29-2020

Projected End Date : 05-07-2021

Client Company : State of Iowa

Vendor Pay Rate : 65

Notes :

Selling points for candidate :

Project Verification Info :

Candidate must be your W2 Employee : Yes

Exclusive to Apex : No

Face to face interview required : No

Candidate must be local : No

Candidate must be authorized to work without sponsorship : No

Interview times set : No

Background Check : Yes

Drug Screen : Yes

Position Details

May 08, 2021
S159241323274112
Texas / United States
Texas City
A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

ETL Lead    Apply

Click on the below icons to share this job to Linkedin, Twitter!

<p>Job responsibilities will span ETL development/data transformation and database modeling with heavy data analysis skills. The candidate will be responsible for taking the project through the entire SDLC, working with the business users to determine the business requirements and apply the business rules to the data. The candidate will also work with vendors and partners to establish API-based data exchange mechanisms to satisfy business requirements.</p> <p>This candidate should be an expert in creating, modifying, and maintaining SSIS packages which will be used to move data from source systems to the data warehouse backend. Advanced skills in writing complex Structured Query Language (SQL) queries are required. Expertise with Microsoft development toolsets and industry-standard API technologies is required.</p> <p>Experience working with a large variety of data, demographic, personal, numeric data and identify normal ranges, outlier data, typical and non-typical data results. Experience with open data standards and/or education data is desirable.</p> <p>ETL/API developer that will make extensive use of data flow tasks that extracts large volumes of data from disparate data systems.</p> <p>Candidate <br /> • Proficient in development of SQL Server Integration Services (SSIS) packages.<br /> • Proficient using MS SQL 2014 or later and writing relational database queries and stored procedures using SQL<br /> • Experience extracting data from a large variety of sources, transforming, and loading to a SQL data warehouse<br /> • Experience with MVC, Microsoft development tools (ASP.NET, C#.NET, Entity Framework), RESTful APIs, and integrated authentication methods<br /> • Experience converting data to and from relational stores and JSON or XML formats<br /> • Evaluate and address data quality issues<br /> • Developing error checking and resolution routines<br /> • Experience in interacting with customers regarding application requirements.<br /> • Strong business writing and interpersonal skills necessary for customer contact.</p> <p>Requirements<br /> • Develop, modify, and optimize SSIS packages - 5 years of experience <br /> • SQL 2008 – 5 years of experience <br /> • Experience building SSIS packages using built-in SSIS components - 5 years of experience <br /> • Experience writing complex T-SQL<br /> • Experience analyzing, profiling, manipulating data from a large variety of sources<br /> • Experience loading data into a SQL Data Warehouse<br /> • Troubleshoot abstract data, profile, analyze and optimize data<br /> • Develop error checking and resolution routines<br /> • Data modeling experience<br /> • Analyze and optimize table design<br /> • Ability to work with end users to extract business requirements<br /> • Ability to analyze data and apply business rules and requirements<br /> • Agile Project experience is highly desired</p> <p>Desired Skills: <br /> • MS SQL Server 2017<br /> • ASP.NET (C# & VB.NET)<br /> • Entity Framework<br /> • API's<br /> • REST<br /> • JSON<br /> • JavaScript<br /> • Embedding work in SSIS packages<br /> • Authentication and Authorization<br /> • Data acquisition, load, profile, clean, QA, transform<br /> • Relational data<br /> • Document store unstructured data<br /> • Customer interaction for requirements and resolution<br /> • Writing and interpersonal skills</p> <p> </p> <p><b>Additional Details : </b></p> <p>Owner : Jordan Lucas</p> <p>Owner Email : jklucas@apexsystems.com</p> <p>Projected Start Date : 06-29-2020</p> <p>Projected End Date : 05-07-2021</p> <p>Client Company : State of Iowa</p> <p>Vendor Pay Rate : 65</p> <p>Notes :</p> <p>Selling points for candidate :</p> <p>Project Verification Info :</p> <p>Candidate must be your W2 Employee : Yes</p> <p>Exclusive to Apex : No</p> <p>Face to face interview required : No</p> <p>Candidate must be local : No</p> <p>Candidate must be authorized to work without sponsorship : No</p> <p>Interview times set : No</p> <p>Background Check : Yes</p> <p>Drug Screen : Yes</p>