ETL DEVELOPER Job at Neotecra, Albany, NY

TVRoRUZzT2haT1dJMmdWckExQ1BHS1QvVGc9PQ==
  • Neotecra
  • Albany, NY

Job Description

The Consultant shall work with client staff from the Data Analytics & First New York units within client Division of the Chief Information Officer (the "Division"). The Consultant shall assist the Division with the build-out of the current CLIENT environment for both infrastructure and tools as they relate to data analytics and the necessary supporting technologies, such as data warehousing, business intelligence, statistical analysis, and data exchanges with external agencies/entities. Tasks include: Reviewing and analyzing existing data analytics ETL processes as well as external sources in order to design and architect a system communicating this information to Division staff and other CLIENT staff as necessary; Assisting with the implementation of data analytics architecture design to accept structured and unstructured datasets as they are acquired through the Division;

  • Assisting with the implementation and migration of ETL environments, including fact and dimensional models as defined through user story business requirements;
  • Assisting in Tableau/Oracle Business Intelligence Enterprise Edition ("OBIEE") dashboard design as defined by user story business requirements;
  • Assisting with ETL processes of newly identified/acquired data into CLIENT's secure data analytics environment; and
  • Providing other data analytics development services as requested.

MINIMUM QUALIFICATIONS

The Consultant must possess the following minimum qualifications. The proposed candidate must have:

1. either a) a bachelor of science degree, or equivalent four-year degree, in computer science or related information technology field or b) a masters or doctorate in computer science or related information technology field;
2. a minimum of four years of experience developing and maintaining a data interchange system interfacing with a wide array of varying data sets including flat file, direct database connection, and eXtensible Markup Language transactions;
3. a minimum of four years of experience working with ETL tools (e.g., Qlik and Informatica);
4. a minimum of four years of experience performing data modeling;
5. a minimum of four years of experience developing a data analytics ETL environment to support data analytics; and
6. a minimum of four years of experience coding in Structured Query Language ("SQL").

PREFERRED QUALIFICATIONS

CLIENT will give preference to candidates with the following qualifications:

1. experience scripting in Python;
2. experience in Tableau Server Administration;
3. experience working with customers in data validation, troubleshooting, or collecting business requirements;
4. two or more satisfactorily completed statistics courses from an accredited college or one or more year of professional experience using statistics;

5. experience performing database development using SQL or Procedural Language/Structured Query Language ("PL/SQL");
6. experience developing a data analytics ETL environment to support Tableau visualizations; and
7. experience using ETL techniques to support a data analytics program for a government entity.

Job Tags

Similar Jobs

OmegaHires

SAP Basis HANA Consultant (RISE with SAP) Job at OmegaHires

 ...Job Title: SAP Basis HANA Consultant (RISE with SAP) Location: Remote (USA) Duration: Initial 6 Months (High possibility of extension up to 18 months) Job Summary We are seeking an experienced SAP Basis HANA Consultant with strong expertise in RISE with... 

Bethany Medical

X-Ray Technician (Part-Time) Job at Bethany Medical

 ...Specialty Group in Central North Carolina is Seeking a Weekend X-Ray Tech to Join Our Team! VOTED BUSINESS OF THE YEAR 2018 VOTED...  ..., Mt. Airy, and North Wilkesboro, is seeking an X-Ray Technician to work closely with our Providers and patients to ensure quality... 

UPS

PT Hub Outbound Supervisor Midnight Job at UPS

 ...help you become better every day. We know what it takes to lead UPS into tomorrowpeople with a unique combination of skill passion. If...  ...Ability to lift 70 lbs./32 kgs. Availability to work flexible shift hours up to 5 days per week Strong oral and written communication... 

Bieber & Lubinski, PLLC

Probate Paralegal / Legal Assistant Job at Bieber & Lubinski, PLLC

 ...Probate Paralegal / Legal Assistant Full-time | In office | Monday-Friday, 9:00 a.m....  ...and keep files moving efficiently. Our work is primarily probate and estate administration...  ..., while there might be hybrid work-from-home opportunities in the distant future, you... 

Hacker Architects

Future Opportunities Job at Hacker Architects

 ...com We are an equal opportunity employer and champion social equity and mentorship. We value diversity, are active in...  ...such as diversity, equity, and inclusion in the workplace; corporate social responsibility; and combating climate change. We look for employees who...