Job Seekers, Please send resumes to resumes@hireitpeople.comDetailed Job Description:
- The EDM serves a critical role in the understanding, documentation, analysis, and design of proposed systems.
- This role encompasses all aspects of data management; conceptual, logical, and physical data modeling; being involved in end - to end data lifecycle management activities; evaluating and recommending new and emerging data management and storage technologies and standards.
- Reviewing Business Requirements Documents (BRDs) and/or User Stories (Agile methodology), translating them into viable conceptual and subsequently, logical data constructs that will be captured in data models
- Creating data models that conform to existing standards and conventions
- Developing mapping documents that demonstrate data lineage
- Revising data dictionaries, governance practices, and standards
- Profiling existing data by writing SQL scripts in the source systems
- Converting Logical Data Models (LDMs) into working Physical Data Models (PDMs), document and maintain lineage between the two artifacts
- Interact with different stakeholders and gather information that would help solve the challenges at hand and help achieve the long-term goals of the project
- 10+ years of experience in data architecture
- 10 or more years of data modeling experience with demonstrated expertise in the analysis and design of large-sized systems
- Thorough knowledge of Erwin Data Modeler (V8 or higher) or a comparable CASE tool
- Knowledge of Agile development methodology and concepts
- Understanding of information systems and data life-cycle management best practices and methodologies, formal systems engineeringlife cycle (SELC), and systems development life cycle (SDLC).
- Experience with Service Oriented Architecture (SOA), web services, enterprise data management, information security, applications development, and cloud-based architectures
- Experience with enterprise data management technologies, including database platforms, ETL tools, and proficiency in SQL
- Experience working as a member of a distributed data architecture team
- Hands-on SQL experience
- Experience with three or more of the following DBMS technologies: Oracle, Microsoft SQL Server, Greenplum, Sybase and UDB
- Good communication skills and customer relationship skills
- Experience in translating business requirements documents into design artifacts, employing the core design principles
- Performs a key leadership role in the areas of advanced data techniques, including data modeling, data access, data integration, data visualization, text mining, data discovery, and statistical methods
- Thorough knowledge of Microsoft Office suite of products
Minimum years of experience*: 10+ years
Certifications Needed: No
Interview Process (Is face to face required?): No
Does this position require Visa independent candidates only? No