USA Jobs, Careers and Recuitements
Job Target Job Search

Contact Information

Contact Name: DAVE

Job Details: SQL/ETL Developer--$70\hr Date: Jan 16 2020

Job Reference: 4036
Job Category: IT Jobs [ View All IT Jobs Jobs ]
Company Type Recruiter
Employment type: Contract
Degree: High School
Experience: 3 years
Location: Albany, New York, 12202
Job Skills: SQL/ETL Developer--$70\hr
Share Job with Others

Job Tools

Job Description

Respond with your updated resume to be considered.

Design, develop, and implement ETL processes for loading an enterprise data warehouse and data marts.

Create and optimize queries for front-end and back-end applications.

Design and develop views and stored procedures in support of system and information requirements.

Contribute to the design of dimensional modeling schemas for a data warehouse.

Identify and recommend solutions for database performance issues and optimization.

Work with the Database Administrator to create and execute DDL scripts.

Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.

Recommend and establish optimum data access techniques; support database functions by designing and coding utilities and scripts; contribute to the creation and maintenance of an enterprise data dictionary.

Work with key stakeholders on a disaster recovery plan.

Maintain a high level of service by establishing and enforcing organization standards and following established change management processes.

Continue to improve professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.

Foster and contribute to a culture of excellence grounded in listening, learning, problem solving, and teamwork.

Assist in the improvement and integration of automation and tools designed to support work and decision making.

Effectively communicate, collaborate and problem-solve with relevant stakeholders.

Perform other responsibilities as assigned.

Skills preferred by the client:

Four years of relevant experience as described above.

A strong technical knowledge of Microsoft SQL Server (version 2012 or newer preferred).

Significant experience with SQL Server Integration Services.

Strong scripting abilities utilizing various programming/scripting languages (T-SQL, VB Script, Power shell, Bat files, C#, etc.).

Experience developing ETL in a data warehouse environment.

Experience with Tableau (preferred).

An understanding of Microsoft Windows Server 2008+, Active Directory, Windows networking (DHCP, DNS).

Strong ability to work in a team dedicated to creating systems that are user-friendly, enable easy self-service, and are scalable and flexible to support emerging strategic needs of NYSERDA.

Demonstrated commitment to ongoing learning / ability to share and facilitate knowledge within a highly dynamic team.

Demonstrated problem-solving ability; an entrepreneurial edge, resourcefulness, adaptability, and an instinct for surfacing value and pragmatic solutions.

As this contract may become a permanent position:

Bachelor Degree in Information Systems or related field and 4 years relevant work experience as a SQL Server Developer; or an unrelated degree and 6 years relevant work experience as a SQL Server Developer; certificates from recognized programs that indicate mastery of tools and techniques relevant to the assignment may substitute for up to six months of experience.

Tested ETL codeOptimized queries Tested DDL scripts

Applicants should apply here and include their updated resume for consideration.

Copyright © 2020 Jobxoom All rights reserved. Use of this site is subject to certain Terms and Conditions.