Database Architect & Data Engineer

WorkGenius Group is an Information Technology company seeking a Database Migration Consultant. The role involves recommending a database platform, designing and implementing schemas, and executing data loads while ensuring data security and connectivity for Finance users.

Responsibilities:

• Recommend a database platform (cloud-based preferred) with Finance-only access controls
• Design and implement the schema based on the provided ERD
• Handle data quirks: multi-value fields, string parsing, optional foreign keys, standalone datasets
• Execute two data loads: Phase 1 (current Workday data through 2024) and Phase 2 (at ERP cutover)
• Configure Power BI connectivity for Finance users

Requirements:

• Strong SQL and relational database design skills
• Experience with large datasets (150GB+) including file/attachment storage
• Role-based access control and data security experience
• Power BI connectivity experience
• Workday or ERP migration experience is a plus
• cloud-based