Business Data Analyst
- Toronto, ON, Canada
$45 to $50 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $45 to $50 CAD / hour
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Job Title: Business Analyst (SQL, T-SQL, PL/SQL)
Location: Toronto, ON
Work Arrangement: Hybrid (2 day/week)
Employment Type: Contract
Rate: CAD 45-50
Domain: BFSI
Application Deadline: Nov. 15th, 2026
Skills:
- 7-10 years of exp. as Business Analyst/BSA
- Strong PL/SQL and T-SQL development and query optimization skills.
- Experience in Data Modelling using industry-standard modeling tools, Gap Analysis, and MS Visio.
- Strong understanding of Data Warehousing concepts, ETL processes, and source-to-target data mapping.
- Experience supporting L2/L3 data models and enterprise data warehouse environments.
- 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.
- Experience with Sybase PowerDesigner for data modeling.
- Knowledge of cloud technologies such as Amazon AWS.
EEOC Compliance:
We are an equal opportunity employer, and all qualified applicants will receive consideration for employment.
DISCLAIMER
AI Usage Policy: Pacer Group uses AI to assist in screening applications. Final hiring decisions are made by human recruiters based on qualifications and experience.
More about this job
Responsibilities
Gather and document requirements through workshops with business and technology stakeholders, and conduct data analysis, profiling, and legacy system analysis. Support enterprise data warehouse initiatives, including data modeling, ETL processes, source-to-target mapping, and L2/L3 data models.
Requirements
Requires 7–10 years of Business Analyst or Business Systems Analyst experience, with strong PL/SQL and T-SQL development and query optimization skills. Candidates should have experience with data modeling tools, data warehousing, ETL, requirements gathering, technical documentation, and Sybase PowerDesigner; knowledge of AWS is also noted.
Skills
- Business Analysis
- PL/SQL
- T-SQL
- Query Optimization
- Data Modeling
- Gap Analysis
- MS Visio
- Data Warehousing
- ETL
- Source-to-Target Data Mapping
- L2/L3 Data Model Support
- Requirements Gathering
- Stakeholder Workshops
- Data Analysis
- Data Profiling
- Legacy System Analysis
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Finance & Accounting
- Consulting
Keywords
- Business Analyst
- Business Systems Analyst
- SQL
- T-SQL
- PL/SQL
- Query Optimization
- Data Modeling
- Sybase PowerDesigner
- MS Visio
- Gap Analysis
- Data Warehousing
- ETL
- Source-to-Target Data Mapping
- Enterprise Data Warehouse
- L2/L3 Data Models
- Requirements Gathering
- Stakeholder Workshops
- Data Analysis
- Data Profiling
- Legacy System Analysis
- Technical Documentation
- Amazon AWS
- BFSI