Data Engineer w/MS SQL Server Automation (Engineering/Software Jobs)

USA Jobs Online > Engineering/Software Jobs > Data Engineer w/MS SQL Server Automation

Job ID 723547  In Category: Engineering/Software

Data Engineer w/MS SQL Server Automation

Location: All Cities, New Jersey
Job Type: Full Time
Salary: $Marketvalu per Hour
Experience Desired: 3 - 5 Years
Last Update: Nov 06, 2020 05:40:55 AM
Full Job Description:

Job Title: Data Engineer w/MS SQL Server Automation experience

Remote role: SF Preferred area; however, open to candidate in other areas as long as he/she can work PST time zone.

8+yrs of exp required

Responsibilities:

o Maintain/ develop a scalable database/ data warehouse through connecting. disparate data tables housed across numerous organizational systems and different business lines.

o Maintain/ develop the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL (primarily MS SQL) and AWS technologies.

o Optimize and maintain scripts on present data warehouses and present ETL.

o Create and update data models for decision support of digital help programs and initiatives.

• Drive SQL server conversion onto AWS platform.

• Code review all current SSIS jobs for effectiveness.

• Drive the re-architecting of ADSK data sources feeding our automation workflows (re-align source file acquisitions within AWS).

• Experienced data solution architecting.

Minimum Qualifications:

· Bachelor's degree computer science, information systems, or a related discipline.

· 5+ years of experience.

· Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

· Experience with transforming, developing data structures, metadata, dependency and data workflows to support an Analytics function.

· Expertise in gathering data through multiple sources through API calls and scripting languages.

· Preference given to those with advanced data modeling experience.

· Self-starter and a driver, ability to communicate/own a project to completion while working with various teams (not directly managing the teams).

· Candidate will be coordinating work with other teams.

· Hands-on/Player-Coach style candidate.

· Excellent written and verbal communication skills.

· 70-Technical/30-Functional.

Nice to Have but no required:

· Experience with object-oriented/object function scripting languages: Python, Java, C++ etc.

Company Type: Direct Employer
Contact Name : Shajahan
Contact Phone: 8622005150
Contact Email  :
Number of Views: 244
USA Jobs Online > Engineering/Software Jobs > Data Engineer w/MS SQL Server Automation