Software Developer

i-Link Solutions; Village of Menands (NY); On-site; USD 100,000 - 140,000; Full time

Job summary

i-Link Solutions is hiring a Software Developer – Expert to develop and optimize Oracle SQL queries in the NYWIC environment, support data analysis, and collaborate with program staff and vendors on data mappings. The role emphasizes complex SQL, OBIEE reporting, and documentation.

Responsibilities include creating validated data queries, maintaining reusable SQL libraries, and assisting in UAT alongside ITS and program managers. A Bachelor’s degree in IT or related field is required.

Qualifications

• 7+ years of experience creating SQL queries and stored procedures using Oracle PL/SQL.

Responsibilities

• Develop, test and execute Oracle SQL queries against the NYWIC Production database as requested for validation and data analysis.
• Develop and maintain a library of SQL queries for recurring parameterized requests.
• Assist DOH staff in understanding NYWIC data structures for new reports.
• Assist in developing ad-hoc queries in the NYWIC Datamart OBIEE system with guidelines.
• Collaborate with NYWIC Datamart team, staff and vendor to map data between NYWIC and the Datamart.
• Participate in reviewing and documenting regression test scripts for UAT.
• Provide general support for UAT efforts and work with ITS and Program managers on policies.

Skills

Oracle SQL

PL/SQL

Requirements gathering

Software documentation

Data analysis

Oracle Reports

OBIEE

End-user training

Education

Bachelor's degree in IT related field

Tools

OBIEE

Oracle Datamart

Job description

Agency: NYS Department of Health

Contact: [phone] | [phone] | [phone] or email at [e-mail]

Job Title: Software Developer – Expert

Task ID: HBITS-08-15016

Position Duration: 30 Months

Client: State of NY

Agency: NYS Department of Health

Description

• Develop, test and execute Oracle SQL queries against the schema of the Production NYWIC database upon request, for program validation and data analysis
• Develop and maintain a library of SQL queries that can be executed on a recurring basis with different parameters, for similar requests
• Assist DOH program staff in understanding NYWIC data structures within the NYWIC modules, for developing new report requirements
• Assist DOH program staff in developing new ad-hoc queries within the NYWIC Datamart OBIEE system, using defined user guidelines and additional guidance from the NYWIC Datamart team as needed
• Work with NYWIC Datamart team members, program staff, and the NYWIC application vendor as needed to develop a knowledgebase of system data mappings between the NYWIC application and the Datamart, for program assistance
• Participate in review and/or documentation of regression test scripts for user acceptance testing
• Provide general support for user acceptance testing efforts
• Work closely with ITS and Program managers to ensure adherence to standard policies and procedures

Mandatory Qualifications

• 1 84 months of experience creating SQL queries and stored procedures using Oracle PL/SQL
• 2 84 months of experience meeting with business staff to elicit business requirements
• 3 84 months of experience working with business staff or end users to analyze or troubleshoot Oracle reports
• 4 84 months of experience creating software documentation including functional specifications and technical specifications
• 5 48 months of experience analyzing, optimizing Oracle SQL queries and improving database performance
• 6 48 months of experience preparing or facilitating the creation of testing scenarios and test scripts
• 7 36 months of experience creating user documentation such as user guides or training presentations
• 8 36 months of experience using OBIEE (Oracle Business Intelligence Enterprise Edition), including end user experience
• 9 Bachelor's Degree in an Information Technology related field, from an accredited institution.

Required Documentation

• Résumé
• Copy of Candidate Identification

(i.e., Driver's License/Green Card/Visa and Passport if applicable)

• Any documents referenced in the above Requested Qualifications

(i.e., professional certifications, degrees, etc.)

i-Link Solutions requires a Bachelor's Degree or its equivalent in Computer Science, Computer Information Systems, Information Systems or a closely related field of study for all positions.

Disclaimer

i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability