Data Analyst sql/excel Soft interview questions.

What are you looking for in your next role?

* Analyst position with learning opportunities * Ability to have collaborative relationships with cross-functional teams

How do you deal with pressure or stressful situations?

-Take a breath and step back. -Break it down into bullet points. -Start with the easiest one first. -If perfect solution not available accept and come to next best solution.

How do you explain your gap in employment?

Became full time caretaker for grandfather who had stage 4. Took online boot camps to stay brushed up on sql and learn python.

"What are your biggest strengths?"

Good at latching onto interesting problems. thinking outside the box coming up with multiple solutions Fast learner, once I'm comfortable with the material and system, I'm able to work quickly and find shortcuts and alternative solutions. - examples, math, sql, workflow.

"Where do you see yourself in five years?"

I would like to be a senior data analyst working on challenging problems.

Why are you interested in this position?

I get satisfaction out of getting tangible answers out of broad data. Being able to provide value by interpreting things is appealing to me.

6. "Why Did You Leave Your Last Job?"

I was let go because I had an emergency and requested days off but was not approved but I had to take the days off anyways. This was during covid

What did you do at Corelogic?

In my day to day I would pull queries from our customer database to use for reports and customizing and maintaining customer products. Use the queries to make lists to send out to teams that they would need to change. Make batch changes and update customers product. I would also work with data managment for cleanups and updates over large customers.

"What are your biggest weaknesses?"

Multitasking too much. If i had 3 big projects, I would work on them all at the same time. To combat this, I now break things down into completed tasks and finish them one by one.

"Tell me a little about yourself."

Ryan, studied math and econ, worked as a operations analyst, experience in sql and excel, looking for analytical role. Hey thanks for having me. My past experience using sql and excel in operations has helped me to use it simply and efficiently. I'm passionate about thinking creatively to find simple solutions. I've worked with real estate and consumer credit data in the past and seen how messy it can get when people over multiple teams try to use it in different ways, so thats why I'm excited to hear more about what you guys do.

"What questions do you have for me?"

What growth opportunities / learning opportunities does this job have? Whats your day to day look like? (Has it changed in past few years) What's your favorite thing about working here? What did you not expect about working here? What's the team culture like?

"Why Should We Hire You?"

experience and problem solving will help the team. willing to grow and fit into the team to help as much as possible

"What do you consider to be your biggest professional achievement?"

setting up data management system

Name functions you used in your python projects.

value counts freq_table (frequency table) plot (histogram, scatter chart, bar plot) sort.index