Technical Analyst - SQL

Description : Skill set :

Extensive Data and Analytics experience in the following :

• Data visualization tools (e.g. Tableau, Power BI)
• Data Platforms like Data Bricks, Snow Flakes
• Understanding of Cloud Platform / AWS / Kafka etc.
• Experience in designing & building Data Models / Data Warehouse & Marts
• Hands on experience in writing complex stored procedure, Functions & Triggers using Structured Query language (T-SQL)
• Hands on experience in performance tuning slow running SQL queries.
• Data modelling tools (e.g. SQL Developer, Python , Database Workbench, ER / Studio)
• Strong analytical skills and logical thinking to manage issues in a high-pressure :
• Investigation and analysis of data issues related to quality, lineage, controls, and authoritative source identification.
• Execution of data cleansing and transformation tasks to prepare data for analysis.
• Designing and building data pipelines to automate data movement and processing.
• Development and application of advanced analytical techniques, including machine learning and AI, to solve complex business problems.
• Documentation of data quality findings and recommendations for improvement.
• Strong Experience in Artificial Intelligence (AI) / Machine Learning (ML) algorithms.
• Strong Experience in Alation / Snowflake / Starbursts / DBT / Airflow etc.
• Experience architecting and designing front office mission critical, data intensive business applications.

Some other highly valued skills include :

Domain Experience :

(ref : hirist.tech)