Lead Data modeler- 13+years Profile

Visionary Innovative Technology Solutions LLC; Mount Laurel Township (NJ); Hybrid; USD 120,000 - 170,000; Full time

Job summary

Visionary Innovative Technology Solutions LLC is seeking a Sr. Data Modeler to design and implement scalable data models, leveraging Data Vault techniques and Azure data services.

The role requires strong collaboration with data engineers, scientists, and analysts to ensure model alignment with business needs. The ideal candidate has 15+ years in data modeling, hands-on experience with Azure Data Services, and familiarity with Databricks.

Qualifications

• 15+ years of data modeling experience.
• Experience with Data Vault techniques and enterprise data architecture.
• Cloud Azure experience; Databricks knowledge is a plus.

Responsibilities

• Design and develop scalable data models (conceptual, logical, physical).
• Collaborate with stakeholders to capture data requirements and translate them into models.
• Implement best practices for data modeling, normalization/denormalization, and data integration.
• Design and deploy data models on Azure Data Services, ensuring security and compliance.

Skills

Data modelling

Data Vault concepts

Azure cloud

Tools

Power Designer

ERWin

ER/Studio

Azure Data Services

Azure SQL Database

Azure Data Lake

Azure Synapse Analytics

Job description

Mode of work: Onsite/Hybrid (3 days/per week)

Duration: Full Time/Contract

Total Experience: 15+ Years

Primary Skills: Data Modeler

Secondary Skills: Banking domain, Power Designer/ERWin/ER/Studio, Cloud Azure

Job Description: We are seeking a skilled Sr. Data Modeler to join our team and contribute to the design and implementation of scalable and efficient data models. The ideal candidate will have experience with Data Modeling techniques, proficiency in Cloud Azure, and good to have working knowledge with Databricks.

Responsibilities:

Data Modeling:

• Design and develop data models to ensure robust, scalable, and flexible data architectures.
• Create and maintain conceptual, logical, and physical data models to support business requirements.
• Collaborate with stakeholders to understand data requirements and translate them into effective data models.
• Implement best practices for data modeling, including normalization, denormalization, and data integration.

Data Vault Implementation:

• Utilize Data Vault techniques to build enterprise data lake and lake house and integrate disparate data sources.
• Design and implement Hubs, Links, and Satellites to ensure comprehensive data capture and historical tracking.
• Optimize data vault models for performance and scalability.
• Cloud Azure: Good to have(Secondary)
• Design and deploy data models on Azure Data Services, including Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics.
• Ensure data security, compliance, and best practices in Azure environments.
• Collaboration and Communication:
• Work closely with data engineers, data scientists, and business analysts to understand data needs and ensure data model alignment.
• Document data models, data flows, and integration processes clearly and comprehensively.
• Data Modelling tools Azure:
• Data analysis and modeling tools (e.g. Power Designer, ERWin, ER/Studio)