Revel IT
Senior Data Engineer - Data Modeler, open to remote
Revel IT, Columbus, Ohio, United States, 43224
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. However due to the urgency, will look at remote candidates.
Primary Duties and Responsibilities
Analyzing and translating business needs into long-term solution data modelsBusiness and technical requirement elicitation, analysis, and elaborationContinuously monitoring and improving the critical data models to better support the businessWorking with business services, software engineering, business to create business, logical and physical data modelsDeveloping and enforcing best practices for data modeling to ensure consistency within the systemEvaluating implemented data systems for variances, discrepancies, and efficiencyCreate/Author/Edit architecture documents, design documents, data flow diagramsLeverage and enforce standards for data naming conventions to ensure consistency and reuse of data modelsDesigning 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 discrepanciesCreate and maintain data models for NoSQL databases like cosmos DB, MongoDBCollaborating with Enterprise Architects in developing logical, physical data modelsWorking efficiently with various stakeholders and business units within the firm to understand data for ingestion and integration into a common data modelProviding direction to a Data Engineering team in building in developing, populating, and publishing data into an enterprise data modelAssisting end users in understanding the established data models and consuming data for their downstream application and useWorking with the platform team to optimize data mapping and data mastering functionsOrganize working sessions with business operations team to understand sources of data and expected outputComplete other tasks as requiredExperience, Education and Skills
10+ years of experience in Information Technology5+ years' experience in developing, validating, publishing, maintaining Business, Logical & Physical data models3+ years' experience creating and maintaining Enterprise or Corporate Data model5+years' experience designing application databases, Enterprise Data Warehouse, Data Hub, Delta Lake, Data Vault, Data Analytics Marts5+years' experience with 3NF, BPMN, data vault, dimensional modeling - star and snowflake5+years' experience with data modeling tools like Erwin, ER/Studio or Archi3+years' experience with data management activities data quality, master data management, data governance, metadata management2+years' experience in establishing data dictionaries, data models and documenting technical requirements2+ years of development or DBA experience in RDBMS systems5+ years strong SQL experience2+years' experience modeling Master/Reference data2+years' experience with SAP ECC and Salesforce data modelsExperience with data migration, data profiling and data mapping to targetExperience in reverse engineering and defining data models based on profiling of legacy or existing applications.Experience designing database environmentsExperience in developing and enforcing data modeling standards and procedures.Experience with ITSM, Agile methodologies preferred.Strong interpersonal and communication skillsStrong consulting and customer relationship skillsProven work ethic with the utmost integritySelf-awareness, with a desire for constant self-improvement (goal-oriented)Personality traits for successful individuals may include self-motivated, passionate, empathetic, approachable, energeticBachelor's degree from an accredited institution or equivalent industry experienceIn 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 controlsFamiliar with InfoSec control levelsGeneral Requirements
Exhibit and practice courteous, ethical, and professional behavior while interacting with both internal and external customersInfluence/make technology decisions for the platform at enterprise levelAct in a collaborative, team-oriented environment focused on common goals to achieve mutually beneficial resultsBe accountable and responsible for the accuracy and completeness of assigned work and resultsPrioritize and manage workload and communicate issues clearlyExhibit effective verbal and written communication skillsComply with all laws, regulations, and company policiesTravel when required
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. However due to the urgency, will look at remote candidates.
Primary Duties and Responsibilities
Analyzing and translating business needs into long-term solution data modelsBusiness and technical requirement elicitation, analysis, and elaborationContinuously monitoring and improving the critical data models to better support the businessWorking with business services, software engineering, business to create business, logical and physical data modelsDeveloping and enforcing best practices for data modeling to ensure consistency within the systemEvaluating implemented data systems for variances, discrepancies, and efficiencyCreate/Author/Edit architecture documents, design documents, data flow diagramsLeverage and enforce standards for data naming conventions to ensure consistency and reuse of data modelsDesigning 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 discrepanciesCreate and maintain data models for NoSQL databases like cosmos DB, MongoDBCollaborating with Enterprise Architects in developing logical, physical data modelsWorking efficiently with various stakeholders and business units within the firm to understand data for ingestion and integration into a common data modelProviding direction to a Data Engineering team in building in developing, populating, and publishing data into an enterprise data modelAssisting end users in understanding the established data models and consuming data for their downstream application and useWorking with the platform team to optimize data mapping and data mastering functionsOrganize working sessions with business operations team to understand sources of data and expected outputComplete other tasks as requiredExperience, Education and Skills
10+ years of experience in Information Technology5+ years' experience in developing, validating, publishing, maintaining Business, Logical & Physical data models3+ years' experience creating and maintaining Enterprise or Corporate Data model5+years' experience designing application databases, Enterprise Data Warehouse, Data Hub, Delta Lake, Data Vault, Data Analytics Marts5+years' experience with 3NF, BPMN, data vault, dimensional modeling - star and snowflake5+years' experience with data modeling tools like Erwin, ER/Studio or Archi3+years' experience with data management activities data quality, master data management, data governance, metadata management2+years' experience in establishing data dictionaries, data models and documenting technical requirements2+ years of development or DBA experience in RDBMS systems5+ years strong SQL experience2+years' experience modeling Master/Reference data2+years' experience with SAP ECC and Salesforce data modelsExperience with data migration, data profiling and data mapping to targetExperience in reverse engineering and defining data models based on profiling of legacy or existing applications.Experience designing database environmentsExperience in developing and enforcing data modeling standards and procedures.Experience with ITSM, Agile methodologies preferred.Strong interpersonal and communication skillsStrong consulting and customer relationship skillsProven work ethic with the utmost integritySelf-awareness, with a desire for constant self-improvement (goal-oriented)Personality traits for successful individuals may include self-motivated, passionate, empathetic, approachable, energeticBachelor's degree from an accredited institution or equivalent industry experienceIn 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 controlsFamiliar with InfoSec control levelsGeneral Requirements
Exhibit and practice courteous, ethical, and professional behavior while interacting with both internal and external customersInfluence/make technology decisions for the platform at enterprise levelAct in a collaborative, team-oriented environment focused on common goals to achieve mutually beneficial resultsBe accountable and responsible for the accuracy and completeness of assigned work and resultsPrioritize and manage workload and communicate issues clearlyExhibit effective verbal and written communication skillsComply with all laws, regulations, and company policiesTravel when required