Job Title: HBITS-06-13718* - Software Architect (Senior)
Agency Name: Office of Mental Health/ITS, 800 N. Pearl St. Menands, New York, 12204
Full/Part Time: Full-Time
Location: Office of Mental Health/ITS, 800 N. Pearl St. Menands, New York, 12204
Telecommuting: 50%
Requested Qualifications:- 66 Months experience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc.
- 66 Months experience in ERStudio data architect data modeling tool.
- 66 Months experience in relational data management disciplines and design and development experience using Oracle technologies.
- 66 Months experience with SQL programming.
- 60 Months experience working with business intelligence tools (e.g., OBIEE 11G).
- 60 Months experience working with ETL tools (e.g. Informatica).
- 60 Months experience with designing, creating applications and health care Data Warehouse and business intelligence reporting solutions.
- 48 Months experience working with HIPAA requirements or similar standards and NYS Accessibility Standards.
- 48 Months experience with reviewing the data modeling of others for compliance and accepted standards of development.
- Bachelor’s degree in computer science, business intelligence, information science or related field.