Data Modeler with Data Vault Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Tata Consultancy Services · 2 weeks ago

Data Modeler with Data Vault Engineer

Tata Consultancy Services is a global leader in IT services, consulting, and business solutions. They are seeking a Data Modeler with Data Vault Engineer who will be responsible for data modeling and analysis, utilizing cloud data warehouses and modern ELT approaches to enhance data processes.

Business Information SystemsConsultingInformation TechnologyIT Management
check
H1B Sponsor Likelynote

Responsibilities

Should have strong understanding of cloud Datawarehouse like SnowFlake and Data modelling skill using Data Vault 2.0
Should have knowledge of SSIS ETL packages and need to analyze existing business logic and convert them into modern ELT approach
Should have in depth understanding or executed new concepts like Data Lakehouse and should have worked on Big Data data sources / tools such as Hive , S3 , Trino , HUE , etc
Should have done complex (100+ entities/tables) Data Modeling programs in both on-prem and cloud environments
Experience in designing normalized, denormalized, relational, dimensional, star and snowflake schemas for cloud, big data and on prem databases using any one of these data modeling tools (Erwin, ER/Studio, Toad Data Modeler, etc)

Qualification

Data ModelingData Vault 2.0Cloud Data WarehouseBig Data ToolsSSIS ETLData LakehouseData WarehousingData GovernanceFinancial Domain KnowledgeCommunication SkillsLeadership Skills

Required

5 + years of experience in Data Modeling & Data Analyst and should have excellent communication and leadership skills
Financial Domain knowledge is plus
Strong understanding of cloud Datawarehouse like SnowFlake and Data modelling skill using Data Vault 2.0
Knowledge of SSIS ETL packages and need to analyze existing business logic and convert them into modern ELT approach
In depth understanding or executed new concepts like Data Lakehouse and should have worked on Big Data data sources/tools such as Hive, S3, Trino, HUE, etc
Done complex (100+ entities/tables) Data Modeling programs in both on-prem and cloud environments
Experience in designing normalized, denormalized, relational, dimensional, star and snowflake schemas for cloud, big data and on prem databases using any one of these data modeling tools (Erwin, ER/Studio, Toad Data Modeler, etc)
Extensive Data Modeling experience in same or similar bigdata and cloud databases such as Hive, Redshift, Snowflake and on prem databases such as Oracle, SQL Server and DB2
Experience in working with product managers, project managers, business users, applications development team members, DBA teams and Data Governance team on a daily basis to analyze requirements, design, development and deployment technical solutions
Implemented Bill Inmon and Ralph Kimball methodologies to design data warehouses
In depth understanding on Data Warehousing, Data Analysis, Data Profiling, Master Data Management (MDM), Data Quality, Data Lineage, Data Dictionary, Data Mapping, Data Policy, and Data Governance
Need to have at least 2 hours overlap with Pacific Timings to interact with Onsite team and to attend daily standup meetings
BACHELOR OF COMPUTER SCIENCE

Company

Tata Consultancy Services

company-logo
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.

H1B Sponsorship

Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)

Funding

Current Stage
Public Company
Total Funding
unknown
2004-08-25IPO

Leadership Team

leader-logo
K. Krithivasan
Chief Executive Officer & Managing Director
linkedin
leader-logo
Aarthi Subramanian
President and Chief Operating Officer
Company data provided by crunchbase