Data Modeler

Data Modeler

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?

|

,

5208 Windsor Ln, Copper Canyon, Texas, 75077