What are the responsibilities and job description for the Senior Data Modeler - Data Engineer position at 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

Apply for this job

Receive alerts for other Senior Data Modeler - Data Engineer job openings

Senior Data Modeler - Data Engineer

What are the responsibilities and job description for the Senior Data Modeler - Data Engineer position at Central Point Partners?

What is the career path for a Senior Data Modeler - Data Engineer?

Job openings at Central Point Partners

Not the job you're looking for? Here are some other Senior Data Modeler - Data Engineer jobs in the Columbus, OH area that may be a better fit.

We don't have any other Senior Data Modeler - Data Engineer jobs in the Columbus, OH area right now.

AI Assistant is available now!