Top Competencies:
5+ years’ experience
Strong written, verbal, and graphical communications skills with the ability to
express complex technical concepts effectively
Research, relate and recommend technical solutions and relevant software
application tools, utilities, environments and languages.
Proactively take up additional responsibilities as required by management
Take full ownership of assigned tasks and show commitment to deliver on time
Advanced troubleshooting and multi-tasking skills
Excellent time management skills
Ability to work under pressure in a diverse and dynamic environment
Key Technical Competencies:
Excellent T-SQL and MSBI coding skills using advanced techniques
Experience working with very large databases and/or data warehousing.
Understanding of SDLC, development methodologies, and version control.
Experience with 'Fuzzy' matching techniques.
Adhere to standards and best practices for all databases, e.g., Data models, Data
architecture, Naming conventions
Proficiency in SQL Server, with good understanding of database design and
development
Extensive experience on MS BI stack(SSAS,SSIS,SSRS) using SQL Server 2014 to
integrate with other SQL Servers, flat files, and other data sources.
Strong understanding of DW concepts / methodologies and data modelling, and
cube design
Power BI
Good to have the following:
Knowledge of modern data warehouse design and architecture
Knowledge of cloud technologies (preferably Azure)
Google productivity suite
Security practices in coding
GIT
Jira and Confluence
Financial services industry experience
Cloud Data Solution(Azure DataLake,Azure Data Factory and Azure Synapse)