Voyatek
NYS ITS HBITS-07-14342 Senior Systems Architect (SQL)
Voyatek, Albany, New York, United States
NYS ITS HBITS-07-14342 Senior Systems Architect (SQL)
Join to apply for the
NYS ITS HBITS-07-14342 Senior Systems Architect (SQL)
role at
Voyatek
Location: Albany, NY
Responsibilities
Analyze, design, and create functional specifications that adhere to IT standards and policies.
Develop and implement ETL processes for the migration of NYS DMV legacy data.
Participate in requirement gathering and design discussions.
Communicate verbally with senior IT subject‑matter experts to elicit requirements.
Migrate data to appropriate repositories while complying with data standards and policies.
Collaborate in a team environment and work independently as needed.
Assist with quality assurance testing.
Qualifications
60–84 months of experience; able to work independently and provide guidance to others.
Advanced education preferred.
Preferred: 60 months experience designing, developing, and testing for migration of legacy data with 10+ data sources; 60 months SQL experience; testing experience (data validation, comprehensive test plans, execution, data reconciliation).
Experience documenting workflow processes in modeling tools (e.g., Visio).
Data modeling and ETL experience using IBM Infosphere DataStage or similar.
Benefits
Flexible work schedules.
Health, dental, and vision insurance.
Medical, limited, and dependent flexible spending accounts (FSA).
Health Savings Account (HSA) with employer contributions.
Company‑paid and voluntary life insurance.
Long‑term and short‑term disability insurance.
Accident, critical illness, and 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.
Employment & Background Check All final candidates will undergo and must successfully pass a pre‑employment background check, which may include verification of employment history, education, criminal records, and other relevant checks. Background check results will be evaluated in accordance with applicable law. Certain positions may require additional client‑specific screenings.
Equal Employment Opportunity 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.
#J-18808-Ljbffr
NYS ITS HBITS-07-14342 Senior Systems Architect (SQL)
role at
Voyatek
Location: Albany, NY
Responsibilities
Analyze, design, and create functional specifications that adhere to IT standards and policies.
Develop and implement ETL processes for the migration of NYS DMV legacy data.
Participate in requirement gathering and design discussions.
Communicate verbally with senior IT subject‑matter experts to elicit requirements.
Migrate data to appropriate repositories while complying with data standards and policies.
Collaborate in a team environment and work independently as needed.
Assist with quality assurance testing.
Qualifications
60–84 months of experience; able to work independently and provide guidance to others.
Advanced education preferred.
Preferred: 60 months experience designing, developing, and testing for migration of legacy data with 10+ data sources; 60 months SQL experience; testing experience (data validation, comprehensive test plans, execution, data reconciliation).
Experience documenting workflow processes in modeling tools (e.g., Visio).
Data modeling and ETL experience using IBM Infosphere DataStage or similar.
Benefits
Flexible work schedules.
Health, dental, and vision insurance.
Medical, limited, and dependent flexible spending accounts (FSA).
Health Savings Account (HSA) with employer contributions.
Company‑paid and voluntary life insurance.
Long‑term and short‑term disability insurance.
Accident, critical illness, and 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.
Employment & Background Check All final candidates will undergo and must successfully pass a pre‑employment background check, which may include verification of employment history, education, criminal records, and other relevant checks. Background check results will be evaluated in accordance with applicable law. Certain positions may require additional client‑specific screenings.
Equal Employment Opportunity 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.
#J-18808-Ljbffr