Database Architect Expert - Spruce Technology, Inc.
Menands, NY
About the Job
NYS Department of Health is seeking a Database Architect Expert to support the continued development and approval processes of business solutions in response to critical agency requirements for the development efforts for the NYWIC data mart. NYWIC will be NYS's new Electronic Benefits Transfer (EBT) system for WIC participants to receive benefits. The Data Mart will be used for reporting purposes.
The Database Architect will participate in a team approach to:
Requested Qualifications:
Spruce Technology, Inc. is a mid-size, award-winning (Inc 5000, SmartCEO, Entrepreneur of the Year) technology services firm with a steadily growing portfolio of commercial and government clients. Spruce provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide. Spruce maintains partnerships with major technology vendors and continually develops leading-edge offerings in service areas such as digital experience, data services, application development, infrastructure, cyber security, and IT staffing.
Spruce Technology, Inc. is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Consistent with the Americans with Disabilities Act, it is the policy of Spruce Technology, Inc. to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process.
The Database Architect will participate in a team approach to:
1.Work with SMEs, Business Analysts and Technology teams to understand the data requirements and the full attribute set for entities and dimensions.
2.Convert business processes, domain specific knowledge, and information needs into a conceptual model.
3.Convert conceptual models into logical models with detailed descriptions of entities and dimensions.
4.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.
5.Develop data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc.
6.Model aggregation layers and specific star schemas as subject areas within a logical and physical model.
7. Understand and meet referential data integrity requirements.
8.Document decisions made in meetings and alternative solutions discussed.
9.Schedule, facilitate, and record report development meetings as needed.
2.Convert business processes, domain specific knowledge, and information needs into a conceptual model.
3.Convert conceptual models into logical models with detailed descriptions of entities and dimensions.
4.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.
5.Develop data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc.
6.Model aggregation layers and specific star schemas as subject areas within a logical and physical model.
7. Understand and meet referential data integrity requirements.
8.Document decisions made in meetings and alternative solutions discussed.
9.Schedule, facilitate, and record report development meetings as needed.
Role Details:
- Full time role with engagement lenth of 14months
- Daily work hours: 8 working hours plus a lunch break. Daily start time must be between 7:00 and 8:30, and end time between 3:30 and 5:00. Once selected, the start and end times should not vary on a daily basis.
- Physical office location: 800 N. Pearl St. Menands, NY 12204
- 50% Telecommuting will be allowed
Requested Qualifications:
- 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
- 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.
- 84 Months Experience in relational data management disciplines and design and development experience using Oracle technologies.
- 84 Months Experience utilizing SQL programming for data analysis purposes in a data warehouse/business
- intelligence environment
- 72 Months Experience with business intelligence tools (e.g., OBIEE 11G) involving data analytics.
- 72 Months Experience with designing, developing and creating applications in health care business intelligence reporting solutions.
- 48 Months Attended and participated in information and requirements gathering sessions, including translating business requirements into data requirements.
- Bachelor's degree in business intelligence,
- information science, computer science, or mathematics.
Spruce Technology, Inc. is a mid-size, award-winning (Inc 5000, SmartCEO, Entrepreneur of the Year) technology services firm with a steadily growing portfolio of commercial and government clients. Spruce provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide. Spruce maintains partnerships with major technology vendors and continually develops leading-edge offerings in service areas such as digital experience, data services, application development, infrastructure, cyber security, and IT staffing.
Spruce Technology, Inc. is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Consistent with the Americans with Disabilities Act, it is the policy of Spruce Technology, Inc. to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process.
Source : Spruce Technology, Inc.