Data Architect
Canon Business Process Services
Ortigas, Pasig City, PH
7h ago

Overview

The Intelligent Automation Division is a rapidly expanding division within Canon Business Process Services (CBPS) Professional Solutions Division (PSD) that is working in a key growth area for Canon across a significant number of clients in a variety of industries.

Its focus is to advance CBPS’ outsourcing offerings and enhance the quality of client engagements through Intelligent Automation technologies such as our Kofax Total Agility (KTA) OPMT, Kofax RPA, UIPath, PowerAutomate, Cloud Offerings and other key technologies.

Combined these technologies are referred to as Canon’s Intelligent Automation Suite (CIAS).

The Data Architect plays a critical role within the growing Data Transformation Services. In this role, you should have broad skillsets from database administration, business / operational intelligence reporting, business collaboration, and data warehouse architecture to data classification, data extraction, and custom ETL coding.

You will work with the Intelligent Automation (IA) Product and Engagement teams and CBPS’ Operations teams to identify DW-related opportunities for improvement and automation.

These engagements should help increase margins and deliver additional business value to CBPS’ top clients. The ideal candidate should have excellent communication skills with technical expertise across several areas.

If you are passionate about data modeling, business intelligence / operatonal intelligence, automation, database design, data governance, and data architecture while delivering business improvements on data systems, come and apply.

Responsibilities

  • Data modeling of large-scale data solutions, perform data architectural assessments, architectural options and analysis, finalizing preferred solution alternatives, work with IT and Business stakeholders.
  • Design and implement data warehouse, operational / business intelligence data lakes / hubs, database systems, and data warehouse architecture
  • Design and implement ETL / ELT processes using SSIS, stored procedures, custom VB / Batch processes, etc.
  • Design and generate data ETL / ELT automation scripts / templates using TSQL, PS SHELL, Windows / Unix Batch script, C# / VB Codes, etc.
  • Design and develop SQL database and DB Azure cloud access and security controls and auditing processes
  • Design and implement effective database solutions and models to store and retrieve company data.
  • Examine and identify database structural necessities by evaluating client operations, applications, and programming.
  • Assess database implementation procedures to ensure they comply with internal and external regulations.
  • Install and organize information systems to guarantee company functionality.
  • Prepare accurate database design and architecture reports for management and executive teams.
  • Oversee the migration of data from legacy systems to new solutions.
  • Monitor the database / DW system performance by performing regular tests, troubleshooting, and integrating new features.
  • Recommend solutions to improve new and existing database systems.
  • Educate staff members through training and individual support.
  • Offer support by responding to system problems in a timely manner.
  • Cultivate, maintain, and enhance systems based on business requirements using approved technologies and coding standards
  • Lead and / or assist with the creation of technical documentation, design synopsis, functional requirements, and operating procedures supporting the build-out of client solutions on the database platform
  • Provide peer review of code and planned development activities for co-workers
  • Proactive training to enhance current analytical / SQL / reporting skillsets and investigate ways to learn new proficiencies to ensure CBPS has the best solutions to offer
  • Transition knowledge to team colleagues
  • Provide DA support and direction to the internal SME’s focused on vertical solution selling, as required
  • EDUCATION

    Bachelor’s Degree in Computer Science, Information Technology or other relevant fields

    EXPERIENCE NECESSARY

  • Proficient in SQL Server technologies and Azure Cosmos DB
  • At least 5 years of data architecture and build experience with large scale solutions
  • Has experience in any of the following : SQL Server, Azure SQL Server, Cosmos DB, SQL Lite, Data Hub, Data Lake
  • Proficiency in data modeling and design, including SQL development and database administration
  • Understanding of predictive modeling, NLP and text analysis, Machine Learning
  • Ability to implement common data management and reporting technologies, as well as the basics of columnar and NoSQL databases, data visualization, unstructured data, and predictive analytics.
  • Data mining, visualization, and Machine Learning skills
  • Knowledge of programming languages TSQL, Python, C / C++, Java, and Perl
  • KNOWLEDGE

  • Knowledge in the following :
  • Data Modeling
  • Data Warehouse concepts
  • TSQL / PS / BatchScript / R Scripting
  • Predictive data analytics
  • Application database concepts
  • Database security concepts
  • Software Development Life Cycle
  • Agile / KanBan / Scrum development techniques
  • Business Process Management Notation (BPMN)
  • Workflow and technical documentation
  • Development of Business Case
  • Advantageous business line / sector experience :
  • Document Processing
  • Digital Document Management
  • Accounts Payable
  • Human Resources
  • Financial Services
  • Claims Handling
  • TECHNOLOGICAL SKILLS

  • Proficient in :
  • o Data modeling and design, including SQL development and database administration

    o Design and implementation of Reports using Power BI, Tableau, MicroStrategy

    o SQL Server installation, deployment, and monitoring

    o Predictive modeling, NLP and text analysis, Machine Learning

    o Data management and reporting technologies, as well as the basics of columnar and NoSQL databases, data visualization, unstructured data, and predictive analytics.

    o Data mining, visualization, and Machine Learning skills

    o programming languages TSQL, Python, C / C++, RScript, Java, and Perl

    o MS Teams, Slite, GitHub, BOX, Microsoft Word, Excel, PowerPoint, Visio

  • Desirable :
  • o Web frontend development / JavaScript,

    o Familiarity with architecture styles / APIs (REST, WCF, gRPC)

    o Familiarity with the ASP.NET framework and .NET Core

    BASIC QUALIFICATIONS

  • Capable of prioritizing work, meeting deadlines, and complete deliverables in an accurate and timely manner
  • Excellent written and oral communication skills
  • Team oriented, fits well into virtual and dynamic teams
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form