Data Analyst

Skill: Data Analyst

• Strong in SQL and Data warehouse concepts Hands on experience working in a datawarehouse environment.
• Write complex SQLs to analyze/profile datasets and identify patterns.
• Recommend solutions based on data analysis.
• Demonstrate strong analytical and problem solving skills and be quick to identify design related concerns.
  
  

• Minimum 8+ years of experience as Data Analyst in Capital Markets domain.
• Proficient with SQL with experience in creating and updating custom queries.
• Good experience in MS Office tools (Word, ppt, excel, access etc..).
• Experience in Python would be an added advantage.
• Must have hands on experience in gathering data requirements and documenting data specification as well as data mapping documents.
• Good oral and written communication skills.
• Experience in Azure Tech stack (Azure Databricks, Azure Synapse, Azure Boards, ADLS etc...) would be an added advantage.
  
  

• Provide Data Requirements.
• Collaborate with Subject Matter experts and Business partners in gathering data requirements.
• Work independently and demonstrate strong understanding of existing Data model and ETL processes.
• Experience providing data flow diagram, table structure and ETL specifications including transformation rules required for source to target mapping.
• Identify ETL dependencies and help orchestrate a sequence of data loads in the ETL pipeline.
• Demonstrate good communication and presentation skills with the ability to articulate data requirements, design concerns, etc.
• Demonstrate strong negotiation skills while working with developers, architects to solution the data needs.
• Validate the accuracy, integrity and quality of Data developed.
• Support defects triage.
• Participate in the SIT, UAT defects triage and help set up a defect resolution path.
• Assess defects on their impacts and help set up priorities.
• Guide the production support team on unforeseen issues, ETL abends.