Data Interview Questions Flashcards
describe a project where you defined and executed a strategic data solution?
Coral/ART
Bond Supply
How have you approached building and maintaining relationships with cross-functional teams and third-party vendors in your previous roles?
Open communications - Slack/Teams for the project
Transparency
Build Trust - Honesty. deliver. Takes a long time
How do you prioritize features and projects when working on data enablement strategies
Get the value of each task from the stake holders and the time required from the developers. Hit high value, short time committemnt first and then work your thogrou the high value list
Say NO sometimes
explain a time when you had to translate a complex technical concept for a non-technical audience?
Overfitting in machine learning - My daughter memorizing the book instead of learning to read
Database normalization. using IDs instead names to track employees. Married worker in the mailing list, hr list, vacation list
Describe a situation where you identified an opportunity for improvement in a data solution.
What if scenario for risk model
Focus on top selling cars for JD Power
How do you stay updated with emergent technologies, such as AI
Monthly tech breakfasts
Blogs
Coursera
Chat GPT
What strategies have you used to ensure that data governance decisions align with a broader data strategy
Sicav Index compliance log
3/5/10 rule for mutual funds
Data quality tests for incoming data
Give examples of vendor budget you managed
RIMES ETF look through
RIMES Index Data
DataStream
Bloomberg
Bloomberg back office
Cloud Attribution
Tell me about a time when you had to drive adoption of a new data solution or platform.
How do you handle conflicting priorities when managing cross-functional initiatives?
Prioritize based on value
If the priorities are for the same stakeholders I let the stakeholders decide.
When there are different stakeholders I escalate for guidance
Manage Stakeholder Expectations
Document Decisions and Rationales
Describe a project where you had to deliver iteratively.
Coral - One desk at a time
BAM Bond Supply one country at a time
Can you describe a project where you were involved in the design or implementation of a data warehouse?
WB - Data from 2 accounting systems plus look through form vendors and web scraped data
UBS Coral - Data from 3 accounting systems
Both of those I standarized the data into a rigid format and quality checked it as it come in
How do you handle the challenge of data integration from disparate sources into a data warehouse?
Staging areas to receive income data that is timestamped by load date. loads are kept seperate.
Qyualit check data, clean, transfor and then load intot he ware hosue
use datasouirce IDs
How do you approach data modeling for a data warehouse?
