Database Architect - i-Link Solutions Inc
Menands, NY 12204
About the Job
Job Title: Database Architect- Expert
Task ID: HBITS-05-13322
Position Duration: 30 months
Client: State of NY
Agency: Department of Health
Please call (703) 466-0951 | (571) 351-1868 or email at nysreqs@ilinksolutions.com
Description:
Daily Tasks will include but not limited to the following:
The Database Architect will participate in a team approach to:
Mandatory Qualifications
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-
Task ID: HBITS-05-13322
Position Duration: 30 months
Client: State of NY
Agency: Department of Health
Please call (703) 466-0951 | (571) 351-1868 or email at nysreqs@ilinksolutions.com
Description:
Daily Tasks will include but not limited to the following:
The Database Architect will participate in a team approach to:
- Work with SMEs, Business Analysts and Technology teams to understand the data requirements and the full attribute set for entities and dimensions.
- Convert business processes, domain specific knowledge, and information needs into a conceptual model.
- Convert conceptual models into logical models with detailed descriptions of entities and dimensions.
- Develop and maintain fully defined conceptual, logical and physical dimensional data models to ensure the information models are capable of meeting end user and developer needs.
- Develop data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc.
- Model aggregation layers and specific star schemas as subject areas within a logical and physical model.
- Understand and meet referential data integrity requirements.
- Document decisions made in meetings and alternative solutions discussed.
- Schedule, facilitate, and record report development meetings as needed.
Mandatory Qualifications
1 | 84 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. in a data warehouse/business intelligence environment |
2 | 84 Months Experience in a data modeling tool (e.g., Erwin).Experience with reviewing the data modeling of others for compliance and accepted standards of development. |
3 | 84 Months Experience in relational data management disciplines and design and development experience using Oracle technologies. |
4 | 84 Months Experience utilizing SQL programming for data analysis purposes in a data warehouse/business intelligence environment |
5 | 72 Months Experience with business intelligence tools (e.g., OBIEE 11G) involving data analytics. |
6 | 72 Months Experience with designing, developing and creating applications in health care business intelligence reporting solutions. |
7 | 48 Months Attended and participated in information and requirements gathering sessions, including translating business requirements into data requirements. |
8 | Bachelor's degree in business intelligence, information science, computer science, or mathematics. |
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-
Source : i-Link Solutions Inc