Opportunity Details

Full Time NYPA Senior Data Engineer (CWP 1187)

White Plains, NY (Hybrid)

Outcomes. Delivered.

Voyatek, formerly GCOM Software and OnCore Consulting, 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 Mid-Level Data Engineer within our team.

Client Details:

The New York Power Authority (NYPA) is the largest state public power organization in the United States, renowned for its role in providing clean, affordable, and reliable energy. NYPA's mission is to power New York with clean energy while driving economic growth and sustainability. It focuses on reducing greenhouse gas emissions, modernizing the state's energy infrastructure, and promoting energy efficiency and innovation across sectors .

Key Responsibilities:

ETL & Data Integration: Design, develop, and optimize ETL pipelines using Azure Databricks, ADF, and Pentaho to support enterprise data workflows. Implement and maintain data movement, transformation, and integration across multiple systems. Ensure seamless data exchange between cloud, on-prem, and hybrid environments. Work with Globalscape FTP for secure file transfers and automation. API Development and Integration: Develop, consume, and integrate RESTful and SOAP APIs to facilitate data. Work with API gateways and authentication methods such Oauth, JWT, certificate, and API keys. Implement and optimize API-based data extractions and real-time data integrations Data Quality & Governance: Implement data validation, cleansing, and enrichment techniques. Develop and execute data reconciliation processes to ensure accuracy and completeness. Adhere to data governance policies and security compliance standards. BAU Support & Performance Optimization: Troubleshoot and resolve ETL failures, data load issues, and performance bottlenecks. Optimize SQL stored procedures and complex queries for better performance. Support ongoing enhancements and provide operational support for existing data pipelines. Collaboration & Documentation: Work closely with Data Analysts, Business Analysts, and stakeholders to understand data needs. Document ETL processes, data mappings, and workflows for maintainability and knowledge sharing. Provide guidance and best practices to ensure scalability and efficiency of data solutions. Qualifications: 7+ years of experience in ETL development, data integration, and SQL scripting. Strong expertise in Azure Databricks, ADF (Azure Data Factory), and Pentaho. Experience handling secure file transfers using Globalscape FTP. Hands-on experience in developing and consuming APIs (REST/SOAP). Experience working with API security protocols (Oauth, JWT, API Keys, etc.,). Proficiency in SQL, stored procedures, performance tuning, and query optimization. Understanding of data modeling, data warehousing, and data governance best practices. Strong problem-solving skills, troubleshooting abilities, and ability to work independently. Excellent communication skills and ability to work in a fast-paced environment. Education & Certifications Bachelor's or Master's degree in a relevant field like Computer science , Data Engineering or related technical field Nice to have below certifications: a) Databricks certified Data Engineer b) Azure Data Engineer associate. Preferred Qualifications: Hands-on experience with cloud-based data platforms (Azure/AWS) is a plus. Experience working in large-scale enterprise data integration projects. Knowledge of Python, PySpark for big data processing. Familiarity with CI/CD for data pipelines (Azure DevOps, GitHub Actions, etc.). 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 and 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 $57.00 - $67.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 pass a comprehensive background screening prior to starting work. This screening may include, but is not limited to, verification of employment history, education, criminal records, and other relevant checks. For certain positions, additional client-specific background screenings may be required in the future, in accordance with client requirements.

Voyatek does significant work with Federal and State tax and revenue authorities. If applicable to this role, all hires will be required to obtain a Federal Public Trust Clearance (Moderate Background Investigation). This clearance process may start upon offer acceptance; and must be cleared prior to working on these projects.

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.