Tata Consultancy Services ยท 12 hours ago
Data Modeler
United States
Full-time
Remote
Senior Level
$100K/yr - $120K/yr
7+ years exp
Maximize your interview chancesBusiness Information SystemsConsulting
Insider Connection @Tata Consultancy Services
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Design and develop data models for large-scale databases on the Azure platform, ensuring scalability, performance, and data integrity.
Collaborate with stakeholders, including data architects, developers, and business analysts, to understand data requirements and translate them into effective data models.
Optimize database structures and schemas to improve query performance and data retrieval efficiency.
Implement best practices for data modeling, including normalization, denormalization, indexing, and partitioning strategies.
Conduct data profiling and analysis to identify data quality issues and propose solutions for data cleansing and enrichment.
Work closely with the development team to ensure seamless integration of data models into application systems.
Perform data modeling reviews and provide guidance to ensure adherence to industry standards and best practices.
Stay up-to-date with the latest trends and advancements in data modeling techniques, tools, and technologies.
Collaborate with database administrators to monitor and optimize database performance, including query tuning and indexing strategies.
Document data models, data dictionaries, and related artifacts to facilitate knowledge sharing and maintain data lineage.
Monitor system performance by performing regular tests, troubleshooting, and integrating new features.
Guide and coach staff members on standards, guidelines, best practices, and adherence to set standards.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
In-depth understanding of multi-dimensional and canonical design.
5+ years of data modeling experience utilizing the Power Designer tool.
7+ years of experience in architecting and building medium to large scale enterprise data warehouses and data marts.
Strong experience with Microsoft SQL Server, Azure Data Warehouse, and Snowflake.
Proven experience implementing data warehouse architecture standards, processes, and methodologies.
Strong knowledge of data modeling concepts, techniques, and best practices.
Proficiency in SQL and experience with database management systems (DBMS) such as Azure SQL Database, Azure Synapse Analytics, or Azure Cosmos DB.
Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks.
Familiarity with data integration and ETL processes, including data ingestion, transformation, and loading.
Experience with data profiling and data quality assessment tools.
Strong analytical and problem-solving skills, with the ability to analyze complex data requirements and translate them into effective data models.
Excellent communication and collaboration skills, with the ability to work effectively in cross-functional teams.
Able to hit the ground running with a can-do attitude.
Preferred
Azure certifications in data-related domains (e.g., Azure Data Engineer, Azure Database Administrator)
Company
Tata Consultancy Services
Tata Consultancy Services is a multinational information technology services, business solutions, and consulting company based in India.
10001+ employees
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
2023 (6766)
2022 (10550)
2021 (11696)
2020 (10701)
Funding
Current Stage
Public CompanyTotal Funding
unknown2004-08-25IPO
Leadership Team
K. Krithivasan
Chief Executive Officer & Managing Director
Ananth Krishnan
Chief Technology Officer
Recent News
2024-12-17
2024-12-13
Business, Technology, Startups and Science News and Trends in India | IndianWeb2.com
2024-12-12
Company data provided by crunchbase
