Enter a job title or keyword
Senior Data Modeler (IDERA ERStudio) (170626)
Job Location:
Job Location:
Letterkenny - Ireland
Monthly Salary:
Not provided by the employer
Monthly Salary:
Posted:
19 June 2026 (30+ days ago)
Posted:
Application Deadline:
16 September 2026
Application Deadline:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
If you need support in completing the application or if you require a different format of this document please get in touch with at with the subject line: Application Support Request.
Role: Senior Data Modeler (IDERA ER/Studio)
Job Type: Permanent
Location: Letterkenny (2/3 Hybrid working model)
Join a global tech leader right here in Donegal. With over 850 employees and a state-of-the-art global delivery centre were proud to offer world-class career opportunities without having to leave the Northwest. Recognised as Workplace of the Year by the Letterkenny Chamber we foster a culture of continuous learning innovation and respect. Our people are at the heart of everything we do collaborating across teams geographies and disciplines to drive real change for clients around the world. Be part of something global grounded in Donegal.
Careers at TCS: It means more
TCS is a purpose-led transformation company built on belief. We do not just help businesses to transform through technology. We support them in making a meaningful difference to the people and communities they serve - our clients include some of the biggest brands in the UK and worldwide. For you it means more to make an impact that matters through challenging projects which demand ambitious innovation and thought leadership.
The Role
The Data Modeler plays a key role in designing and structuring enterprise data to support reporting analytics and business operations. This role focuses on developing conceptual logical and physical data models aligned to business requirements with a strong emphasis on relational and dimensional modeling within SQL Server environments using data modelling tools such as IDERA ER/Studio (preferred) or equivalent.
The Data Modeler is responsible for translating complex business needs into scalable efficient data structures. This includes working with ER modeling techniques designing normalized and dimensional schemas and ensuring the data models support downstream use cases such as data warehousing reporting and integrations.
The role involves creating and maintaining data models ER diagrams data dictionaries and metadata documentation while ensuring adherence to data governance standards quality frameworks and best practices. A strong focus is placed on data consistency standardization and performance optimization in database design.
This position requires close collaboration with cross-functional teams including business stakeholders architects and ETL or integration teams to ensure that data models align with enterprise architecture and delivery needs. The Data Modeler is also expected to support DDL generation database implementation and performance tuning ensuring reliable and scalable data solutions.
Please note US hours coverage required (2pm 10pm GMT)
Your responsibilities:
Essential skills/knowledge/experience:
TCS is consistently voted a Top Employer in the UK and globally. Our competitive salary packages feature pension health care life assurance laptop and access to extensive training resources and discounts within the larger Tata network.
We offer health & wellness initiatives and sports events; we are the proud sponsor of the London Marathon and partner with our local communities in Ireland.
Diversity Inclusion and Wellbeing
Tata Consultancy Services UK&I is committed to meeting the accessibility needs of all individuals in accordance with the Ireland Employment Equality Acts 1998-2011 (as amended) and the Equal Status Acts 2000-2012 (as amended).
We welcome and embrace diversity in race nationality ethnicity disability neurodiversity gender identity age physical ability gender reassignment sexual orientation. We are a disability inclusive employer and encourage disabled people to apply for this role.
As a Disability Confident Employer we offer an interview to applicants with disabilities or long-term conditions who meet the minimum criteria for the role. Please email us at if you would like to opt in.
If you are an applicant who needs any adjustments to the application process or interview please contact us with the subject line: Adjustment Request or email to request an adjustment. We welcome requests prior to you completing the application and at any stage of the recruitment process.
Beware of Fraudulent offers
This is to notify you that TCS does not ask for any sort of payment or security deposit from candidates at any stage of the recruitment process. The firm never sends out job offers from free internet email services like Gmail Yahoo Mail and so on. TCS has not authorised any third-party company to collect money on their behalf. As a vigilant job seeker beware of fraudulent recruitment activity and protect your interests! You can write to to report any fraudulent activity.
Due to the high volume of applications we will be unable to contact each applicant individually on the status of their application. If you have not received a direct response within 30 days then it should be deemed unsuccessful on this occasion.
Join us and do more of what matters. Apply online now.
Role: Senior Data Modeler (IDERA ER/Studio)
Job Type: Permanent
Location: Letterkenny (2/3 Hybrid working model)
Join a global tech leader right here in Donegal. With over 850 employees and a state-of-the-art global delivery centre were proud to offer world-class career opportunities without having to leave the Northwest. Recognised as Workplace of the Year by the Letterkenny Chamber we foster a culture of continuous learning innovation and respect. Our people are at the heart of everything we do collaborating across teams geographies and disciplines to drive real change for clients around the world. Be part of something global grounded in Donegal.
Careers at TCS: It means more
TCS is a purpose-led transformation company built on belief. We do not just help businesses to transform through technology. We support them in making a meaningful difference to the people and communities they serve - our clients include some of the biggest brands in the UK and worldwide. For you it means more to make an impact that matters through challenging projects which demand ambitious innovation and thought leadership.
The Role
The Data Modeler plays a key role in designing and structuring enterprise data to support reporting analytics and business operations. This role focuses on developing conceptual logical and physical data models aligned to business requirements with a strong emphasis on relational and dimensional modeling within SQL Server environments using data modelling tools such as IDERA ER/Studio (preferred) or equivalent.
The Data Modeler is responsible for translating complex business needs into scalable efficient data structures. This includes working with ER modeling techniques designing normalized and dimensional schemas and ensuring the data models support downstream use cases such as data warehousing reporting and integrations.
The role involves creating and maintaining data models ER diagrams data dictionaries and metadata documentation while ensuring adherence to data governance standards quality frameworks and best practices. A strong focus is placed on data consistency standardization and performance optimization in database design.
This position requires close collaboration with cross-functional teams including business stakeholders architects and ETL or integration teams to ensure that data models align with enterprise architecture and delivery needs. The Data Modeler is also expected to support DDL generation database implementation and performance tuning ensuring reliable and scalable data solutions.
Please note US hours coverage required (2pm 10pm GMT)
Your responsibilities:
- Design and develop conceptual logical and physical data models aligned with business requirements
- Implement relational and dimensional data models supporting reporting analytics and data warehousing
- Collaborate with business stakeholders architects and ETL teams to translate requirements into scalable data structures
- Create and maintain ER diagrams data dictionaries and metadata documentation
- Ensure data models adhere to data governance quality and standardization frameworks
- Support database design and performance optimization within Microsoft SQL Server environments
- Assist in DDL generation and deployment for physical database implementation
- Participate in data architecture discussions and ensure alignment with enterprise data strategy.
Essential skills/knowledge/experience:
- Extensive experience in data modeling
- Strong expertise in:
- Entity-Relationship Modeling (ER Modeling)
- Relational Data Modeling (3NF)
- Dimensional Modeling (Star/Snowflake schemas)
- Conceptual Logical and Physical Data Modeling
- Hands-on experience in:
- Microsoft SQL Server database design
- Writing and understanding SQL / DDL scripts
- Experience with data modeling tools:
- IDERA ER/Studio (Preferred)
- Experience with Data Warehousing concepts (SCD CDC ETL integration)
- Exposure to BI tools (Power BI Tableau etc.)
- Understanding of data governance and metadata management
- Experience working in BFSI domain (nice to have)
TCS is consistently voted a Top Employer in the UK and globally. Our competitive salary packages feature pension health care life assurance laptop and access to extensive training resources and discounts within the larger Tata network.
We offer health & wellness initiatives and sports events; we are the proud sponsor of the London Marathon and partner with our local communities in Ireland.
Diversity Inclusion and Wellbeing
Tata Consultancy Services UK&I is committed to meeting the accessibility needs of all individuals in accordance with the Ireland Employment Equality Acts 1998-2011 (as amended) and the Equal Status Acts 2000-2012 (as amended).
We welcome and embrace diversity in race nationality ethnicity disability neurodiversity gender identity age physical ability gender reassignment sexual orientation. We are a disability inclusive employer and encourage disabled people to apply for this role.
As a Disability Confident Employer we offer an interview to applicants with disabilities or long-term conditions who meet the minimum criteria for the role. Please email us at if you would like to opt in.
If you are an applicant who needs any adjustments to the application process or interview please contact us with the subject line: Adjustment Request or email to request an adjustment. We welcome requests prior to you completing the application and at any stage of the recruitment process.
Beware of Fraudulent offers
This is to notify you that TCS does not ask for any sort of payment or security deposit from candidates at any stage of the recruitment process. The firm never sends out job offers from free internet email services like Gmail Yahoo Mail and so on. TCS has not authorised any third-party company to collect money on their behalf. As a vigilant job seeker beware of fraudulent recruitment activity and protect your interests! You can write to to report any fraudulent activity.
Due to the high volume of applications we will be unable to contact each applicant individually on the status of their application. If you have not received a direct response within 30 days then it should be deemed unsuccessful on this occasion.
Join us and do more of what matters. Apply online now.
Required Experience:
Senior IC
About Company
We strongly believe global challenges need global solutions. We are continually engaging with our employees, clients, partners, public institutions, and community organisations across the world to step up and rise to the occasion. We are #OneTCS. A part of the Tata group, India's lar ... View more
