Data Integration Lead

Sage IT Inc
NJ, United States
Full-time
Quick Apply

Job Description

Primary Skill : Data modeler,Cloud Azure,Data Vault

Secondary Skill : Banking domain,Power Designer / ERWin / ER / Studio

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 Vault techniques, proficiency in Cloud Azure, and good to have working knowledge with Databricks.

Responsibilities : Data Modeling :

Data Modeling :

oDesign and develop data models using Data Vault methodologies to ensure robust, scalable, and flexible data architectures.

oCreate and maintain conceptual, logical, and physical data models to support business requirements.

oCollaborate with stakeholders to understand data requirements and translate them into effective data models.

oImplement best practices for data modeling, including normalization, denormalization, and data integration.

Data Vault Implementation :

oUtilize Data Vault techniques to build enterprise data lake and lake house and integrate disparate data sources.

oDesign and implement Hubs, Links, and Satellites to ensure comprehensive data capture and historical tracking.

oOptimize data vault models for performance and scalability.

Cloud Azure :

oDesign and deploy data models on Azure Data Services, including Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics.

oEnsure data security, compliance, and best practices in Azure environments.

Collaboration and Communication :

oWork closely with data engineers, data scientists, and business analysts to understand data needs and ensure data model alignment.

oProvide technical guidance and support on data modeling best practices and Data Vault principles.

oDocument 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)

Requirements :

Bachelor's degree in Computer Science, Information Systems, or a related field (Master's degree preferred).

Proven experience in data modeling, with a strong focus on Data Vault techniques.

Proficiency in Cloud Azure services, including Azure Data Lake, Azure SQL Database, and Azure Synapse Analytics.

Understand / Knowledge with Databricks and its ecosystem.

Strong understanding of data warehousing concepts, Data Lake house, ETL processes, and data integration techniques.

Excellent analytical and problem-solving skills with attention to detail.

Strong communication and collaboration skills to work effectively with cross-functional teams.

Relevant certifications in Azure and Databricks are a plus.

Preferred Qualifications :

Experience with additional cloud platforms (e.g., AWS, Google Cloud) is a plus.

Knowledge of data governance and data quality principles.

Experience with BI tools such as Power BI, Tableau, or Looker.

Contacts

PrintMe

OKCancel

1 day ago
Related jobs
AIT Global
Jersey City, New Jersey

Job Title: CIB - Data Integration Lead (Python + AWS - Lead). Leads communities of practice across Software Engineering to drive awareness and use of new and leading-edge technologies. Leads evaluation sessions with external vendors, startups, and internal teams to drive outcomes-oriented probing of...

Sage IT Inc
NJ, United States

Responsibilities:</div> <div> Data Modeling:</div> <div>oDesign and develop data models using Data Vault methodologies to ensure robust, scalable, and flexible data architectures. Data Vault Implementation:</div> <div>oUtilize Data Vault techniques to build ente...

Promoted
Cognizant Technology Solutions
Newark, New Jersey

Cognizant Technology Solutions is looking for. Lead the design and development of high-quality software solutions using Java and Spring Framework. Collaborate with cross-functional teams to gather requirements and deliver solutions. ...

Promoted
VirtualVocations
Hamilton Township, New Jersey

A company is looking for a Senior Software Engineer - Data and Automations to lead a project focused on building and optimizing automations for web-based job post data extraction and cleaning. ...

Promoted
TechData Service Company LLC
Summit, New Jersey

We are looking for a data scientist with solid Tableau skill at USA( Tableau Prep and. ...

Promoted
TMS
Warren, New Jersey

Role: Data Solutions Architect- Insurance. Provide insights and expertise specific to the Insurance domain to enhance data solutions. ...

Promoted
Saransh Inc
New Brunswick, New Jersey

They work on enabling data lineage, quality checks, and governance automation by integrating Collibra with platforms such as Databricks for big data processing and advanced analytics, while ensuring compatibility with enterprise-wide data solutions. Consultant must have technical expertise in metada...

Promoted
Axelon Services Corporation
New Brunswick, New Jersey

Serve as project manager and /or participate, as needed, in any initiatives that are identified in PD/PDO annual. Reporting to the Director of Product Development Operations, this individual will be responsible for the planning and execution of a broad range of project management activities to suppo...

Promoted
Deloitte
Princeton, New Jersey

Business Analyst in IT or related fields, with a proven track record of gathering and documenting business requirements. Decisions made based on highly complex business system impact analysis and involve business process or data flow recommendations and may impact firm systems. Our Core Technology O...

Promoted
ADP (Automatic Data Processing)
Parsippany-Troy Hills, New Jersey

The Senior Business Systems Analyst / Data Analyst role combines deep data analysis, communications, and reporting. With a passion to work at the intersection of data, business, and technology and to drive innovative data protection and remediation solutions, the successful candidate must be ambitio...