Associate Data Analyst

Required Skills :

- Solid hands-on experience in various databases, data mining and data analysis methods, utilizing advanced data tools, writing complex SQL queries.

- Data preparation, data analysis, identify insights from raw data.

- Analyses metrics, key indicators and other available data sources to discover root causes of process defects.

- Experience in articulating and translating business questions using statistical techniques.

- Good working exposure of the SQL, PL/SQL, OLTP/OLAP Databases, data analytics tools and techniques.

- Should have strong experience in SQL complex Query building.

- Should have good understanding of stored procedures, joins, CTE, temp table, sub query, functions, index, SQL profiler and performance tuning.

- Provide support on Database backup, shrink DB & Stats.

- Provide support, guidance, and collaborate with Application Developers to implement database design & solutions.

- Good hands-on working on AWS cloud services and AWS RDS.

- Exposure to financial modeling and operations analysis is a plus.

- Good understanding of data warehousing concepts.

- Good understanding of dimension/data modeling.

- Knowledge of Snowflake will be a huge plus.

Additional Skillsets Desired :

- Ability to work with clients and key stakeholders to ensure requirements are met.

- Strong problem solving and debugging skills.

- Exposure to Cloud based databases.

- Passion to work in a start-up environment and readiness to dabble with challenging technologies.

- Detail Oriented.

- Ability to work in both a solo and team environment.

- Proven ability to communicate technical information coherently, both verbally and in writing, to internal team and external customers, maintaining a customer focused, friendly attitude.

Education : BE in (CS or IT) or B.Tech. (CS or IT) or Master of Computer Science (MCA or MCS)

Relevant Experience : 2 to 4 years

Skills

Data Analytics, SQL, PL-SQL, Data Modeling, AWS, Data Mining, Data Analyst, Dimensional Modeling, ETL, OLAP