Data Systems Specialist

Health Research, Inc. • Albany, NY

1d • Hybrid

About The Position

The Office of Data Systems Development and Reporting (DSDR) develops and maintains information systems for both service providers and AIDS Institute staff. It coordinates content and data submissions for Federal and State reporting requirements and reviews and submits data as required for Ryan White reporting. The incumbent will provide technical and data systems support, participate in AIDS Institute Reporting System (AIRS) testing, and disseminate information to funded agencies who utilize the AIRS required for Federal and State reporting. In addition, the incumbent will use VB .NET experience to support a custom Ryan White RSR database application and other in-house built tools. Working as part of a multi-disciplinary team alongside subject matter experts, the Data Systems Specialist will support the planning, execution, and delivery of various data-related projects. The incumbent will be responsible for data lifecycle management activities, including extracting, cleaning, and collating data across multiple AIDS Institute sources. The incumbent will also support the management of routine data transfers and formal data requests. This is a hands-on technical role using SQL and involves accessing data and utilizing various software to help process, extract, manipulate, and clean datasets from diverse environments, and when required develop reusable Python scripts to reduce manual data-wrangling hours. To support HIV, Hepatitis, STI-related, and other program measures for reporting, the incumbent will generate recurring and ad-hoc reports using SAP Business Objects Crystal Reports and Web Intelligence. Other appropriate related duties.

Requirements

• Bachelor's degree in related field and two years of system analysis, experience in testing, troubleshooting reporting issues, and/or quality assurance; OR an Associate's degree in a related field and four years of such experience; OR six years of such experience.
• Valid and unrestricted authorization to work in the U.S. is required.
• Must reside within a reasonable commuting distance of the official work location specified in the job posting and must also be located in or willing to relocate to one of the following states: New York, New Jersey, Connecticut, Vermont, or Massachusetts, prior to hire.

Nice To Haves

• At least one year of experience working with healthcare clients’ data, including a proven understanding of security protocols and compliance when handling sensitive health-related data and PHI (Protected Health Information).
• At least two years of experience using SQL or other relational databases and advanced MS Excel.
• At least one year of experience with SAP BI Business Objects Crystal Reports and Web Intelligence, and/or AIRS.
• At least one year of programming experience, leveraging logical problem-solving to independently troubleshoot and resolve system issues.
• At least one year of experience programing with VB .NET.
• Strong data profiling skills, with experience cleaning, manipulating, and validating data from disparate sources to ensure accuracy.

Responsibilities

• Develop, maintain information systems for both service providers and AIDS Institute staff.
• Coordinate content and data submissions for Federal and State reporting requirements.
• Review and submit data as required for Ryan White reporting.
• Provide technical and data systems support.
• Participate in AIDS Institute Reporting System (AIRS) testing.
• Disseminate information to funded agencies who utilize the AIRS required for Federal and State reporting.
• Use VB .NET experience to support a custom Ryan White RSR database application and other in-house built tools.
• Support the planning, execution, and delivery of various data-related projects.
• Responsible for data lifecycle management activities, including extracting, cleaning, and collating data across multiple AIDS Institute sources.
• Support the management of routine data transfers and formal data requests.
• Access data and utilize various software to help process, extract, manipulate, and clean datasets from diverse environments.
• Develop reusable Python scripts to reduce manual data-wrangling hours.
• Generate recurring and ad-hoc reports using SAP Business Objects Crystal Reports and Web Intelligence.
• Perform other appropriate related duties.

Benefits

• Health, dental and vision insurance
• Flexible benefit accounts - Medical, dependent care, adoption assistance, parking and transit
• Generous paid time off - Paid federal and state holidays, paid sick, vacation and personal leave
• Tuition support
• Retirement Benefits - HRI is a participating employer in the New York State and Local Retirement System and offers optional enrollment in the New York State Deferred Compensation Plan.
• Postretirement Health Benefits Plan for qualified retirees to use towards health insurance premiums and eligible medical expenses
• Employee Assistance Program - Provides educational and wellness programs, training, and 24/7 confidential services to assist employees, both personally and professionally

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level