- A minimum of 5+ years experience with large SQL data marts.
- Expert relational database experience.
- Candidate should demonstrate ability to navigate through massive volumes of data to deliver effective and efficient data extraction, design, load, and reporting solutions to business partners.
- Minimum 5 years of troubleshooting and supporting large databases and testing activities.
- Identifying reporting and managing database security issues, user access/management.
- Designing database backup, archiving and storage, performance tuning, ETL importing large volume of data extracted from multiple systems, capacity planning.
- Experience in TSQL programming along with Azure Data Factory framework and Python scripting.
- Work well independently as well as within a team.
- Proactive, organized, excellent analytical and problem-solving skills.
- Adaptable and willing to learn, can-do attitude is key.
- Strong verbal and written communication skills.
Good-to-Have
- Financial institution data mart experience is an asset.
- Experience in .net application is an asset.
- Experience and expertise in Tableau driven dashboard design is an asset.