Our valued Public Sector client requires a Senior Data Modeler to model OLTP and data warehouse solutions for Data Architecture Services.
Staff from the team have been assigned to another project and need to be backfilled in order to fulfill all project and maintenance responsibilities.
Maintain existing transactional and analytical database models
Update existing transactional and analytical database models to support application maintenance activities.
Create new transactional and analytical database models ( conceptual, logical and physical ) to support application development activities.
Writing source to target transformation rules for data mart / warehouse .
Maintain team and application documentation.
Respond to client requests.
Interact with and support application development and business clients.
Gather and document data requirements.
Interact with and support the database administrator.
Participate in team status and planning activities.
Transfer technical knowledge to department staff through documentation and coaching.
Expertise and Skills
Architecture, Data Architect 2 - 4 years
Business Analysis, Data Modeling 8 - 10 years
Architecture, Data Modelling 8 - 10 years
DBA, Data Warehousing 2 - 4 years
Must-have : Please describe two projects where you worked with transactional and analytical database models