Senior Data Modeler – Data Engineer - Central Point Partners

Senior Data Modeler / Data Engineer:

Must be US Citizen or GC holder

Location: Hybrid in Columbus, OH is preferred / Also open to applicants in Dallas, TX or Broken Arrow, OK (hybrid).  May be open to fully remote for stellar candidate.

Overview

As a data modeler, you will have a key role and autonomy to lead the data modeling domain. You 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 their skills and learning new ones.

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 models
• 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

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, and 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, 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

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 the 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