Senior Data Modeler - Local to OH

Job Description -

Senior Data Modeler

Client:  Flight Safety- Citizens only -  Excellent Old LinkedIn profile with picture and native citizens only

As a Senior 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.

**Preference for location is to be in Columbus, OH, Dallas or Broken Arrow, TX. ( Locals )

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+ years' experience creating and maintaining Enterprise or Corporate Data model

• 5+years' experience designing application databases, Enterprise Data Warehouse, Data Hub, Delta Lake, Data Vault, Data Analytics Marts

• 5+years' experience with 3NF, BPMN, data vault, dimensional modeling - star and snowflake

• 5+years' experience with data modeling tools like Erwin, ER/Studio or Archi

• 3+years' experience with data management activities data quality, master data management, data governance, metadata management

• 2+years' 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+years' experience modeling Master/Reference data

• 2+years' 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

In addition to the Job Description, looking for the following skill set:

• Safe, LeSS, or Modern Agile experienced individuals (Culture of Lean/Scrum/XP methods)

• Ability to work in the context of waterfall IT controls

• Familiar with InfoSec control levels

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