Data Specialist

Cloud & Things Inc; City of Albany (NY); On-site; USD 110,000 - 131,000; Full time

Job summary

Cloud and Things seeks a Data Specialist to support a NYS client in Albany. This Level III role leads data requirements, source-to-target mappings, ETL, and data quality for a complex migration and warehouse work. Collaboration with SMEs, analysts, and developers to document requirements and validate conversions is essential.

The position emphasizes UNIX scripting, SQL development against Oracle/SQL Server/PostgreSQL, and data profiling/cleansing across the full SDLC, including QA support.

Qualifications

• Seven plus years of experience on complex projects including data conversion and data warehouse initiatives.
• Proven ability to lead as a Specialist for multiple years and to drive SDLC activities.

Responsibilities

• Gather, define, and document data requirements with stakeholders.
• Develop and maintain source-to-target data mappings and data model requirements.
• Document To-Be data requirements and validate with business stakeholders.
• Perform ETL activities and design strategies for data loads into the warehouse/DataMart.
• Develop and test UNIX shell scripts and tune query performance during loads.
• Analyze and validate source system metadata and document profiling rules.
• Coordinate data profiling and cleansing with business users and define rules.
• Interpret profiling results and present findings and recommendations clearly.
• Document data synchronization and bridging requirements.
• Identify and resolve data quality issues and support QA testing.
• Write SQL queries against Oracle, SQL Server, and PostgreSQL for validation.
• Develop and execute ETL processes using Informatica or scripting approaches.

Skills

Leadership

SDLC knowledge

Data analysis

Tools

UNIX shell scripting

SQL (Oracle/SQL Server/PostgreSQL)

ETL tools (Informatica, T-SQL, PL/SQL, PL/pgSQL)

Job description

Back Data Specialist
Other Area(s) Albany , New York W-2 hourly Sep 23, 2026

*This is an exempt position. Salarycommensuratewith experience*

Job Title: Data Specialist
Location: 40 North Pearl, Albany, NY (Hybrid)
Duration: 30 Months (with potential for extension)
W2 Hourly Rate: $80-95/hour
Application Deadline: 10/5

Overview

We are seeking a Data Specialist who will support our NYS client.

This Level III role will lead data requirements, source-to-target mapping, ETL, and data quality activities for a complex system migration and associated data warehouse/DataMart work.

The specialist will partner with subject matter experts, business analysts, developers, and stakeholders to document and validate data requirements, develop and test conversion solutions, and support data conversion quality assurance across the full SDLC.

Duties

• Work with Subject Matter Experts, Business Analysts, and Development Teams to gather, define, and document project data requirements and attributes.
• Develop and maintain As-Is to To-Be source-to-target data mappings, including analysis and interpretation of complex source and target system data.
• Document To-Be target model data requirements based on business requirements and validate them with stakeholders.
• Perform ETL activities, including developing strategies for extracting, transforming, and loading data from the As-Is system into the To-Be system and data warehouse/DataMart.
• Develop and test UNIX shell scripts and support query performance tuning during data loads and transformations.
• Perform source system metadata analysis, documentation, and validation.
• Define and document data profiling, data cleansing, and data transformation rules; coordinate profiling and cleansing activities with business users.
• Interpret data profiling results and present findings and recommendations in a clear, concise manner.
• Gather, analyze, and document data synchronization and bridging requirements.
• Identify and resolve data quality and consistency issues and support data conversion quality assurance testing.
• Develop and test SQL queries against databases such as Oracle and SQL Server to analyze and validate data.
• Perform other duties as assigned.

Mandatory Qualifications

• More than seven (7) years of experience working on complex projects, including two (2) or more years in a leadership role as a Specialist.
• More than seven (7) years of experience working on data conversion/data warehouse projects, including source system metadata analysis, documentation, and validation; source-to-target data mapping; data profiling and data cleansing rules; To-Be system data requirements gathering, analysis, documentation, and validation; data synchronization and bridging requirements; and data conversion quality assurance testing.
• More than seven (7) years of experience with UNIX shell scripting and performance tuning of queries during data loads and transformations.
• More than seven (7) years of experience across the full Software Development Life Cycle (SDLC) for data conversion/data warehouse projects, including requirements gathering, design, development, testing, and deployment phases as a Data Analyst and ETL developer in data warehousing or data integration projects.
• More than seven (7) years of experience writing SQL statements and queries against RDBMS platforms such as Oracle, SQL Server, and PostgreSQL as part of development and validation.
• More than seven (7) years of experience developing and executing ETL processes using an industry-standard ETL tool or scripting-based approach, such as Informatica, T-SQL, PL/SQL, or PL/pgSQL.

Desirable Qualifications

• Three (3) or more years of experience in government or public sector data systems.
• Experience with data conversion/migration projects, especially legacy-to-modern system transitions.
• Strong understanding of data warehouse/DataMart concepts, including staging and dimensional modeling.
• Five (5) or more years of experience with Data Quality processes, approaches, measurement techniques, and business cases for data profiling, cleansing, standardization, and match and merge functionality.
• Working knowledge of Python for data processing or automation scripts.
• Experience supporting QA/UAT for data conversion testing.
• Strong written and verbal communication skills, including the ability to present data findings to technical and non-technical audiences.

What We Offer

• Opportunities to lead impactful transformations in the public sector infrastructure.
• Engagement with high-profile government initiatives, supporting meaningful change.
• Professional development through exposure to innovative Agile practices and leadership collaboration.
• A collaborative environment that values ownership, initiative, and continuous learning.

Ready to make a difference?

We’re eager to connect with qualified candidates committed to delivering results and fostering excellence within client projects.

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.

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.