What are the responsibilities and job description for the Enterprise Data Modeler position at Dechen Consulting?
About Dechen Consulting Group (DCG)
Dechen Consulting Group (DCG) is a rapidly expanding, innovative IT Professional Services and Management Consulting company with a track record of more than twenty-five years in delivering skilled professionals to our clients across diverse sectors.
Opportunity Overview
We are currently seeking a Enterprise Data Modeler for a C2C opportunity in Richmond, VA. This role has the potential to extend over multiple years, with the chance to transition to a direct hire position with our client. We provide healthcare, vacation, relocation assistance, and visa sponsorship / transfer. This role offers excellent prospects for career progression!
Complete Description
Our Client is seeking a senior professional to develop Data models for Data Assets and implementation of a cloud-based data management platform that will support the agency. The role provides expert support across the enterprise information framework, analyzes and translates business needs into long-term solution data models by evaluating existing systems, and works with a business and data architect to create conceptual data models and data flows. The professional will develop best practices for Data Asset development, ensure consistency within the system and review modifications of existing cross-compatibility systems. They will optimize data systems and evaluate implemented systems for variance discrepancies and efficiency, maintaining logical and physical data models along with accurate metadata.
Responsibilities
- Create conceptual data models to identify key business entities and visualize their relationships, define concepts and rules.
- Translate business needs into data models, build logical and physical data models for client hierarchy, and document data designs for the team.
- Present and communicate modeling results and recommendations to internal stakeholders and development teams, explaining features that may affect the physical data model.
- Ensure and enforce a governance process to oversee implementation activities and ensure alignment to the defined architecture.
- Perform data profiling / analysis activities to establish, modify, and maintain data models.
- Develop canonical models, Data as a Service models, and have knowledge of SOA to support integrations.
- Analyze data-related system integration challenges and propose appropriate solutions with a strategic approach.
- Develop and support the usage of MDM toolkit, integrate source systems into the MDM solution, and implement business rules for data reconciliation and deduplication.
- Enforce data models and naming standards across deliverables.
- Establish processes for governing the identification, collection, and use of corporate metadata, ensuring metadata accuracy and validity.
- Establish methods and procedures for tracking data quality, completeness, data redundancy, and improvement.
- Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks.
- Create strategies and plans for data security, backup, disaster recovery, business continuity, and archiving.
- Ensure that data strategies and architectures are in regulatory compliance.
- Good knowledge of applicable data privacy practices and laws.
- Strong written and oral communication skills, strong presentation and interpersonal skills, and the ability to present ideas in user-friendly language.
- Experience in writing queries (SQL, Python, R, Scala) as needed and experience with various data technologies such as Azure Synapse or SQL Server, Snowflake, Databricks.
Interview and Work Arrangement
Agency Interview Type : Both Phone and In Person
Work Arrangement : Hybrid
We are a people-focused company with a deep emphasis on family values and look forward to working with you.
