Data Conversion

Cloud and Things
Albany, United States of America
3 days ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 198K

Job location

Albany, United States of America

Tech stack

Artificial Intelligence
Data analysis
Cloud Computing
Data Cleansing
Data Conversion
ETL
Data Mapping
Data Profiling
Data Synchronization
Relational Databases
Database Development
Database Queries
Document-Oriented Databases
Shell
Microsoft SQL Server
Oracle Applications
Data Processing
Data Management

Job description

We are seeking a Data Conversion Specialist who will support our NYS client's Integrated Eligibility System modernization initiative. This role will analyze, transform, map, and validate data across legacy and target systems while supporting ETL, data profiling, cleansing, and conversion quality assurance activities. The specialist will collaborate with subject matter experts, business analysts, and development teams to ensure accurate, complete, and reliable data throughout the migration lifecycle.

Duties:

  • Collaborate with subject matter experts, business analysts, and development teams to understand project data requirements and attributes.
  • Perform As-Is system and data analysis and prepare supporting data documentation.
  • Develop strategies for extracting, transforming, and loading data from As-Is systems into To-Be systems.
  • Create source-to-target data mappings by analyzing complex source and target system data and resolving data issues.
  • Develop and test database query solutions using Oracle and SQL Server.
  • Develop and test UNIX shell scripts supporting data conversion activities.
  • Tune and optimize queries, troubleshoot migration issues, and identify errors during data loads and transformations.
  • Document To-Be target model data requirements based on approved business requirements.
  • Define and document data profiling, cleansing, transformation, and quality rules.
  • Coordinate and facilitate As-Is data profiling and cleansing activities with business users.
  • Interpret profiling results and prepare clear reports, findings, and recommendations.
  • Identify optimal approaches for resolving data quality and consistency issues., 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 Our AI tools assist by:

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

Requirements

  • 7+ years' of experience working on complex projects, including 2+ years' of experience in a leadership role as a Specialist.
  • 7+ years' of experience supporting data conversion projects, including source system metadata analysis, source-to-target data mapping, data profiling and cleansing, To-Be data requirements, data synchronization or bridging, and data conversion quality assurance testing.
  • 2+ years' of experience working in an Integrated Eligibility System program within the Fair Hearings and/or Data Management domain in a Health and Human Services setting.
  • 5+ years' of experience with data quality, data profiling, data cleansing, standardization, and SQL development using RDBMS tools such as Oracle and data quality tools such as Informatica Data Quality.
  • 3+ years' of experience analyzing data and business processes to identify data quality issues and support data cleansing, transformation, and migration activities.

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.

Benefits & conditions

This is an exempt position. Salary commensurate with experience

About the company

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

Apply for this position