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.
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
Bachelor’s Degree in Computer Science, Information Technology or other relevant fields
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 in the following :
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 :
Digital Document Management
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
o Familiarity with architecture styles / APIs (REST, WCF, gRPC)
o Familiarity with the ASP.NET framework and .NET Core
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