Company Description
Arthur Grand Technologies (www.arthurgrand.com) is in the business of providing staffing and technology consulting services. We have doubled our revenue year over year for the past 5 years. This speaks to the long-lasting relationship and customer satisfaction that we have built in this short span of time. Our company is managed by a team of professionals who worked for big 5 consulting firms for 20+ years.
We are a minority owned staff augmentation and technology consulting company
To keep our valued employees, we need to keep them engaged in challenging, interesting work, offer market-relevant benefits and provide continued opportunities for professional growth.
Job Description
Position: Software Developer - ETL - Senior
Location: Toronto, Ontario (Onsite)
Duration: Long Term Contract
MUST HAVES:
- 5+ years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns. Understanding of data pipeline architectures, Azure workflow orchestration tools, and concepts related to data ingestion, transformation, and movement.
- Proficiency in Azure Data Factory, Azure Synapse workspaces, PolyBase, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
- Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies.
- Proficiency in scripting languages like Python, experience with Azure-specific scripting using PowerShell or Azure CLI.
- Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning
- Knowledge of integration technologies commonly used with Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.
- Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.
- Familiarity with data warehousing concepts and experience working with Azure Synapse Analytics or similar platforms for building and managing large-scale data warehousing/lakehouse solutions.
- Experience with SSIS, SSRS, PowerBI
NICE TO HAVE SKILLS AND EXPERIENCE:
- Azure cloud certifications (e.g. Azure fundamentals, Azure Data Engineer associate, Azure Database Administrator associate)
- Experience with PowerApps platform, Power Automate, Dynamics CE and F&O
Experience and Skill Set Requirements
Criteria 1 - Data Migration, ETL (40 Points)
- Demonstrated experience with ETL development, data pipelines, workflow orchestration and data ingestion, transformation, and movement
- 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 with Azure Data Factory, Azure Synapse workspaces, PolyBase, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
- Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning
- Demonstrated experience with SQL Server, Oracle, Azure SQL Databases
- Demonstrated experience with data modeling tools (preferably, ERWIN)
- Demonstrated experience in scripting languages like Python and with Azure-specific scripting using PowerShell or Azure CLI.
- Experience with software development lifecycle
- Experience with data modeling, physical database design, data flow diagrams
Criteria 2 - Data Warehousing and Reporting (20 Points)
- Demonstrated experience working with Azure Synapse Analytics or similar platforms for building and managing large-scale data warehousing/lakehouse solutions
- Experience with data warehousing modelling concepts such as star and snowflake schemas
- Experience with SSIS, SSRS, PowerBI
- Experience with supporting a data warehouse in a production environment
Criteria 3 - Azure Platform (20 Points)
- Experience with Azure Data Factory (ADF) and Synapse Workspaces
- Demonstrated experience Azure data management tools, DevOps, Synapse Studio
- Experience in Azure resource configuration and administration such as Azure Data Lake, Blob Storage, Key Vault, Application Insight resources, resource groups and subscriptions.
- Familiar with Azure cloud platform
- Azure cloud certifications
Criteria 4 - Dynamics 365 (10 Points)
- Demonstrated experience working with integration technologies commonly used with Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.
- Demonstrated experience with PowerApps platform, Power Automate, Dynamics CE &F&O
Criteria 5 - DevOps and CI/CD (10 Points)
- Demonstrated experience with continuous integration/continuous deployment (CI/CD) tools and processes around DevOps, data workflows, Synapse workspaces.
Additional Information
All your information will be kept confidential according to EEO guidelines.
