-
ID
#8108139 -
Job type
Permanent -
Salary
TBD -
Source
Honu Services -
Date
2021-01-12 -
Deadline
2021-03-13
Data Modeler/Architect
California, Sandiegocaliforniaus, 92103 Sandiegocaliforniaus USAPermanent
Vacancy expired!
- Model in Kimball's dimensional methodology using the Project Lead's requirements.
- Design/modify logical and physical dimensional models using Erwin to meet business' reporting requirements.
- Prepare and document standards and procedures for dimensional data modeling and naming conventions.
- Perform a variety of activities including data modeling and documentation, database design tasks and data and system analysis, data queries and database design tasks with a team with various skills. These efforts include, but not limited to, capturing and developing data requirements, database design support, data modeling interpretation, application design and prototyping solutions.
- Perform data modeling and subject matter support to ensure data specifications and requirements to meet long-term needs. This includes analyzing and defining data requirements and specifications.
- Create data models (both transacting and warehouse applications) using Kimball methodology, industry best practices and standard processes to ensure high quality data to reduce redundancy and support efficient reporting.
- Develop and maintain data standards, process documentation and templates that assist in a common understanding of data models and data marts and the processes that involve in developing them.
- Support data standardization efforts including best practice standards, naming conventions, and synchronization of shared data requirements across subject areas throughout
- Work within the team to assist in the design of the overall ETL data warehouse architecture: Understanding of ETL strategy, staging databases and data quality.
- Support database development including the build and maintenance of stored procedures and advanced SQL/PLSQL techniques.
- Extensive working knowledge of current SAP Business Intelligence tools, Oracle SQL and PL/SQL and databases, Toad, Erwin, and Kimball Methodology.
- Extensive experience with data modeling (knowledge of conceptual, logical and physical models).
- Perform data analysis of extraction source systems and provide architecture guidance for data models
- 7+ years of practical experience minimum
- Must possess and maintain an IAT level II certification IAW DoD 8570.01-M
- Understanding and experience in a broad range of data and database competencies
- Experience assessing impacts of legacy systems and addressing data related problems of system integration and compatibility
- Experience defining an overall data architecture as it relates to task goals during the analysis, design, planning phases and implementation of each project
- Ability to prioritize and meet deadlines
- Strong critical thinking skills
- Self-starter requiring minimal supervision
- Proficient problem-solving skills
- Strong verbal communication to effectively express concepts, plans, and proposals
- Works well in a team environment
- Enjoys the challenges of a dynamic research and development project
- Must be a
- SAP Business Intelligence (Business Objects) 4.x (Webi, Crystal, Xcelsius)
- Oracle SQL /PLSQL
- TOAD and SQLNavigator
- Informatica (ETL Tool)
- CA Erwin (Data Modeling tool)
Vacancy expired!
Report job