Data Business Analyst - Pl/Sql, T-Sql & Data Warehousing
Astra-North Infoteck Inc.
Data Business Analyst - PL/SQL, T-SQL & Data WarehousingData Business Analyst - PL/SQL, T-SQL & Data Warehousing
Location:
Toronto, ON
Work Arrangement:
Hybrid (2 days per week in-person at Toronto office preferred)
Years of Experience:
8–10 years
Skills:
Business Analysis, Solution and Functional Architect (SAFA), Data Analytics & Insights – ignio AIOps
Job Responsibilities1. Analysis of Legacy Systems
For each use case, analyze the mapping document of target tables to determine operational objectives by studying business functions, gathering information, and evaluating output requirements.
Track the target field mapping back to the original data element in the source system.
Strong knowledge of SQL to perform data analysis and data profiling on different legacy systems.
Document the existing source-to-target data flow for each table, including:
Business transformation rules applied.
Key-cutting implemented to identify surrogate keys defined as unique identifiers in a table.
Reference data used to enhance the context and validity of target data elements.
For tables where mapping documentation is not available, TSBI and ETL leads must jointly review the code to extract business rules and capture them in the requirements document.
2. L2/L3 Model
The business team is responsible for the creation of the L2 Model, supported by the Project Business Analyst, Solution Architect, and TSBI.
Collaborate with data scientists, business analysts, and IT teams to integrate advanced L2/L3 models into the data pipeline.
3. Mapping Design of New L2/L3
Prepare technical design and mapping (Data Movement Model) for the new L2 Model by working with Project Business Analysts and Solution Architects.
Review the key-cutting process to be implemented on the L2 model and obtain approval from L2 Schema Owners.
Only BORT system data will be populated into the L2 schema;
other reference and tactical data will be directly consumed by L3 processes.
L2-to-L3 mapping will contain business transformation rules for each target table.
A custom surrogate key process will be implemented on L3 tables, which will contain different keys than L2 tables.
Any system with one-off tables holding business data will be loaded into the L3 schema for target table processing.
Spearhead the implementation of robust data governance policies and procedures, ensuring compliance with industry regulations and standards, resulting in a 20% reduction in data security incidents.
Collaborate with cross-functional teams to design and implement data quality frameworks, improving data accuracy and integrity while reducing errors.
Role and Responsibilities
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.
5 Mandatory Must-Have Skills and Experience
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.
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.
5 Nice-to-Have Skills and Experience
Knowledge of banking domain data, including customer, account, and transaction data.
Experience with Sybase PowerDesigner for data modeling.
Knowledge of cloud technologies such as Amazon AWS.
Familiarity with data governance and data quality frameworks.
Experience supporting L2/L3 data models and enterprise data warehouse environments.
#J-18808-Ljbffr
Location:
Toronto, ON
Work Arrangement:
Hybrid (2 days per week in-person at Toronto office preferred)
Years of Experience:
8–10 years
Skills:
Business Analysis, Solution and Functional Architect (SAFA), Data Analytics & Insights – ignio AIOps
Job Responsibilities1. Analysis of Legacy Systems
For each use case, analyze the mapping document of target tables to determine operational objectives by studying business functions, gathering information, and evaluating output requirements.
Track the target field mapping back to the original data element in the source system.
Strong knowledge of SQL to perform data analysis and data profiling on different legacy systems.
Document the existing source-to-target data flow for each table, including:
Business transformation rules applied.
Key-cutting implemented to identify surrogate keys defined as unique identifiers in a table.
Reference data used to enhance the context and validity of target data elements.
For tables where mapping documentation is not available, TSBI and ETL leads must jointly review the code to extract business rules and capture them in the requirements document.
2. L2/L3 Model
The business team is responsible for the creation of the L2 Model, supported by the Project Business Analyst, Solution Architect, and TSBI.
Collaborate with data scientists, business analysts, and IT teams to integrate advanced L2/L3 models into the data pipeline.
3. Mapping Design of New L2/L3
Prepare technical design and mapping (Data Movement Model) for the new L2 Model by working with Project Business Analysts and Solution Architects.
Review the key-cutting process to be implemented on the L2 model and obtain approval from L2 Schema Owners.
Only BORT system data will be populated into the L2 schema;
other reference and tactical data will be directly consumed by L3 processes.
L2-to-L3 mapping will contain business transformation rules for each target table.
A custom surrogate key process will be implemented on L3 tables, which will contain different keys than L2 tables.
Any system with one-off tables holding business data will be loaded into the L3 schema for target table processing.
Spearhead the implementation of robust data governance policies and procedures, ensuring compliance with industry regulations and standards, resulting in a 20% reduction in data security incidents.
Collaborate with cross-functional teams to design and implement data quality frameworks, improving data accuracy and integrity while reducing errors.
Role and Responsibilities
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.
5 Mandatory Must-Have Skills and Experience
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.
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.
5 Nice-to-Have Skills and Experience
Knowledge of banking domain data, including customer, account, and transaction data.
Experience with Sybase PowerDesigner for data modeling.
Knowledge of cloud technologies such as Amazon AWS.
Familiarity with data governance and data quality frameworks.
Experience supporting L2/L3 data models and enterprise data warehouse environments.
#J-18808-Ljbffr
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Data Business Analyst - Pl/Sql, T-Sql & Data Warehousing in Winnipeg, MB vacancy
$8236 - $9896 per month
...maintain enterprise BI solutions. The ideal candidate must have a diploma in computer science and at least three years of experience in data warehousing or analytics. This full-time temporary position offers a hybrid work model and a salary range of $8,236 - $9,896 per month. Join...SuggestedFull timeTemporary work- Data Business Analyst, Data Governance Location: Toronto, ON (Hybrid, 1 day onsite per week, Thursdays)Language: Strong written and verbal... ...governance practices. Familiarity with cloud data platforms, data warehousing, ETL/ELT processes, and DAMA-DMBOK principles is an asset....SuggestedPermanent employmentContract workFlexible hours1 day per week
- ...boldly embrace innovation in all areas as we continue to grow our business into the future. Working with us means you’ll be part of a... ...professionally. How You’ll Make an Impact As a Senior Technical Analyst, Data Engineering and Business Intelligence, at Fidelity Investments...SuggestedWork at officeFlexible hours
$92.45k - $105k per year
...among others. Toronto, ON; HybridAbout the role: As a Data Business Analyst supporting our enterprise Data & AI strategy, you will bridge... ...practices, and modern cloud data platforms, including data warehousing and ETL/ELT workflows.Collaboration and communication: Demonstrated...SuggestedFull timeInternshipFlexible hours- Senior Data AnalystLocation: Toronto, ON – Hybrid (4 days onsite per week) Must-Have... ...to ensure technology deliverable fulfill business requirement Perform in depth data analysis... ...system analysis in a complex data warehousing environment running on Netezza and Cloud....SuggestedContract work
- ...transformation delivered, spreading the technology and data culture, shortening the decision-making... ...or aligned to the different sub business units.Responsibilities The aim of Global... ..., Clean codeLanguage: Java 8 or above, PL/SQL Multithreading, concurrent programming...
- Overview Languages English Education Bachelor's degree Experience 2 years to less than 3 years Tasks Evaluate daily operations Plan and organize daily operations Plan for changes to schedules and policies Prepare reports for senior management ...
- ...transformation. GBTO se distingue de ses concurrents par la rapidité de la transformation agile menée, la diffusion d’une culture technologique et data, l’accélération de la prise de décision et l’adoption d’une véritable approche industrielle, en s’appuyant sur différentes équipes,...Daily paid
- Drive warehousing sales at Charger Logistics Inc. using contract logistics expertise, client relationships, and tailored supply chain solutions.As Business Development Manager–Warehousing, you will grow contract logistics, warehousing, and fulfillment business. The role focuses...Contract work
- Business Intelligence and reporting lead this Data Analyst role at Tata Consultancy Services, with EDH, SQL, and Informatica supporting trusted insights. The work... ...capabilities include SQL, Informatica, EDH, data warehousing, and data modeling. You will validate data, document...
- ...principles of Price have never changed – business integrity, first-class service, innovation... ...part of that. Job Summary A Business Analyst (BA) acts as the connector between business... ...requirements, user stories, basic data requirements, and business rules • Conduct...Work at office
- ...Paradigm has opportunities for Data Analyst to employ their knowledge, skills and techniques to deliver and implement initiatives and enable our customers to maximize their investments in their business processes and information technology . The role will be based onsite...Contract workRemote work
- ...Analyst Technical Solutions seeks a skilled data warehousing/BI professional to design, develop and test ETL processes, reports and dashboards for EOIS data. The role emphasizes Oracle SQL/PLSQL, Informatica mappings, Crystal Reports and BOE reporting within an SDLC/Agile environment...
- ...are modernising our core platform, investing seriously in our data, and building AI solutions that help us achieve alpha for our clients... ...the platform, data and AI to work as one. As a Data Business Analyst, you sit at that point. You will work across the Investment, Operations...Long term contract
- Are you an experienced Business Analyst ready to make an impact?Working with one of our top financial clients, this role calls for a Business Data Analyst. This position involves supporting internal development projects focused on building enterprise data and AI solutions,...
- ...lives. Discover how you can make a difference in the lives of individuals, families and communities around the world. The Business Data Analyst plays a critical role in driving data-informed decision-making across Canadian Operations and setting the standard for...
- Job Title: Finance Business & Data AnalystLocation: Montreal, Qc (Hybrid — Minimum 3 Days Onsite/Week, One of Which Must Be Monday And/or Friday... ...(DQRs) across platforms.WHO ARE WE LOOKING FOR A hands-on analyst who can write SQL, build and deploy data quality rules, and...Work at officeMonday to friday3 days per week
$80k - $90k per year
...’ll be one of the pioneers shaping this transformation. You’ll join a robust and rapidly growing client success team. As a Business Data Analyst, you’ll be responsible for working directly with clients in face-to-face virtual or in-person meetings, analyzing client operations...Casual workWork at officeFlexible hours- We are looking for a detail-oriented Business Data Analyst to join our team supporting the Azure Data Warehouse environment. In this role, you will serve as the critical link between business stakeholders and the technical team. You will be responsible for understanding...
- Cloud Data Engineer shaping dimensional warehouses, dbt transformations, and AI-ready analytics for Kindsight’s fundraising intelligence products.This hands-on role builds and maintains the data platform behind customer-facing analytics products. You will transform lake data...
$71k - $100k per year
...Your Moneris Career - The Opportunity We are looking for a Business Data Analyst to join our analytics team and help deliver data-driven insights across product performance, customer onboarding, operational efficiency, and business reporting. In this role, you will work with...RemplacementWork at officeLocal areaRemote workFlexible hours- Lead Oracle PL/SQL development using advanced SQL, query optimization, and data integration for a long-term opportunity. Apply deep database expertise to complex applications... ...warehouses and support ETL developmentTranslate business requirements into technical designsRequirements:...Long term contract
- ...Paradigm has opportunities for Business Analysts (Intermediate or Senior) to employ their knowledge, skills and techniques to deliver and implement initiatives and enable our customers to maximize their investments in their business processes and information technology....Full timeContract workRemote work
- ...build lasting careers. We welcome bold ideas and reward initiative.We are looking for a driven and results-oriented Business Development Manager– Warehousing to join our expanding team. In this role, you will be responsible for growing our contract logistics, warehousing...Long term contractContract work
$70 - $75 per hour
Business Data Analyst (Capital Markets)Recruit Action inc. Hybrid Toronto-based role. We’re hiring three experienced professionals to support... ...scope alignment, stakeholder communication). Proven data warehousing & modeling experience (logical/physical, facts/dimensions,...Hourly payPermanent employmentFull timeContract workWork at officeWeekday work$111k - $129k per year
Job Description Business Analyst – Data Warehouse & BI Reporting Job Summary The Business Analyst – Data Warehouse & BI Reporting serves as... ...requires strong analytical capability, a solid grasp of data warehousing concepts, and experience supporting business intelligence...Work at officeRemote workHome officeFlexible hours$85k - $95k per year
...Description RESPONSIBILITIES: Integrated Role Scope: Sales Data Stewardship owns Sales data definitions, quality expectations, source... ...Reporting and Analytics Liaison: Clarify reporting requirements, business questions, audiences, frequency, filters, KPIs, and acceptance...Permanent employment- Use SQL, data profiling, and stakeholder engagement to strengthen analytics requirements... ...Wealth Management data solutions.This Business Analyst bridges business and technical teams... ...Business Analyst experienceStrong data warehousing and ETL understandingWorking knowledge of...
- ...Business Intelligence Analyst Location: Winnipeg, MB (Onsite) Turning Information into Business Intelligence. Driving Better Decisions. ODRA... ...uses information. This is not a traditional research or data-entry position. Success in this role requires curiosity, critical...Full timeFor contractors
- ...Approximately 2 weeks after request issuanceWork Hours: 8:30 AM to 4:30 PMLanguage: French and EnglishBusiness Analyst – Data Mapping The Data Mapping Business Analyst supports the definition and validation of matching rules between source system data and the target...Remote work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Business Analyst - Pl/Sql, T-Sql & Data Warehousing. Be the first to apply!
Related searches
- business data analyst Winnipeg, MB
- financial reporting analyst Winnipeg, MB
- data analyst internship Winnipeg, MB
- remote data analyst part time Winnipeg, MB
- data analyst volunteer Winnipeg, MB
- stage data analyst Winnipeg, MB
- work from home data analyst Winnipeg, MB
- data analyst excel Winnipeg, MB
- senior data analyst Winnipeg, MB
- junior data analyst Winnipeg, MB

