Job Overview:
We are looking for an experienced Advanced Analytics Consultant to join our analytics team. In this role you will
analyse and interpret complex datasets to support digital support platforms payments and risk platform
performance. The ideal candidate will possess a strong foundation in SQL Python and Tableau with expertise in
building data pipelines automated dashboards and insightful reports to drive business decisions.
Primary Responsibilities:
Develop and maintain clear concise KPI reporting on the performance of online digital support payments
and risk platforms by analysing web metrics and payment tools.
Conduct data mining and pattern analysis across various data points to uncover trends and correlations.
Execute endtoend analysis on digital and payment touchpoints from data gathering to data processing
and analysis of large and complex data sets.
Perform deepdive analysis of user behaviour customer journeys and other key metrics to assess the
effectiveness of digital and payment initiatives identifying opportunities for enhancement.
Present analytics findings and research results to business teams providing actionable recommendations.
Gather analyse and transform large data sets into business models using SQL and Python while building
narratives around the data; create and automate Tableau dashboards for efficient reporting.
Build and maintain complex data pipelines and Airflow DAGs to support various internal selfserve analytics
functions.
Ensure high data quality and integrity for analysis and reporting collaborating closely with global operations
and India analytics teams.
Apply descriptive diagnostic and predictive analytics to solve business problems within the assigned scope
using advanced analytical tools and techniques.
Requirements
Technical Skills (Must Have):
Proficiency in Intermediate Python Advanced SQL (Window Functions DML/DDL Commands CTEs
Subqueries etc) for data analysis and building end to end data pipelines.
Intermediate to Advanced Proficiency in Tableau Airflow Excel Google Spreadsheets Adhoc analysis
business insights and Power Point/Keynote.
Experience with data warehouses/data lakes including platforms like Presto Hive Teradata and Spark.
Ability to write complex queries and strong understanding of database concepts.
Strong analytical and problemsolving skills with an aptitude for quickly learning new tools and techniques.
Proficient in data analysis and presentation with a strong ability to communicate insights clearly.
Selfmotivated with excellent problemsolving skills and the ability to work independently and own projects
from start to finish.
Strong organizational and time management skills capable of managing multiple priorities and meeting
deadlines.
Nice to Have:
Knowledge of payment processes systems and tools.
Understanding of risk/compliance processes and data requirements.
Experience with Unix Shell scripting for data pipeline automation and analysis.
Knowledge of statistical concepts and machine learning algorithms (e.g. regression clustering).
Education:
1. Bachelors degree with postgraduate studies in Management Science Analytics or a related field.
2. 35 years of relevant experience in analytics roles within large corporations or consulting firms
Benefits
- Opportunity to define your career path and not as enforced by a manager
- A great consulting environment with a chance to work with Fortune 500 companies and startups alike.
- A dynamic but relaxed and supportive working environment that encourages personal development.
- Be part of One Extended Family. We bond beyond work sports gettogethers common interests etc. Work in a very enriching environment with Open Culture Flat Organization and Excellent Peer Group.
- Be part of the exciting Growth Story of Thoucentric!
SQL, Python, Tableau, Data Engineer
Data Engineer SQL Python
