ETL Developer​/Data Warehouse Architect

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.

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.

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

• 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.

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.

• 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.

Clo…