Back to search

Technical Lead- Data

The Technical Lead- Data is responsible for leading a team of developers and testers, managing DB/DWH operations, and interfacing directly with customers to translate requirements into technical models.

  • Chennai, Tamil Nadu, India
  • Full-time
  • Posted Oct 29, 2026
INDUSTRYSoftware & InternetIT Support & Networking

Responsibilities

  • Expert-level knowledge in RDBMS (SQL Server) including SQL query writing, object creation, management, and performance optimization of DB/DWH operations.
  • Understand Transactional and Dimensional Data Modelling, Star Schema, Facts/Dimensions, and Relationships.
  • Implement ETL concepts using tools like SSIS/ADF or similar services.
  • Write and review test cases, test code, and validate code.
  • Perform data analysis on reports to troubleshoot missing data, suggest value-added metrics, and consult on best practices.
  • Follow SDLC practices including source control, version management, Azure DevOps, and CI/CD practices.
  • Interface with customers daily to understand context and use-case.
  • Convert functional requirements into tangible processes, models, and documentation.
  • Provide consultative options to customers on project execution.
  • Technically lead a team of developers and testers, performing design and code reviews.
  • Communicate technical ideas and solutions effectively written and verbally.

Requirements

  • Experience in a Data Warehousing
  • Experience in a Business Intelligence

Skills

SQL ServerRDBMSData ModellingETLSSISADFPower BIAzure Analysis ServicesAzure DevOpsCI/CDSQL ServerSSISADFPower BIAzure Analysis ServicesAzure DevOps

Benefits

  • Accelerated career tracks
  • Learning opportunities
  • Exposure to global clients

Full description

 Expert-level knowledge in RDBMS (SQL Server) with clear understanding of SQL query writing, object creation and management and performance and optimisation of DB/DWH operations.  Good understanding of Transactional and Dimensional Data Modelling, Star Schema, Facts/Dimensions, Relationship.  Good understanding of ETL concepts and exposure to at least one ETL service providing tool. (SSIS/ADF/Similar)  Expert-level knowledge in at least one MS reporting/visualisation tool (Power BI/Azure Analysis Services)  Should have worked on at least 1 development lifecycle of one of the below: o End-to-end ETL project (Involving any ETL tool) o End-to-end reporting project (Involving a reporting too, Power BI & Analysis Services preferred)  Ability to write and review test cases, test code and validate code.  Ability to perform data analysis on different reports to come up with troubleshooting of missing data, suggest value added metrics and consult on best practices to the customer.  Good understanding of SDLC practices like source control, version management, usage of Azure DevOps and CI/CD practices. Requirements Should have the skill to fully understand the context and use-case of a project and have a personal vision for it – Play the role of interfacing with customer directly on a daily basis.  Should be able to converse with functional users and convert requirements into tangible processes/models and documentation in available templates.  Should be able to provide consultative options to customer on best way to execute projects  Should have a good understanding of project dynamics – scoping, setting estimates, setting timelines, working around timelines in case of exceptions, etc.  Should be able to demonstrate the ability to technically lead a team of developers and testers and perform design reviews, code reviews, etc.  Should have a good understanding of presentation and communications skills – written or verbal, specially to express technical ideas / solutions. Benefits   • At Psiog, we believe people grow when opportunities do. You’ll be part of an ecosystem that encourages curiosity, innovation, and ownership.       • Work with global clients, and enterprise environments, enabling exposure beyond conventional delivery models.       • Accelerated career tracks with a faster roadmap to leadership for those who demonstrate capability and initiative.       • Opportunity to explore diverse technologies, projects, learning opportunities and domains, allowing you to shape your own growth path.       • An organization that celebrates passion alongside profession, encouraging creativity, art, and individuality.

Technical Lead- Data at psiog | Referso Jobs