Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

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
Vacancy posted 2 hours ago
Similar jobs that could be interesting for youBased on the Data Business Analyst - Pl/Sql, T-Sql & Data Warehousing in Winnipeg, MB vacancy
  •  ...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... 
    Suggested
    Work at office
    Flexible hours

    Fidelity International

    Winnipeg, MB
    6 days ago
  • $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... 
    Suggested
    Full time
    Internship
    Flexible hours

    Colliers

    Winnipeg, MB
    2 hours ago
  • 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.... 
    Suggested
    Permanent employment
    Contract work
    Flexible hours
    1 day per week

    Altis Technology

    Winnipeg, MB
    2 hours ago
  • 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 ...
    Suggested

    Tec Truck 2011 Ltd.

    Winnipeg, MB
    9 days ago
  •  ...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... 
    Suggested
    Work at office

    Price Industries Limited

    Winnipeg, MB
    6 days ago
  • 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

    Charger Logistics Inc.

    Winnipeg, MB
    2 hours ago
  •  ...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... 

    Societe Generale SA

    Winnipeg, MB
    2 hours ago
  • 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... 

    Tata Consultancy Services Limited

    Winnipeg, MB
    2 hours ago
  •  ...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

    Société Générale

    Winnipeg, MB
    2 hours ago
  •  ...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 work
    Remote work

    paradigmconsulting

    Winnipeg, MB
    3 days ago
  • Maîtrisez SQL et PL/SQL comme Analyste-programmeur Oracle chez Desjardins, en contribuant à des solutions informatiques adaptées aux besoins d’affaires. Votre expertise soutient le développement, les essais et l’évolution d’applications d’envergure.Vous participez à la conception... 

    Federation Caisses Desjardins

    Winnipeg, MB
    2 hours ago
  •  ...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 time
    Contract work
    Remote work

    paradigmconsulting

    Winnipeg, MB
    3 days ago
  •  ...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

    ORBIS Corporation

    Winnipeg, MB
    2 hours ago
  • 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,... 

    BeachHead

    Winnipeg, MB
    2 hours ago
  • 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 office
    Monday to friday
    3 days per week

    HireTalent

    Winnipeg, MB
    2 hours ago
  • $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 work
    Work at office
    Flexible hours

    RideCo Inc.

    Winnipeg, MB
    2 hours ago
  •  ...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... 

    Sun Life

    Winnipeg, MB
    2 hours ago
  • 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

    ThoughtStorm

    Winnipeg, MB
    2 hours ago
  •  ...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 contract
    Contract work

    Charger Logistics Inc.

    Winnipeg, MB
    2 hours ago
  •  ...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 time
    For contractors

    ODRA Road Sweepers

    Winnipeg, MB
    8 days ago
  • $111k - $129k per year

    Job DescriptionBusiness Analyst - Data Warehouse & BI ReportingJob SummaryThe Business Analyst - Data Warehouse & BI Reporting serves as a key member of the scrum...  ...strong analytical capability, a solid grasp of data warehousing concepts, and experience supporting business... 
    Work at office
    Remote work
    Flexible hours

    Fidelity Canada

    Winnipeg, MB
    2 hours ago
  • 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... 

    Fidelity Canada

    Winnipeg, MB
    2 hours ago
  •  ...monitors Engineering reports through PowerBi, ensuring that it is modeled by a common data structure that satisfies the functional requirements of the area, and supports overall business objectives. Supports the optimization of business systems internal to Engineering and... 
    Full time
    Internship
    Immediate start

    New Flyer

    Winnipeg, MB
    5 days ago
  •  ...discover your way forward.YOUR MAIN RESPONSIBILITIES As part of the Corporate Effectiveness team, you will act as a Business Analyst in a context focused on data value creation, the evolution of business intelligence, and the deployment of artificial intelligence. You will... 
    Long term contract
    Permanent employment
    Full time
    Fixed term contract
    Internship
    Remote work
    Work visa
    Flexible hours

    GIRO Inc.

    Winnipeg, MB
    2 hours ago
  • Job RequirementsOver 8+ years of strong Business Analysis experience, analytical skills and Database experience Over 8+ years of strong...  ...datamismatches across databases (Snowflake, Oracle, PostgreSQL, BigQuery).Data Quality & Reconciliation Tools: Hands-on experience with DQ and... 
    Long term contract

    Virtusa Corporation

    Winnipeg, MB
    2 hours ago
  •  ...products ( The founding principles of Price have never changed – business integrity, first-class service, innovation and a commitment to...  ...for an experienced and solution-oriented Intermediate Business Analyst to join our team in supporting cross-functional initiatives that... 
    Work at office

    Price Industries Limited

    Winnipeg, MB
    2 days ago
  •  ...The Business Data Analyst is responsible for analyzing, mapping, validating, and supporting the migration of client data during core banking system conversions. This role serves as a critical liaison between clients, project teams, and technical resources to ensure accurate... 
    Remote work

    BanQsi

    Winnipeg, MB
    2 hours ago
  •  ...commitment to innovation, precision, and partnership in the investment data space. Our global footprint now spans multiple countries,...  ...of product, data, and engineering.Rather than a typical Business Analyst position, this role is hands‑on — you’ll work directly with data... 
    Manual labor
    Visa sponsorship
    Flexible hours

    Style Analytics

    Winnipeg, MB
    2 hours ago
  • Turn business data into clear decisions as a Business Operations Analyst in Surrey, British Columbia, working fully on-site with Microsoft Excel and dashboards.At Savaria and Garaventa Lift, this analyst supports the Vice President and business areas through reporting, analysis... 

    Savaria

    Winnipeg, MB
    2 hours ago
  • Shape enterprise data governance in Toronto through SQL, data modelling, and stakeholder requirements, with a hybrid schedule including Thursdays onsite weekly.As a Data Business Analyst, you will support a global Data and AI team within a leading professional services organization... 

    Altis Technology

    Winnipeg, MB
    2 hours ago

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!