Position: Data Architect
Company: Abto Software
Category: SQL
Experience required: 5y
English level: upper
Published: 2020-09-01T00:00:00+03:00

Our ideal candidate is someone that understands dimensional modeling, and the different types of fact and dimension tables that can be built to include keeping those tables in sync with transactional databases as that transactional data changes.

Our client 
A growing company that is very data-driven, they require improvement to their current BI processes and visualizations. There is much analytics they'd like to consider but are currently unable to based on how their data is structured. This project is an ongoing effort to build out a new dimensional database.

Technology stack
AWS RedShift, Experience with AWS Glue, Hevo, or dbt Cloud would be ideal. Essentially need someone to help define how we build out a new dimensional database using the existing MySQL Aurora database. And then would need to have this new database wired up to a visualization tool/app like Metabase or Tableau.