Data Warehouse Programming Specialist jobs in Albany, NY

If you value job security, work life balance, and opportunities for growth, join us at the New York State Office of Mental Health as an Information Technology Specialist 3 (Programming) to receive all of that and more!

Who We Are:
New York State has a large, multi-faceted mental health system that serves more than 700,000 individuals each year. The Office of Mental Health (OMH) operates psychiatric centers across the State. OMH also regulates, certifies and oversees more than 4,500 programs, operated by local governments and nonprofit agencies. Our mission is to promote the mental health of all New Yorkers, with a particular focus on providing hope and recovery for adults with serious mental illness and children with serious emotional disturbances.

What We Offer:

• NYS pension and retirement programs
• Comprehensive medical, dental, and vision plans
• Flexible spending accounts for health and dependent care
• Paid time off, including thirteen paid holidays per year, personal leave, vacation leave, and sick leave

What We Stand For:
The Mission of the New York State Office of Mental Health is to promote the mental health of all New Yorkers, with a focus on providing hope and supporting recovery for adults with serious mental illness and children with serious emotional disturbances. Applicants with lived mental health experience are encouraged to apply. OMH is deeply committed to supporting underserved individuals, organizations, and communities. To this end, OMH is focused on implementing activities and initiatives to reduce disparities in access, quality, and treatment outcomes for underserved populations. A critical component of these efforts is ensuring OMH is a diverse and inclusive workplace where all employees' unique attributes and skills are valued and utilized to support the mission of the Agency. OMH is an equal opportunity/affirmative action employer.

Duties Description:
The Information Technology Specialist 3 (Programming) will perform activities including, but not limited to, technical activities related to writing instructions (code), applications program development, program and system testing, and business/systems analysis and design and development of database systems for agency specific applications. The position is expected to provide application support for OMH business units and clinical programs.

Duties include, but are not limited to:

• Leads in planning and conducting application programming design, coding, testing, and debugging activities.
• Expert level knowledge of Python, JavaScript, and/or object-oriented programming languages.
• Knowledge parsing XML and/or JSON is a plus.
• Working knowledge of SQL and relational database design, as well as experience with manipulating and importing data from flat files is preferred.
• Knowledge of PowerShell and/or shell scripts such as bash is preferred.
• Will review code written by junior programmers, offer suggestions, provide coaching and perform knowledge sharing activities to help develop junior programmer skillsets.
• Maintains and analyzes systems performance after implementation by testing and documenting system changes resulting from operation errors or system failures, changes in legislation, user requirements, or changes in the IT environment.
• Participates in meetings and works with agency management, users, vendors, consultants, and IT staff to discuss IT solution options and assists in recommending appropriate system platforms for meeting program requirements.
• Will assist with various design activities such as creating program specifications, workflow diagrams or structured charts, and logical data models.
• Will participate in the testing phase of application development by assisting in the development of test plans, test conditions, validation testing, and performing quality assurance and user acceptance tests of programs and systems.
• Design, support and troubleshoot low-code applications utilizing Microsoft Power Automate, SharePoint and Teams for OMH business units and facility clinical staff.
• Maintains thorough understanding of the environment to ensure adherence to standards and utilizes accepted practices for enterprise design.
• Reviews current and proposed architectures to meet acceptable enterprise system practices.
• Makes recommendations for infrastructure improvements and deploys and maintains systems in accordance with established guidelines.
• Identify, analyze, and resolve issues for existing systems resulting from errors detected during, testing, implementation and/or daily use.
• Will participate on the following projects, that include but are not limited to: Electronic Health Record Implementation, Infection Prevention and Control, Outpatient Scheduling, Internal Reporting, Cerner Upgrade, and Telehealth projects.
• Demonstrate strong, professional, respectful communication skills, both verbally and in writing.
• Demonstrate an interest in developing a deep understanding of OMH enterprise software and systems to develop a technical expertise that will help facilitate excellent end-user support.
• Maintain a collaborative environment that fosters and supports creative solutions and continuous improvement.
• Maintain a working environment that is committed to attracting, developing, and retaining a competent and highly motivated workforce.
• Must be able to work in a fast-paced environment where technical issues must be quickly resolved and communicated to end users.

Minimum Qualifications

Candidates must have a bachelor's or higher level degree in any field including or supplemented by 15 semester credit hours in computer science with at least 9 semester credit hours in programming languages AND two years of experience in computer programming;

OR 2. a bachelor's or higher level degree in any field AND three years of experience in computer programming;

OR 3. an associate's degree* with 15 semester credit hours in programming languages AND four years of experience in computer programming;

OR 4. five years of experience in computer programming.

Additional Comments:
Specific scheduled hours and telecommuting availability for this position will be discussed during the interview process. The number of permissible telecommuting days for each employee will be determined by the current work demands/assignments, as well as program operational needs and employee performance/productivity, but may not exceed 50% telecommuting in a two-week payroll period.

Job Type: Full-time

Pay: From $81,705.00 per year

Benefits:

• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Parental leave
• Retirement plan
• Vision insurance

Schedule:

• 8 hour shift
• Monday to Friday

People with a criminal record are encouraged to apply

Work Location: In person