Job Title: Enterprise Data Modeler
Location: Remote
Duration: 12+ months
Contract: W2
Experience Level: 3+ years
Responsibilities:
Create conceptual data models to identify key business entities and visualize their relationships, defining concepts and rules.
Translate business needs into data models; build logical and physical data models for client hierarchy; 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 support integrations with knowledge of SOA.
Analyze data-related system integration challenges and propose appropriate solutions with a strategic approach.
Perform data profiling and analysis to maintain data models; develop and support the usage of the MDM toolkit; integrate source systems into the MDM solution.
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; ensure 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 data strategies and architectures comply with regulations.
Write queries (SQL, Python, R, Scala) as needed; experience with various data technologies such as Azure Synapse, SQL Server, Snowflake, and Databricks.