Senior Specialist - Architecture

Role Database Engineer

Experience 7 to 8yrs relevant exp

Technical Skills Primary

• Handson experience with designing moving and transforming data tofrom Microsoft SQL Server Azure SQL Azure SQL DW Dynamics CRM Dynamics 365
• Integration technologies SQL Server Integration Services Azure Data Factory Azure Logic Apps Power Automate Azure Integration Services or similar
• Mastery of relational SQL and NoSQL databases
• Mastery knowledge of Snowflake in both AWS and Azure clouds
• Data wrangling and preparation for use within PowerBI

Responsibilities

• Evaluate existing database systems and infrastructure for migration scope and requirements
• Develop detailed migration plans timelines resources risk assessments
• Perform ETL extract transform load processes to move data between systems
• Implement database schema changes and optimize performance during migration
• Ensure data integrity consistency and security throughout migration
• Conduct comprehensive testing of migrated databases for functionality performance and security
• Identify and resolve data discrepancies or issues duringafter migration
• Collaborate with IT business units and external vendors to align migration strategies with business objectives
• Provide regular updates and reports on migration progress challenges and documentation of migration
• Provide ongoing support and troubleshooting for migrated databases

Technical Skills Secondary Nice to have

• Experience with PowerBI data preparation
• Exposure to Dynamics CRM and Dynamics 365
• Familiarity with both onpremises and cloudbased database environments

Soft Skills

• Must have time management skills and be able to multitask to meet set deadlines
• Solid written and oral communications skills