Candidate must be DVA Certified
Job Description –
Data Modeler (linkedin)
Remote: with preference to candidates in Dallas or Columbus (Occasionally Meetings.)
“looking for an Architect with deep understanding of warehousing concepts and data modeling particularly in DataVault.
-“looking for someone who has recent experience in Data Vault.”
-“DVA certification is a must.
Overview
As a data modeler you have key role and autonomy to lead the data modeling domain. Will lead in planning, evaluating, and selecting the right data model for applications across the enterprise from business apps to apps of insight. ?As part of a highly collaborative team, the role will interact with many technical and business resources across the enterprise.?The ideal candidate is a committed, creative, self-motivated technologist who is interested in practicing his or her skills and learning new ones.
Primary Duties and Responsibilities
Analyzing and translating business needs into long-term solution data models
Business and technical requirement elicitation, analysis, and elaboration
Continuously monitoring and improving the critical data models to better support the business
Working with business services, software engineering, business to create business, logical and physical data models
Developing and enforcing best practices for data modeling to ensure consistency within the system
Evaluating implemented data systems for variances, discrepancies, and efficiency
Create/Author/Edit architecture documents, design documents, data flow diagrams
Leverage and enforce standards for data naming conventions to ensure consistency and reuse of data models
Designing and documenting architecture at multiple levels (high-level to detailed) and across multiple views (conceptual, logical, physical, data flow and sequence diagrams)
Evaluate existing data models and physical databases for variances and discrepancies
Create and maintain data models for NoSQL databases like cosmos DB, MongoDB
Collaborating with Enterprise Architects in developing logical, physical data models
Working efficiently with various stakeholders and business units within the firm to understand data for ingestion and integration into a common data model
Providing direction to a Data Engineering team in building in developing, populating, and publishing data into an enterprise data model
Assisting end users in understanding the established data models and consuming data for their downstream application and use
Working with the platform team to optimize data mapping and data mastering functions
Organize working sessions with business operations team to understand sources of data and expected output
Complete other tasks as required
Experience, Education and Skills
10+ years of Experience in Information Technology
5+ years’ experience in developing, validating, publishing, maintaining Business, Logical & Physical data models
3+ Experience creating and maintaining Enterprise or Corporate Data model
5+ Experience designing application databases, Enterprise Data Warehouse, Data Hub, Delta Lake, Data Vault, Data Analytics Marts
5+ Experience with 3NF, BPMN, data vault, dimensional modeling – star and snowflake
5+ experience with data modeling tools like Erwin, ER/Studio or Archi
3+ experience with data management activities data quality, master data management, data governance, meta data management
2+ experience in establishing data dictionaries, data models and documenting technical requirements
2+ years of development or DBA experience in RDBMS systems
5+ years strong SQL experience
2+ Experience modeling Master/Reference data
2+ Experience with SAP ECC and Salesforce data models
Experience with data migration, data profiling and data mapping to target
Experience in reverse engineering and defining data models based on profiling of legacy or existing applications.
Experience designing database environments
Experience in developing and enforcing data modeling standards and procedures.
Experience with ITSM, Agile methodologies preferred.
Strong interpersonal and communication skills
Strong consulting and customer relationship skills
Proven work ethic with the utmost integrity
Self-awareness, with a desire for constant self-improvement (goal-oriented)
Personality traits for successful individuals may include self-motivated, passionate, empathetic, approachable, energetic
Bachelor’s?degree?from an accredited institution or equivalent industry experience?
From:
shivani sharma,
adventatech
shivani.sharma@adventatech.com
Reply to: shivani.sharma@adventatech.com