Unfortunately, this job posting is expired.
Don't worry, we can still help! Below, please find related information to help you with your job search.
Don't worry, we can still help! Below, please find related information to help you with your job search.
Related keywords
- Business Intelligence Specialist
- Senior Business Intelligence Developer
- Product Specialist Business Intelligence
- Senior Business Intelligence Engineer
- Senior Business Intelligence Consultant
- Business Intelligence Senior Developer
- Senior Business Intelligence Analyst
- Senior Business Intelligence Specialist
- Business Intelligence Senior Analyst
- Business Intelligence Specialist – Senior
Some similar recruitments
Senior Business Intelligence (Bi) Specialist
Recruited by CAAT Pension Plan 7 months ago
Address Toronto, Ontario, Canada
Business Intelligence Specialist - Etl Developer
Recruited by Tangentia 7 months ago
Address Toronto, Ontario, Canada
Business Intelligence Engineer (Remote, Canada)
Recruited by OpenTable 8 months ago
Address Toronto, Ontario, Canada
Senior Manager Business Intelligence
Recruited by Motion Recruitment 8 months ago
Address Toronto, Ontario, Canada
Senior Business Intelligence Analyst
Recruited by Grammarly 8 months ago
Address Toronto, Ontario, Canada
Business Intelligence Specialist Jobs
Recruited by Orillia Soldiers' Memorial Hospital 8 months ago
Address Orillia, Ontario, Canada
Business Developer Jobs
Recruited by Axelor 9 months ago
Address Toronto, Ontario, Canada
Senior Analyst- N.a. Business Intelligence & Insights
Recruited by The Kraft Heinz Company 9 months ago
Address Toronto, Ontario, Canada
Developer, Business Intelligence Jobs
Recruited by Bell 9 months ago
Address Toronto, Ontario, Canada
Business Intelligence (Bi) Specialist – Senior
Recruited by Procom 9 months ago
Address Toronto, Ontario, Canada
Senior Business Intelligence Analyst
Recruited by VetStrategy 9 months ago
Address Woodbridge, Ontario, Canada
Business Intelligence Developer (Student Position)
Recruited by Canada Life 9 months ago
Address Toronto, Ontario, Canada
Business Intelligence Specialist (Powerbi)
Recruited by Amyantek 9 months ago
Address Toronto, Ontario, Canada
Business Product Manager - Workbench
Recruited by EY 9 months ago
Address Toronto, Ontario, Canada
Sr Business Intelligence Specialist
Recruited by Pinaki 9 months ago
Address Toronto, Ontario, Canada
Senior Business Intelligence Specialist
Company | AMANST Inc. |
Address | Toronto, Ontario, Canada |
Employment type | CONTRACTOR |
Salary | |
Expires | 2023-12-28 |
Posted at | 9 months ago |
AMANST Inc. is looking forSenior Business Intelligence Specialistfor a contract opportunitywith Ontario Government.
Requisition# RQ05752
Estimated Business Days:180 days
Submission deadline: 05 July 2023 at 01:00 pm
Must Haves- 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 and utilizing advanced features
- Experience with SSIS, SSRS
- Public Sector Experience
- Reporting and Visualization: develop reports, dashboards and visualizations as per reporting MVP. Ensure the quality, accuracy and integrity of reports.
- Data Warehouse Design: analyze business requirements and design an efficient data warehouse/lakehouse/golden layer on Microsoft Azure
- Data Security and Governance: implement appropriate security controls to protect sensitive data within the data warehouse.
- Data Integration and ETL: help develop and automate ETL processes to load data from Dynamics 365 CE and F&O into the new data warehouse/lakehouse (bronze/silver/golden layers). Help integrate data from diverse sources into the new data warehouse.
- Performance Optimization: fine-tune the data warehouse and reporting processes to optimize query performance and overall system efficiency.
- Data Modeling: create logical and physical data models that align with the project’s reporting and analytical needs.
- Other duties as assigned.
- Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the Assignment Deliverables, as soon as he/she becomes aware of them
- Comply with the Ontario Government and the Cluster/Ministry security procedures and practices
- Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.
- Complete work and achieve milestones within the assigned deadlines.
- Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines
- Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices
- Submit Deliverables for the Cluster/Ministry approval as they are completed.
- Provide knowledge and skill transfer to a designated Cluster/Ministry staff; and
- Experience with SQL Server Management Studio, Azure data management tools, data modeling tools (preferably, ERWIN).
- 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.
- Analytical and Problem-Solving Skills: Strong analytical thinking and problem-solving abilities to identify business requirements, analyze data, and provide meaningful insights to stakeholders.
- Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.
- 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 Integration: Knowledge of various data integration techniques, including data extraction from different sources (e.g., databases, APIs, flat files), data transformation, and loading into a data warehouse. Familiarity with ETL tools and technologies, such as Azure Data Factory or SSIS (SQL Server Integration Services).
- 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.
- 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.
- Microsoft Azure Synapse: In-depth knowledge and experience with Azure Synapse Analytics, including its architecture, data storage options (e.g., SQL Data Warehouse, Data Lake Storage), data ingestion mechanisms (e.g., Azure Data Factory, Azure Databricks), and security features.
- Experience with SSIS, SSRS
- 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.
- Data Modeling and Design: Proficiency in designing logical and physical data models, understanding relationships, defining hierarchies, and ensuring efficient data storage and retrieval.
- Azure cloud certifications (e.g. Azure fundamentals, Azure Power BI Data Analyst Associate)
- Experience with PowerApps platform, Power Automate, Dynamics CE and F&O
- Demonstrated experience with data warehousing modelling concepts such as star and snowflake schemas and data modelling tools (preferably, ERWIN)
- Demonstrated experience developing reports in a Data Warehouse/ Lakehouse. Experience with supporting a data warehouse in a production environment
- Demonstrated experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools
- Demonstrated experience working Power BI, creating interactive reports and dashboards, configuring data gateways, utilizing advanced features such as DAX and Power Query.
- Experience with SSIS, SSRS
- Demonstrated experience with SQL Server, Oracle, Azure SQL Databases
- Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning
- Demonstrated experience Azure data management tools, DevOps, Synapse Studio
- Azure cloud certifications
- Experience with Azure Data Factory (ADF) and Synapse Workspaces
- Experience in Azure resource configuration and administration such as Azure Data Lake, Blob Storage, Key Vault, Application Insight resources, resource groups and subscriptions.
- Demonstrated experience with PowerApps platform, Power Automate, Dynamics CE &F&O
- Demonstrated experience working with integration technologies commonly used with Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.
-
Agente Ou Agent De Prévention De Soir Au Service De La Gestion Des Sentences
By Ministère de la sécurité publique At Montreal, Quebec, Canada 7 months ago
-
Lead Line Cook/Manager On Duty
By Impact Kitchen At Greater Toronto Area, Canada 7 months ago
-
Refinish Tech (Temporary) Jobs
By Boyd Group Services Inc. At Saskatoon, Saskatchewan, Canada 7 months ago
-
Vice President - Treasury
By Boyd Group Services Inc. At Winnipeg, Manitoba, Canada 7 months ago
-
Rock Mechanics Eit Jobs
By WSP in Canada At Greater Sudbury, Ontario, Canada 7 months ago