Business Consultant

3 weeks ago

Canada, CA Apex Systems Full time

Business Consultant- Data Analysis

  • The individual will assist the Client Data team with the following: Analyze, query and manipulate data according to understand currently defined business rules and procedures.
  • Analyze current state data quality controls to design specification (source-to-target) and expected/anticipated behaviors, identifying quality issues and recommending solutions
  • Assist in the design of quality edit checks, test plans, etc. to ensure data quality objectives are met, as well as participate in cross-functional team engagement
  • Provide accurate and appropriate interpretation of data, applying knowledge to evaluation, analysis, and interpretation of data
  • Provide support for analysis and research into our client data structure, maintenance, performance, and modelling.
  • Assist in defining, understanding and implementing the policies & standards for cloud native data as it pertains to structured, semi- and unstructured data so that it aligned to the the role that is defined by enterprise data governance for migrations from cloudera native data management to Azure, with focus on client data domain
  • Analyze data for compliance to design specification (Prem-to-Azure) and expected/anticipated behaviors, identifying quality issues and recommending solutions
  • Develop complex data quality audits using SQL to identify possible data issues coming into Purview, abstract data, and clearly summarize and present data
  • Collaborate with database developers to improve data collection and storage processes during migration from Prem to cloud to Identify incorrect data, documenting issues, patterns and gaps in the data and/or system
  • Document data process flows to support data sourcing & lineage Data Modelling methodologies & tools
  • Manage documentation related to data quality (data standards, definitions ( technical and business), DQ documents such as metadata, data dictionaries, checklists, guidelines, manuals, etc.)
  • Build, update and maintain dashboards that report on key data quality metrics related to banks client data domain
  • Ensures data integrity by implementing quality assurance practices, gathering and entering missing data, and resolving anomalies.
  • Assist in tracking, mining, and analyzing data to recommend KPI's for client data domain in order to build Data Quality Rules & KPIs
  • Evaluating system performance and design within Purview, as well as its effect on data quality.
  • Perform root cause analysis on data issues and make long term recommend on data quality controls to resolve gaps/issues and suggest ways to improve systems and database designs.
  • Running data queries to identify coding issues and data exceptions, as well as cleaning data.
  • Facilitate Data cleansing and enrichment through data de-duplication and construction
  • Performs logical edit checks on the data and reviews trends in the data to identify potential errors.
  • Performs other related quality control tasks to identify discrepancies and violations.
  • Performs quality control activities on the collected data, requests clarifications as appropriate.
  • In-depth knowledge of data quality testing in order to verify the accuracy and completeness of information within various systems with Purview
  • Perform ad-hoc Data extraction and archival; Managing Data life-cycle




Knowledge/Technical Skills:

Expertise in using Hadoop, Spark, Pig, Hive technologies, Data Ingestion in Data Lake, Data Storage on key Cloud providers (Azure), Data Retrieval on Big Data platforms and Interfacing Data Science and Data Visualization tools on Big Data platforms.

  • A good overview of Azure cloud technologies: Hands on with Azure Cloud tool like Purview, Azure Data factory, Azure Data Bricks, ADLS and overall Azure cloud
  • Comprehensive understanding of Data Modeling, Big Data Platforms (e.g. Cloudera, Azure, etc.), Data Migration and Quality (using ETL e.g Informatica, DataMirror Alteryx ), MySQL/NoSQL, Linus Scripts
  • Proficient in data migration between different sources / targets on-prem and Cloud, of varying data repository technologies, DB2, Oracle, SQL Server and Data Lakes
  • Data Warehouse knowledge/experience
  • Knowledge of banking regulations and procedures, data management processes and database-related technical skills.
  • Must Have strong data management and governance skills knowledge i.e. Knowledge of theories, principles, and methods utilized in the development of data quality improvement metrics
  • Sound knowledge current and emerging data management and analysis methods.
  • Knowledge of best practices in data analysis. i.e. Advance understanding of the collection and management of metadata (as it relates to the governance of data and data quality)
  • Design and develop dashboards and data visualizations that tell a story from complex data using tools such as Alteryx, Power BI, Tableau
  • Sound to advanced knowledge of banking standards, infrastructure, architecture and technology from a design/support/ solutions perspective.



Experience

Proven track record of having built / improved data governance processes supporting data transformation, data structures, metadata, data quality controls, dependency and workload management.

  • Experience with Data Management, Data Governance, or Data Quality. Proven experience of having worked and data quality skills in:
  • Data Profiling, quality rules definition
  • Data Discovery
  • Data quality measurement and metric generation, and aggregation into quality performance indicators
  • Root cause analysis
  • Good knowledge of data quality concepts, data quality trends and other tools in market such as Alteryx, Data Mirror, Milo
  • Skills in data profiling and data analysis
  • Expertise in developing KPI’s and business rules related to data quality
  • Ability to work with Technical and Non-Technical business owners
  • Experience in working with Azure Cloud Data Analytics
  • Data Warehouse Tools
  • Data Conversion & Migration
  • Master Data Management
  • Metadata Management
  • Data Management and Integration during migration projects
  • Experience and knowledge with data quality life cycle, data trending, dashboard and reporting with tools such as Cognos, PowerBI and Tableau, Data Mesh concepts
  • Hands on working experience in dealing with large volume data quality analysis, data profiling, data masking, transformation & cleansing, data extraction & loading from heterogeneous data sources to Cloud e.g: data tokenization, standardization, matching and validation
  • Experience with data quality and ETL technologies, programming and tools such as Informatica Data Quality, Data Mirror or OEDQ
  • Experience with data quality and data migration principles and best practices
  • Experience and knowledge with Azure Cloud Computing, Azure Service Model (e.g. IaaS, PaaS) and Azure storage technologies
  • Successfully have examined complex data to optimize the efficiency and quality of the data being collected, resolve data quality problems, and collaborate with database developers to improve systems and database designs.
  • Should have experience with, and understanding of, implementing and measuring Data Quality and Controls

  • ServiceNow Business Process Consultant

    1 week ago

    Canada, CA Alldus Full time

    Alldus International are hiring for multiple ServiceNow Business Process Consultant Positions.Positions are open for those with experience in any of the following areas: ITOM, CSM, OMT, Team Lead.Positions are open to those residing in Canada and working proficiency in FRENCH Is a MUST.As a ServiceNow Business Process Consultant Team Lead the role and...

  • Business Process Consultant

    3 weeks ago

    Canada, CA Raso360 Full time

    Business Process ConsultantJob Overview:We are looking for an experienced Business Process Consultant to join our team, with a strong focus on IT Service Management (ITSM). The ideal candidate will have experience in analyzing, designing, and optimizing business processes, particularly within the ITSM domain. This role requires strong client-facing skills,...

  • Business Operations Consultant

    3 months ago

    Canada, CA Breakthrough Academy Full time

    BUSINESS OPERATIONS CONSULTANTDo you have valuable business and leadership experience that you could teach to business owners?Do you have a track record of building a successful business or growing a strong division within a company?Are you an intrapreneur at heart who naturally gravitates towards people and loves to facilitate conversations?Are you...

  • Nonprofit NetSuite Functional Consultant

    1 month ago

    Canada, CA Business Process Management, Inc. Full time

    Caravel BPM Technology Solutions – where caring and community is in our company DNA, we are always striving to be our best selves and we’re compelled to ask the questions that lead to innovation. As a Nonprofit NetSuite Functional Consultant, you will:Lead the implementation and configuration of NFP-specific modules in NetSuite, such as Fund Accounting,...

  • Business Sales Consultant

    4 weeks ago

    Canada, CA Rogers Communications, Inc. Part time

    Business Sales ConsultantOur company was built on the dream of a pioneering entrepreneur, and that spirit continues to empower our work with businesses across Canada today. The Rogers Business team helps organizations of all sizes adapt, scale, and win with network services and other innovative technology solutions that are reliable, secure, and scalable....

  • Business Sales Consultant

    1 month ago

    Canada, CA Rogers Communications, Inc. Full time

    Business Sales ConsultantOur company was built on the dream of a pioneering entrepreneur, and that spirit continues to empower our work with businesses across Canada today. The Rogers Business team helps organizations of all sizes adapt, scale, and win with network services and other innovative technology solutions that are reliable, secure, and scalable....

  • Business Sales Consultant

    3 weeks ago

    Canada, CA Rogers Communications, Inc. Part time

    Business Sales ConsultantOur company was built on the dream of a pioneering entrepreneur, and that spirit continues to empower our work with businesses across Canada today. The Rogers Business team helps organizations of all sizes adapt, scale, and win with network services and other innovative technology solutions that are reliable, secure, and scalable....

  • Microsoft Business Central Consultant

    2 weeks ago

    Canada, CA IDOM USA Full time

    ABOUT THE JOBWe are looking for a Microsoft Business Central Consultant to join our Digital Transformation team.Job Summary:Responsible for:Definition of the Microsoft Business Central solution implementation roadmap and organize the work plan.To give technical support in evaluating if the User Requirements can be implemented with a standard system...

  • Business Development Consultant

    1 month ago

    Canada, CA La Esperanza Child Development Center, LLC. Full time

    INTERESTED IN OWNING AFRANCHISE OF YOUR OWN?INTERESTED IN OWNING AFRANCHISE OF YOUR OWN? View our currently available job postings today by clicking here . Operations Business Development Consultant – Thai Express Business Development ConsultantLocation: Montreal, QCAre you passionate about the restaurant industry and would you like to work in a dynamic...

  • Business Sales Consultant

    3 weeks ago

    Canada, CA Rogers Communications, Inc. Full time

    Our company was built on the dream of a pioneering entrepreneur, and that spirit continues to empower our work with businesses across Canada today. The Rogers Business team helps organizations of all sizes adapt, scale, and win with network services and other innovative technology solutions that are reliable, secure, and scalable. These solutions are built...

  • Senior Consultant

    2 months ago

    Canada, CA LevelUp Finance - An Array Company Full time

    Position: Senior Consultant - Financial & Operational Business Intelligence / Data EngineerLocation: Remote in CanadaExperience:At least 5 years of experience using SQL & Power BI in the workplace.Experience with accounting/finance, sales operations, or other data-intensive business operations is a plus.Experience in planning applications (e.g., Adaptive,...

  • Environmental Consultant

    1 month ago

    Canada, CA AWN Consulting Ltd. Full time

    AWN Consulting is a multidisciplinary environmental consultancy that provides environmental, air quality, acoustics, and risk management services to industrial and public sector clients throughout Ireland and in Europe. As a subsidiary of Trinity Consulting Inc., a prominent US-based multinational environmental consultancy, AWN is at the forefront of...

  • Consulting Sales Executive

    1 month ago

    Canada, CA Voiant Group Full time

    Voiant is a global consultancy specializing in strategic Sales Planning and Data Management. With our expertise in Revenue Operations and extensive industry experience, we deliver custom solutions that guarantee reliable outcomes, maximizing our clients' investment value. Our approach integrates technology and data proficiency with collaborative,...

  • PLM Consultant

    3 weeks ago

    Canada, CA Equal Parts Full time

    Join to apply for the PLM Consultant role at Equal Parts.Are you ready to take on a role within a dynamic team of technology consultants? Cre8tive Technology & Design is seeking a Product Lifecycle Management Consultant to drive the implementation of best practice processes using Pro.File by Revalize. Join us in revolutionizing the way manufacturers operate...

  • WFM Services Consultant

    1 month ago

    Canada, CA Dayforce Corporation Full time

    Dayforce is a global human capital management (HCM) company headquartered in Toronto, Ontario, and Minneapolis, Minnesota, with operations across North America, Europe, Middle East, Africa (EMEA), and the Asia Pacific Japan (APJ) region.Our award-winning Cloud HCM platform offers a unified solution database and continuous calculation engine, driving...

  • NetSuite Principal Consultant Vursor · ·

    1 month ago

    Canada, CA Vursor is a trading division of SystemsAccountants Inc. Full time

    Do you have NetSuite consulting experience, and are you seeking a new role for a growing North American Alliance Partner? If so, we'd love to hear from you! Vursor is looking for a skilled NetSuite Principal Consultant, and the full-time role comes with an attractive salary and benefits package.As a Principal Consultant, you will manage and coordinate...

  • Policy Consultant

    1 month ago

    Canada, CA DMF Energy Inc. Full time

    Policy Consultants are primarily responsible for planning, organizing and leading portions of an engagement. They are responsible for ensuring the quality of client deliverables and serve as competent, effective members of client delivery project teams. Completing and managing client work in accordance with established budgets, workplans, quality...

  • Technical Consultant

    3 months ago

    Canada, CA InterEx Group Full time

    Job Title: D365 Technical ConsultantLocation: Remote (based in Canada)We are seeking a highly skilled and experienced D365 Technical Consultant with a strong understanding of the PowerPlatform. The ideal candidate will have experience with Javascript and be proficient in PowerPages. Knowledge of C# is a bonus.Responsibilities:Work closely with clients to...

  • Research Consultant

    1 month ago

    Canada, CA DMF Energy Inc. Full time

    Research Consultants are primarily responsible for planning, organizing and leading portions of an engagement. They are responsible for ensuring the quality of client deliverables and serve as competent, effective members of client delivery project teams. Completing and managing client work in accordance with established budgets, workplans, quality...

  • Environmental Consultant

    3 weeks ago

    Canada, CA AWN Consulting Ltd. Full time

    AWN Consulting is a multidisciplinary environmental consultancy that provides environmental, air quality, acoustics, and risk management services to industrial and public sector clients throughout Ireland and in Europe. As a subsidiary of Trinity Consulting Inc., a prominent US-based multinational environmental consultancy, AWN is at the forefront of...