Senior Data Modeler

Role overview

This permanent Senior Data Modeler position is based in Letterkenny, County Donegal, with a 2/3 hybrid working setup. The role sits within a global technology organisation that operates a major delivery centre in Donegal and offers opportunities to work on impactful projects for clients in the UK and worldwide.

The position is centered on shaping enterprise data structures that enable reporting, analytics, and day-to-day business operations. You will design and evolve conceptual, logical, and physical models, with a particular focus on relational and dimensional modelling in SQL Server environments. Experience with IDERA ER/Studio is preferred, though a comparable modelling tool is also acceptable.

What the role involves

You will convert complex business needs into robust, scalable data designs. The work includes building normalized and dimensional structures, supporting downstream uses such as data warehousing, reporting, and integrations, and maintaining the documentation required to keep data assets clear and governed.

You will also partner closely with business teams, architects, and ETL/integration colleagues to make sure the data design fits wider enterprise architecture and delivery objectives. The role includes support for DDL creation, database implementation, and performance tuning so that solutions remain reliable and efficient.

US hours coverage is required, with working time from 2pm to 10pm GMT.

Responsibilities

• Build conceptual, logical, and physical data models that reflect business needs.
• Develop relational and dimensional structures that support analytics, reporting, and data warehousing.
• Work with business stakeholders, architects, and ETL teams to turn requirements into scalable data designs.
• Produce and keep updated ER diagrams, data dictionaries, and metadata records.
• Make sure data models follow governance, quality, and standardisation principles.
• Support Microsoft SQL Server database design and optimisation.
• Assist with DDL generation and deployment for physical database delivery.
• Contribute to data architecture conversations and keep designs aligned with enterprise strategy.

Requirements

• Significant professional experience in data modelling.
• Solid knowledge of entity-relationship modelling.
• Hands-on capability with relational modelling, including 3NF.
• Strong understanding of dimensional modelling, including star and snowflake schemas.
• Practical experience across conceptual, logical, and physical modelling.
• Experience designing databases in Microsoft SQL Server.
• Ability to write and interpret SQL and DDL scripts.
• Experience using a data modelling tool, ideally IDERA ER/Studio.
• Familiarity with data warehousing concepts such as SCD, CDC, and ETL integration.
• Exposure to BI tools such as Power BI or Tableau is an advantage.
• Understanding of data governance and metadata management.
• Experience in the BFSI domain is a plus.

Perks and benefits

• Competitive compensation package.
• Pension contribution.
• Health care coverage.
• Life assurance.
• Laptop provided.
• Access to extensive learning and training resources.
• Discounts available through the wider Tata network.
• Health and wellness initiatives.
• Sports events and community involvement opportunities.

Inclusion, accessibility, and application support

The employer is committed to an inclusive hiring process and complies with Irish equality and status legislation. Candidates from all backgrounds are encouraged to apply, including people with disabilities, long-term conditions, neurodiversity, and candidates across all gender identities, ages, nationalities, ethnicities, sexual orientations, and physical abilities.

Applicants with disabilities or long-term conditions who meet the minimum criteria may receive an interview as part of the disability-inclusive hiring approach. If you need support with completing the application or require a different format of the document, contact UKI.recruitment@tcs.com with the subject line “Application Support Request”. For adjustments to the process or interview, contact UKI.recruitment@tcs.com with the subject line “Adjustment Request” or email jennifer.long@tcs.com.

Additional information

This employer does not request any payment or security deposit from candidates at any stage of recruitment. Job offers are not issued from free email services such as Gmail or Yahoo Mail, and no third party is authorised to collect money on its behalf. Any suspected fraudulent activity can be reported to UKI.recruitment@tcs.com.

Due to the volume of applications, individual status updates may not be provided. If there is no direct response within 30 days, the application should be treated as unsuccessful on this occasion.

The role is a permanent position and is offered as onsite/hybrid work in Letterkenny with the stated US-hours coverage requirement.

Employer overview

This organisation is a purpose-led technology company that supports clients in creating meaningful business and community impact through innovation and transformation. The Donegal location is positioned as part of a global delivery network with a strong culture of learning, collaboration, and respect.