Technical Lead - Data

Requirements:

• Expert-level knowledge in RDBMS (SQL Server) with clear understanding of SQL query writing, object creation and management, and performance and optimization of DB/DWH operations.
• Good understanding of transactional and dimensional data modelling, star schema, facts/dimensions, and relationships.
• 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/visualization tool (Power BI/Azure Analysis Services).
• Should have worked on at least 1 development lifecycle of one of the below:
• End-to-end ETL project (involving any ETL tool).
• End-to-end reporting project (involving a reporting tool, Power BI and Analysis Services preferred).
• Ability to write and review test cases, test code, and validate code.
• Ability to perform data analysis on different reports to troubleshoot 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.
• 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 the 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 the customer on the best way to execute projects.
• Should have a good understanding of project dynamics - scoping, setting estimates, setting timelines, and working around timelines in case of exceptions.
• 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 communication skills - written or verbal, especially to express technical ideas/solutions.

Skills

Azure Analysis Services, ETL, Power BI, SQL Server