Data Modeler
: Job Details :

SR. DATA MODELER

ON SITE ( 3 DAYS A WEEK) in Dallas, Texas, Hazelwood, MO, or OK

Contract Position

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

Key Requirement: Demonstrated experience in Data Vault tool 2.0

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?

General Requirements

• Exhibit and practice courteous, ethical, and professional behavior while interacting with both internal and external customers
• Influence/make technology decisions for the platform at enterprise level
• Act in a collaborative, team-oriented environment focused on common goals to achieve mutually beneficial results
• Be accountable and responsible for the accuracy and completeness of assigned work and results
• Prioritize and manage workload and communicate issues clearly
• Exhibit effective verbal and written communication skills
• Comply with all laws, regulations, and company policies
• Travel when required