Data Analytics & Data Warehouse developer

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.

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.

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

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

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”)

Experience scripting in Python;

Experience in Tableau Server Administration

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

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

Cloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; How AI Is Used

Supporting our recruiters in candidate data evaluation

Ensuring consistent review standards across all applications

Important: AI serves as a support tool only. Your unedited resume will be processed by our AI tools as part of this evaluation.

Your Data and Privacy
Cloud and Things Data Handling:

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: View email address on click.appcast.io 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. J-18808-Ljbffr Cloud and Things