HR/Recruiter interview followed by one on one with Team lead over the phone and an in person SQL/analytics test with Team lead and/or other analyst
SQL/Analytics test is relatively simple describing what various logic is doing, fixing broken logic, providing examples of how you’d solve various problems you’re presented with