Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Astra-North Infoteck Inc.

Data Business Analyst - PL/SQL, T-SQL & Data Warehousing

Posted Updated

Description

Astra-North Infoteck Inc. in Toronto, ON, is seeking a Data Business Analyst with PL/SQL and T-SQL expertise for hybrid work. The role focuses on legacy system analysis, data modeling, and integration of L2/L3 data models into the data pipeline.

You will collaborate with data scientists, analysts, and IT to design data movement models, establish governance, and improve data quality across enterprise data warehouses. 8–10 years of experience preferred.

Determine operational objectives by studying business functions, gathering information, and evaluating output requirements and formats. Design solutions, analyze requirements, and design modifications. Define project requirements by identifying project milestones, phases, and elements, and forming project teams. Monitor project progress by tracking activities, resolving problems, publishing progress reports, and recommending actions. Provide references for users by writing and maintaining mapping documentation. Maintain user confidence and protect operations by keeping information confidential. Prepare technical design and mapping through data collection, analysis, and profiling. Maintain professional and technical knowledge through workshops and continuous learning. Work with business and technology teams to fulfill data requirements. Prepare data models and technical design documentation according to standards. Assess intake requests for new projects and change requests. Strong knowledge of SQL and analysis of data from different product systems. Strong PL/SQL and T-SQL development and query optimization. Experience in Data Modeling using industry-standard tools, Gap Analysis, and MS Visio. Strong understanding of Data Warehousing concepts, ETL processes, and source-to-target data mapping. Proven experience conducting requirement-gathering sessions and stakeholder workshops across business and technology teams. Experience in data analysis, data profiling, legacy system analysis, and technical documentation within large-scale data initiatives.

Skills

Apply

See also

Business Analysis jobs by country — openings, pay and top skills →