Position Details
Data Modeler Apply
Must Have Technical/Functional Skills
ER Studio and Data Modeling expertise, Delivery of Data products leveraging Databricks on AWS, Strong Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both enterprise and data product level
Roles & Responsibilities
- Apply ER Studio and Data Modeling expertise to a Data Engineering team dedicated to the design and development, and delivery of Data products leveraging Databricks on AWS
- Work with Business Architects, Solution Architects, and Data Stewards to capture business requirements in a Conceptual and Logical Data Model.
- Contribute to ongoing updates to data modeling standards and guidelines
- Evaluate physical data models to ensure they align with the corresponding logical data models.
- Create notebooks in Databricks in support of development activities (using Spark SQL, PySpark)
- Support enterprise data catalog setup and enrichment
Skills Needed:
- Data management background with hands-on work experience in supporting teams that are building and testing data pipelines
- 4+ years of hands-on data modeling experience with ER Studio. Hands-on strong Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both enterprise and data product level.
Strong SQL skills
- Good Databricks skills and understanding of Medallion Architecture Working knowledge of Unity Catalog
- Experience in the financial sector with Market securities reference data and fixed income such as Treasuries.
- Working knowledge of traditional DBMS platforms like Oracle and Cloud DBMS like Redshift and Databricks.
- Strong verbal, presentation, and written communication skills
TCS Employee Benefits Summary:
- Discretionary Annual Incentive.
- Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
- Family Support: Maternal & Parental Leaves.
- Insurance Options: Auto & Home Insurance, Identity Theft Protection.
- Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
- Time Off: Vacation, Time Off, Sick Leave & Holidays.
- Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary Range: $120,000 - $140,000 a year
