Data Modeler Data Vault Engineer

Job Title

Data Modeler with Data Vault Engineer

Tata Consultancy Services

Full‑time, Mid‑Senior level position located in Las Vegas, NV.

• Design and develop data models using Data Vault 2.0, supporting both on‑prem and cloud environments.
• Collaborate with product managers, project managers, business users, development teams, DBAs, and Data Governance teams to analyze requirements and design technical solutions.
• Analyze existing business logic and convert it into modern ELT workflows using SSIS ETL packages.
• Implement star and snowflake schemas using tools such as Erwin, ER/Studio, or Toad Data Modeler.
• Execute complex data modeling programs, often involving more than 100 entities or tables.
• Apply Inmon and Kimball methodologies to design data warehouses.
• Conduct data profiling, master data management, data quality checks, lineage mapping, and maintain data dictionaries and policies.
• Maintain at least a two‑hour overlap with Pacific Time to participate in daily stand‑up meetings and coordinate with the onsite team.

• 5+ years of experience in data modeling and data analysis.
• Strong knowledge of cloud data warehouses such as Snowflake and big‑data technologies (Hive, Redshift, etc.).
• Proficiency with SSIS ETL packages and modern ELT approaches.
• Experience with Data Lakehouse concepts and relevant tools (Hive, S3, Trino, HUE, etc.).
• Expertise in designing normalized, denormalized, relational, dimensional, star, and snowflake schemas.
• Knowledge of financial domain (preferred).
• Excellent communication and leadership skills.

Salary Range: $100,000 – $130,000 per year.

Las Vegas, NV. Remote flexibility may be available.