Blog

Data Modeler / GC or USC only / 10+ years only

Location: Remote – some light travel possible (quarterly)

Position: Data Modeler – 2 main areas of work (current state and target state)

Terms: 6m+ – (USC/GC)

Team: Enterprise Applications Architecture

Interview Process: 2 interviews – screen with Mike.  Then a panel.

Need copies of photo Id and 2 references

Current Project: Current state reverse engineering model systems

Current state reverse engineering model systems

Future state they are building new databases.  Moving to microservices

architecture and need to take the business requirements to design the databases for relational databases and data warehouses.

Technical Skills:

Currently using Toad, but they just need experience with a modeling tool

Spreadsheets for data dictionaries

Take the tables and drag them around into a model that makes sense

Hands-on writing queries digging into the database

SQL

NoSQL

Oracle

Data warehousing

Great communicators – they will need to define requirements with the business and technical teams

Eventually want to standup a data repository

Multiple modeling tools and hands-on experience most important

Questions from hiring manager:

• What data modeling tools have you used?  Describe the databases you have designed.  Were they relational databases?  Have they reverse engineered data models from a database?  What were some of the challenges?
• Describe your experience writing SQL queries.    Can you write a complex SELECT statement?  Have they generated DDL from a data model to create a database?

Disclaimer: We respect your online privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient/recipients and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you have received this mail in error or prefer not to receive such emails in the future or To Unsubscribe please reply to [email protected] We are sorry for the inconvenience.