ETL Developer / Data Warehouse Architect

Job description

Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of transforming the public sector’s IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers the opportunity to work on rewarding projects, consider a career with Cloud and Things.

This is an exempt position. Salary commensurate with experience Overview

Location: Albany, NY

Salary: $115,000 - $138,000

We are seeking an ETL Developer/Data Warehouse Architect who will support our NYS client with an ongoing data analytics initiative. This role will be responsible for assisting with the build-out of the current 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.

Duties

Review and analyze existing data analytics ETL processes as well as external sources in order to design and architect a system communicating this information to staff as necessary

Assist with the implementation of data analytics architecture design to accept structured and unstructured datasets as they are acquired through the Division

Assist with the implementation and migration of ETL environments, including fact and dimensional models as defined through user story business requirements

Assist in Tableau/Oracle Business Intelligence Enterprise Edition (“OBIEE”) dashboard design as defined by user story business requirements

Assist with ETL processes of newly identified/acquired data into secure data analytics environment

Provide other data analytics development services as requested

Mandatory Qualifications

Bachelor of science degree or higher in computer science or related information technology field

4+ 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

4+ years of experience working with ETL tools (e.g., Qlik and Informatica)

4+ years of experience performing data modeling

4+ years of experience developing a data analytics ETL environment to support data analytics

4+ years of experience coding in Structured Query Language (“SQL”)

Desirable Qualifications

Experience scripting in Python;

Experience in Tableau Server Administration

Experience working with customers in data validation, troubleshooting, or collecting business requirements

Two or more satisfactorily completed statistics courses from an accredited college or 1+ year of professional experience using statistics

Experience performing database development using SQL or Procedural Language/Structured Query Language (“PL/SQL”)

Experience developing a data analytics ETL environment to support Tableau visualizations

Experience using ETL techniques to support a data analytics program for a government entity

Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws.

AI-Assisted Resume Evaluation Notice

Cloud and Things – Talent Management

Notice to Candidates: Cloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; consistency, efficiency, and thoroughness. All hiring decisions are ultimately made by our human recruiting professionals.

How AI Is Used

Analyzing resumes against job requirements

Supporting our recruiters in candidate data evaluation

Ensuring consistent review standards across all applications

Important: AI serves as a support tool only. As noted above, all candidate selection and hiring decisions are made by experienced human recruiters. Your unedited resume will be processed by our AI tools as part of this evaluation.

Your Data and Privacy

Cloud and Things Data Handling:

Your information is processed securely and used exclusively for recruitment purposes

Cloud and Things may store your resume in our Applicant Tracking System (ATS) indefinitely for future job matching opportunities You may opt out of long-term ATS storage by emailing your name and your request to opt out of storing your resume in the ATS to:

All personal information is handled confidentially in accordance with our privacy policy

AI Tool Data Processing

AI processing data is retained for a maximum of 90 days, after which it is deleted

All data sent to AI tools is encrypted in transit and at rest

AI tools comply with applicable privacy laws including GDPR and CCPA

Personal data is anonymized or minimized wherever possible during AI processing

Your Participation: By submitting your application, you acknowledge this notice and consent to AI-assisted evaluation as part of our recruitment process. You may opt out only by choosing not to submit your resume for consideration.

#J-18808-Ljbffr

Who can apply

Review the original listing for work authorization, qualifications and employer requirements.