Senior Analyst - SQL/ETL/Hive (3-6 yrs)

Job Description :

Roles & Responsibilities :

- Work closely with a team of x-functional payment compliance stakeholders to keep the platform safe by anticipating and detecting new fraud trends and ensuring regulatory compliance

- Define KPIs, Set benchmarks/baseline, analyze trends to ensure a safe and compliant payment platform

- Build a quality data foundation you need for your analytical needs, in partnership with the data engineering team.

- Perform necessary ad-hoc analysis that translates in actionable product insights

- Design experiments to measure the impact of new payment features

- Empower the product and engineering teams to make data-driven decisions

Requirements :

Technical Skills :

- 4+ years of experience in SQL, ETL, Hive skills.

- Experience in click stream data is a must.

- Strong experience in T-SQL and query optimization, developing ETL strategies

- Excellent SQL scripting knowledge (procedures, triggers, indexes) along with query optimization techniques.

- Proficient in writing and understanding complex SQL queries; experience working with large data sets and Hive databases

- Background in statistics and experience with experimentation (Optional)

- Experience or willingness to learn tools to create data pipelines using Airflow/Minerva

Other requirements :

- Strong multi-tasking & project management skills, Keen sense of prioritization.

- Self-motivated and driven to deliver agreed results on-time.

- Good story-telling & articulation skills - ability to convert analytical output into clear, concise, and persuasive insights & recommendations for technical & non-technical audience

- Strong influence and relationship management skills; comfortable interacting across all levels of stakeholders