Opportunity Details Full Time NYS IES PRD-20250723-436 Level 3 Developer (Lead Data Integration Developer) 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 programSupports first responders in reducing opioid overdoses within their communitiesEmpowers colleges and universities to identify and thwart financial aid fraudEquips teachers with valuable insights to identify students requiring additional supportEnhances efficiency for state tax agencies, leading to 99% faster return processing and quicker refunds for taxpayersWith 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 Developer within our teamNYS Integrated Eligibility Systems located in Albany, NY. This position is a 18 month contract, hybrid (up to 50%). 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:Daily activities will include, but are not limited to: Perform analysis, design, development and implementation, including data analysis, data access, data structures, data transformation, data reporting solutions and user documentationAct as the primary ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performanceManage and administer ETL solutions for medium to large scale OLTP and OLAP projects.Monitor daily ETL jobs and processes that identify load and performance issues and determine the resolution and revise the incorrect operational processes.Communicate and coordinate with members of the development team to work across multiple projects.Explore, actively support and work on new technology initiatives that may be of interest to the organization. Actively participate in troubleshooting any technical issues that the program may have.Other duties as assignedQualifications:Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a DeveloperMore than (7) years of experience in analysis, design, development, testing and implementation of data integration solutions using PL/SQL & relational databases.Five or more years of hands-on experience in implementing and maintaining data integration processes using Informatica suite of products such as Informatica PowerCenter and/or Informatica Data Quality. Preferred Qualifications:Seven years or more of hands-on experience using ETL tools like Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, and XML files, UNIX shell scripts.Seven or more years of experience developing complex SQL, PLSQL objects with Oracle 11g or higher such as stored procedures, triggers, packages, materialized view and using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages to migrate data.Five or more years of experience with Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge functionality using tools such as Informatica Data Quality.Seven years or more experience in implementing concepts such as Slowly Changing Dimension (SCD Type) and Change Data Capture (CDC) functionality in both an OLTP (Relational Modeling) and OLAP (Dimensional Modeling) environments.Seven or more years of experience writing complex UNIX scripts to validate and ftp files, and for scheduling / automating ETL processes.Seven years or more of experience in performance tuning SQL scripts, complex PL/SQL objects such as procedures, functions, triggers, packages, tables, views and indexes.Experience with implementing ETL solutions for medium to large scale OLTP and OLAP projects.Experience in writing technical specifications including ETL source to target mapping documents, ETL design documents, implementation documents.Experience with Health & Human services applications.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 $70.00 - $75.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 ContributionsCompany-Paid and Voluntary Life InsuranceLong and Short-Term Disability InsuranceAccident, Critical Illness, & Hospital Indemnity Insurance401(k) Retirement Plan with Company Match and Immediate VestingWellhub Fitness and Wellness PlatformPet InsuranceTraining OpportunitiesEmployee Referral Bonus ProgramWe 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.Apply here: https://www.aplitrak.com/?adid=YmJnZW5lcmljLjkwNTYxLjEwNDE3QGFzcmFuYWx5dGljc2NvbXAuYXBsaXRyYWsuY29t
Minimum Salary: 70.00
Maximum Salary: 75.00
Salary Unit: Hourly