ETL Developer / Data Warehouse Architect

Cloud and Things; City of Albany (NY); On-site; USD 115,000 - 138,000; Full time

Job summary

A leading technology consultancy is seeking an ETL Developer/Data Warehouse Architect to join their Albany team. This role involves supporting NYS clients in data analytics initiatives, implementing ETL processes, and designing data analytics architectures. Candidates should have a bachelor's degree in computer science and 4+ years of relevant experience with ETL tools and SQL. This position offers a competitive salary between $115,000 - $138,000 depending on experience.

Qualifications

• 4+ years of experience developing and maintaining a data interchange system.
• 4+ years of experience working with ETL tools like Qlik and Informatica.
• 4+ years of experience coding in Structured Query Language (SQL).

Responsibilities

• Review and analyze existing data analytics ETL processes.
• Assist with the implementation of data analytics architecture design.
• Provide data analytics development services as requested.

Skills

ETL tools (e.g., Qlik, Informatica)

SQL

Data modeling

Scripting in Python

Education

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

Tools

Tableau

Oracle Business Intelligence Enterprise Edition (OBIEE)

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: [e-mail]
• 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.