AMANST Inc. is looking for Senior Business Intelligence Specialist for a contract opportunity with Government of Ontario.
Requisition deadline: 16 Jul 2025 at 01:30 pm
Location: Hybrid - Candidate MUST work 3 days onsite and 2 days remote

DESIRED SKILLS AND EXPERIENCE

· Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.
· Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, configuring data gateways, and utilizing advanced features such as DAX and Power Query.
· Knowledge of technologies commonly used with Dynamics 365, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.
· SQL and Query Optimization: Strong SQL skills for writing complex queries, optimizing database performance, and troubleshooting query performance issues. Understanding of indexing, partitioning, and query execution plans.
· Data Modeling and Design: Proficiency in designing logical and physical data models, understanding relationships, defining hierarchies, and ensuring efficient data storage and retrieval.
· Data Visualization: Ability to create visually appealing and informative reports and dashboards using Power BI, understanding best practices for data visualization, and storytelling with data.
· Data Security and Governance: Knowledge of data security principles, data governance practices, data quality management, and data lifecycle management.
· Analytical and Problem-Solving Skills: Strong analytical thinking and problem-solving abilities to identify business requirements, analyze data, and provide meaningful insights to stakeholders.
· Communication and Collaboration: Effective communication skills to interact with stakeholders, gather requirements, and present findings. Collaboration skills to work with cross-functional teams, such as data engineers, data analysts, and business stakeholders.
· Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps) for managing code, tracking changes, and collaborating with team members.
· Experience with SQL Server Management Studio, Azure data management tools, data modeling tools
· Experience with SSIS, SSRS

Please refer the Job description for details