Salary : $100,000 - 100,000 per year
Requirements :
- Strong proficiency in PL / SQL
- Extensive knowledge of Microsoft SQL Server
- Familiarity with SQL Server Integration Services (SSIS)
- Experience with SQL Server Reporting Services (SSRS)
- Advanced skills in Oracle Database
- Several years of practical experience with enterprise data platforms
- Expertise in SQL query tuning, indexing, and performance optimization
- Solid comprehension of data warehousing and reporting principles
- Ability to collaborate with both technical and business teams
- Excellent problem-solving and communication abilities
- (Nice to Have) Experience with BI tools like Power BI, Tableau, or similar
- (Nice to Have) Exposure to cloud or hybrid data environments
- (Nice to Have) Scripting experience in PowerShell, Python
- (Nice to Have) Familiarity with data governance, metadata management, or data quality initiatives
- (Nice to Have) Experience in large or regulated environments
Responsibilities :
Design and sustain logical and physical data models for both transactional and reporting systemsArchitect, develop, and maintain data integration processes utilizing SSIS and other ETL toolsCreate, develop, and uphold reports and datasets using SSRS and other reporting platformsConstruct and enhance SQL Server and Oracle database schemas for optimal performance and scalabilityDevelop, manage, and review PL / SQL packages, procedures, functions, triggers, and viewsOptimize PL / SQL coding for maximum performance, dependability, and maintainabilityProvide support and troubleshoot Oracle-based integrations and batch processes written in PL / SQLWork alongside application and reporting teams to establish data requirements and solutionsSet and advocate for data standards, naming conventions, and best practicesIdentify and resolve data quality, performance, and integration challengesAssess existing data architectures and propose enhancementsDocument data models, workflows, and technical decisions clearly and practicallyTechnologies :
ArchitectCloudETLSupportOraclePower BIPowerShellPythonSQLSSISTableauMore :
We are in search of a Data Architect to design, build, and support data solutions throughout our organization, emphasizing SQL Server and Oracle platforms. This hands-on role entails working with SSIS and SSRS while extensively utilizing PL / SQL to develop, maintain, and optimize Oracle-based data processes. You will collaborate closely with developers, analysts, and business teams to create data models, ensure reliable integrations, and maintain accurate and well-structured reporting data. Our hybrid work environment is based in Burlington, ON, offering competitive compensation and benefits, including on-site parking and paid time off.
last updated 3 week of 2026