<p>Skills & Expertise : </p><p><br/></p><p>- SQL<br/><br/>- Python<br/><br/>- Amazon QuickSight<br/><br/>- Google Apps Script<br/><br/>- Advanced excel<br/><br/>Roles & Responsibilities :<br/><br/>Job Purpose :<br/><br/>You will own and manage all the Data, MIS, Dashboard & Automation requirements that are needed for regular monitoring, ad-hoc requests and perform data analysis for the Business team working on Partnerships & Growth Initiatives<br/><br/>What you will do :<br/><br/>1.
Create an automated flow of information regarding all growth initiatives such as campaign monitoring, ads analysis, partnership funnel, operational findings to relevant stakeholders via multiple channels such as Quicksight dashboards, Email MISs (via python), Google sheets, Slack channels via integrations and ensure data consistency as well as anomaly detection<br/><br/>2.
Implement frameworks to automate and deploy above mentioned outputs by effective data integration, streamlining processes and operations workflows to reduce manual effort <br/><br/>3.
Create databases and data marts that are required for performing analysis and monitoring experimentation impacts on business, quickly and efficiently<br/><br/>4.
Work with growth, product, marketing, salesops, tech & data teams to build data pipelines that are required for creating reporting datasets/data marts<br/><br/>5.
Perform analysis which can be ad-hoc or regular in nature and convert them into frequency capped monitoring (if its regular) such as lead quality analysis<br/><br/>6.
Establish proactive alert mechanism for data and KPI movements to provide regular findings on designated workstream, leading to improved operational efficiency<br/><br/>Must haves :<br/><br/>1.
Excellent data manipulation skill with proficiency in excel, sql & python<br/><br/>2.
Ability to create data mart design required for building governance<br/><br/>3.
Ability to create data and metric alerts for quick anomaly detection<br/><br/>4.
Ability to do basic root cause analysis and provide findings to the stakeholders<br/><br/>5.
Ability to integrate systems for slack reporting using Google AppScript & Webhooks<br/><br/>6.
Should be from lending or marketing background, any would be preferred<br/><br/>Nice to haves : </p><p><br/></p><p>1.
Experience of handling large datasets using pyspark<br/><br/>2.
Experience in working with BI tools such Tableau, PowerBI, Quicksight, Clickhouse etc<br/><br/>3.
AI adaptability in routine tasks</p> (ref:hirist.tech)