Job Description :
Jr. Oracle DB ErWin SQL Developer (05161)
Albany, NY
24 Months
Rate is 35$
Job Description:
This Data Modeling position is required to support the continued development and approval processes of business solutions in response to critical agency requirements for a portfolio of agency products.
Daily Tasks will include but not limited to the following:
The Data Modeler 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.
Skills:
1. 54 Months Demonstrated hands-on 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 #of months
2. 54 Months Demonstrated hands-on experience using a data modeling tool (e.g., ErWin #of months
3. 54 Months Demonstrated hands-on experience in relational data management disciplines and design and development experience using Oracle database technologies. #of months
4. 54 Months Demonstrated hands-on experience utilizing SQL programming for data analysis purposes in a data warehouse/business intelligence environment. #of months
5. 36 Months Demonstrated hands-on, in-depth experience with designing, developing and creating solutions in a health care business intelligence reporting environment #of months
6. 36 Months Demonstrated analytics and communications experience (e.g., math, statistics, quantitative methods, and writing #of months
7. 36 months Demonstrated communication experience (e.g. writing) #of months
8. 24 Months Demonstrated hands-on experience with reviewing the data modeling of others for compliance and accepted standards of development. #of months
9. Bachelor’s degree in business intelligence, information science, computer science, or mathematics. #of months