Case outline Your client is a large retail FX broker who wants to: * Predict what customers will leave the service and not renew their subscription at the end of the month * Reach out to those whose engagement has dropped. 3 Questions Question 1: Explain what approach would you take on your first week on the project? Question 2: Explain at a high level a solution would you propose the client use to address their problem? And what team members you would recruit deliver it? You are the lead project manager in your Capco team. You are tasked to advise them on how to approach this by inspecting the data they have available. A customer joins on a rolling monthly contract, and they can choose to auto renew or re-subscribe manually at the end of every month. A customer is considered to have left the service if there is no renewal of subscription 30 days after the expiry of the previous subscription. You will be presenting your response back to the Client Relations Business Stakeholder and a member of their data analytics team.
Senior Data Consultant Interview Questions
130 senior data consultant interview questions shared by candidates
When did you have to make a difficult decision?
Questions based on all the skills from my skill set DWH,Azure Data Lake,Azure Data Factory,Azure Synapse(warehouse and workspace),Databricks,Azure Analysis Services,PowerBI,DevOps,GIT,parquet file format,jira/agile framework. General management related questions were also asked.
Have you worked with our software before?
Warum wollen Sie Job wechseln?
Use cases where i faced challenges and how did i manage to resolve it? My understanding and approach of Data Governance Scenarios related to the collection of Metadata and lineage How did i determined the Data Elements as Critical Data Elements/Key Data Elements My understanding of GDPR/BCBS 239, PII data(with examples) Data quality dimensions with real time examples/Data quality life cycle
Souhaitez-vous manager/encadrer des consultants ?
In 4 hours to develop a use case plus a presentation of multiple use cases I could think.
A lot of simple (what SQL Server I worked in the past with) and complicated questions about Transact-SQL, SSIS, SSRS, SSAS, schemes, data types, Business Intelligence, ETL.
What tools do I use for data integration?
Viewing 11 - 20 interview questions