NYS IES 20260720-495

Specialist Level 3 (Data Specialist) at Voyatek

NYS IES 20260720-495

Specialist Level 3 (Data Specialist) at Voyatek in Albany, New York Posted in 12 days ago. $145.00 - $155.00 per hour Opportunity Details Full Time

NYS IES 20260720-495

Specialist Level 3 (Data Specialist) Albany, NY (Hybrid) Outcomes. Delivered. Voyatek delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide. For example, our technology: Facilitates access to nutritious food for children of mothers participating in the WIC program Supports first responders in reducing opioid overdoses within their communities Empowers colleges and universities to identify and thwart financial aid fraud Equips teachers with valuable insights to identify students requiring additional support Enhances efficiency for state tax agencies, leading to 99% faster return processing and quicker refunds for taxpayers With a focus on Tax & Revenue, Health & Human Services, and Justice & Public Safety, Voyatek combines the scale to support large complex projects with the agility and accessibility of a boutique solutions provider. Together, Voyatek and its customers work to improve population wellbeing, create safer communities, and foster a thriving economy. We're more than a technology company -- we're an outcomes company. We encourage our employees to think differently, ask tough questions, and relentlessly pursue what's best for our customers and the residents they serve. We believe that the value of technology is defined by its human impact. If you agree, you've come to the right place. Voyatek is seeking applicants to occupy the position of Level 3 Specialist within our teamNYS Integrated Eligibility Systems located in Albany, NY (hybrid). This position is a 30 month contract. The mission of the Integrated Eligibility System (IES) is to enhance the well-being of New Yorkers by transforming health and human service delivery through coordinated business practices, modernized technology, and strategic partnerships. IES will provide eligibility, enrollment, case management, and payment functionality for Health and Human Service programs currently served by the Welfare Management System, Benefits Issuance Control System and other State systems. IES will build on the successful opening of the New York State of Health (NYSoH) by leveraging assets created for the health benefit exchange to modernize the eligibility system for health and human service programs.

Key Responsibilities:

We are looking for an experienced Data Specialist to own the data mapping, and data requirements work for our system migration. The primary focus of this role is to deliver complete, well-documented, and validated source-to-target data mapping requirements along with development and testing effort of the solution. Key Responsibilities Work with Subject Matter Experts, Business Analysts, and Development Teams to gather, define, and document data requirements and attributes for the project. Develop and maintain As-Is to To-Be source-to-target data mapping, including analysis and interpretation of complex data on both source and target systems. Document To-Be target model data requirements based on business requirements and validate them with stakeholders. Perform Extract Transform & Load (ETL) and related activities including developing strategies for extracting, transforming, and loading data from the As-Is system into To-Be system and data warehouse/DataMart. Developing and testing UNIX Shell Scripting. Perform source system metadata analysis, documentation, and validation. Define and document data profiling, data cleansing, and data transformation rules. Coordinate and facilitate data profiling and data 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. Other duties as assigned. Consultants may be eligible to telecommute for more than 50% of their work hours, up to and including 100% remote work. Telecommuting arrangements require direct manager approval and are subject to change based on program needs. Consultants approved for 100% remote work must attend monthly in-person meetings at the Albany office and be available for major milestone meetings as needed.

Qualifications:

1. Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Specialist 2. More than seven (7) years 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; experience with UNIX shell scripting with performance tuning of queries during data loads and transformations. 3. More than seven(7) years of experience working 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; writing SQL statements and queries against RDBMS platforms such as Oracle, SQL Server, and PostgreSQL as part of development and validation; developing and executing ETL processes using any industry-standard ETL tool or scripting-based approach (e.g., Informatica, T-SQL, PL/SQL, PL/pgSQL). .

Preferred Qualifications:

1. Three or more years of experience in government or public sector data systems. 2. Experience with data conversion/migration projects, especially legacy-to-modern system transitions . 3. Strong understanding of data warehouse/DataMart concepts (staging, dimensional modeling, etc.) 4. Five 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. 5. Working knowledge of Python for data processing or automation scripts, a plus. 6. Experience supporting QA/UAT for data conversion testing. 7. Strong written and verbal communication skills; ability to present data findings to technical and non-technical audiences. The wage range for this role reflects the wide array of factors considered in compensation decisions. These factors include, but are not limited to, skill sets, experience, training, licensure certifications, and geographic location. Compensation decisions are based on the unique facts and circumstances of each case. A reasonable estimate of the hourly range is $145.00 - $155.00. At Voyatek, we believe in supporting our employees with a comprehensive benefits package designed to enhance their well-being and professional growth. Please note that eligibility for certain benefits may vary based on your role and employment status. Flexible Work Schedules Health, Dental, and Vision Insurance Medical, Limited, & Dependent Flexible Spending Accounts (FSA) Health Savings Account (HSA) with Employer Contributions Company-Paid and Voluntary Life Insurance Long and Short-Term Disability Insurance Accident, Critical Illness, & Hospital Indemnity Insurance 401(k) Retirement Plan with Company Match and Immediate Vesting Wellhub Fitness and Wellness Platform Pet Insurance Training Opportunities Employee Referral Bonus Program We are committed to fostering a workplace that supports both your personal and professional aspirations. As part of our commitment to maintaining a compliant workplace, all final candidates will undergo and must successfully pass a pre-employment (post offer) background check. The background check may include, but is not limited to, verification of employment history, education, criminal records, and other relevant checks. Background check results will be evaluated in accordance with applicable law. For certain positions, additional client-specific background screenings may be required at the time of hire or in the future, in accordance with client requirements. If you think you are a good fit for us, we encourage you to apply. Check out our career website for all open positions! Voyatek provides equal employment opportunities to all employees and applicants for employment. Voyatek will make employment decisions without regard to race, color, creed, ancestry, national origin, citizenship, sex or gender (including pregnancy, childbirth, and pregnancy-related conditions), gender identity or expression (including transgender status), sexual orientation, marital status or domestic violence victim status, religion, age, disability, genetic information, service in the military, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Employment decisions include all terms and conditions of employment, including recruitment and hiring, job assignment/ placement, promotion, upgrading, demotion, termination, layoff, recall, transfer, leave of absence, rates of pay or other compensation, internship, and training.