Darragh Keaveney
Data Analyst, SQL, Power BI and Python
Dear Ms Faherty,
I'd like to be considered for the Senior Data Analyst role on your customer retention team. For the last five years I have worked in SQL, Python and Power BI for an energy supplier and an insurer in Galway, and the piece of work that matches your advert most closely is a switching analysis of three years of smart meter and billing data that found when households leave; the findings shaped a loyalty tariff that reduced churn in its first two quarters.
Your posting asks for retention analysis the business acts on. At Corrib Grid Energy I designed and read out six A/B tests on the online switching journey with the digital team, including sample sizes and guardrail metrics, and I built a Power BI model for 40 operations and customer care managers that replaced seven weekly spreadsheet reports and saves the team about twelve hours a week. The managers open it because it answers the question they asked rather than the one the data happened to answer.
I know the insurance side of this work too. At Lough Atalia Insurance I built a lapse analysis by policy age and channel that helped the pricing team target renewal discounts with less give-away, produced the weekly sales, claims and lapse reports for 60 branch and broker managers, and automated the monthly Central Bank of Ireland data return in Power Query and SQL, cutting preparation from three days to half a day. I am careful with personal data: the quality checks I wrote on the customer and meter tables run before the CRU regulatory return is built, and I would bring the same habit to policyholder data.
My CV is enclosed with the tools and projects set out in full, and I can walk through the switching analysis and the lapse model at interview with the charts the managers received. I am in Galway and available at a day's notice. Thank you for reading.
Yours sincerely,
Darragh Keaveney