DEVELOPER / DATA ANALYST
AXIS Database Marketing
Mississauga, ON
AXIS is an energetic growth company with a seasoned and progressive Management team specializing in assisting organizations with the development and implementation of CRM solutions. At the core of our web, database and custom applications is our Cleansing and Matching department. This team focuses exclusively on converting, parsing, standardizing, verifying / correcting and matching consumer and business information to create a holistic view of the client.

More specifically, our Cleansing and Matching department is focused on assisting clients in the following areas:

Enhancing the quality, relevance, and usability of their customer data
Leverage the cleansed data for analytics, marketing, and profitability
Establish metrics and targets for improvements
Implementing processes to achieve data quality targets
Design and building customer focused databases that links disparate customer records across the enterprise into unified retail and commercial views with the objective of achieving the highest customer experience across all channels
Must Have Skills
Solid understanding and experience with relational databases
Working knowledge of SQL Server Integration Services
Proficiency in writing and debugging T-SQL code
Programming knowledge in (but not limited to) C#/VB.NET/VB6
Experience with Microsoft Office (Access, Excel, and Word)
Areas of Responsibility
Participating in the analysis of Client business objectives and scoping of projects
Development using partner software including SAP Business Objects Data Services (formerly Business Objects DQXI).
Interpret functional specifications
Develop Job scripts (Build/Test)
Data Transformation & Cleansing
Parser Rules Table Development
Matching Rules Table Development
End-to-end job stream
Support in writing functional documents using pre-established templates
Development using C#/VB/SSIS or similar to build interfaces that utilize BO Data Services objects
Analysis of Customer Data Quality using Data Cleansing and Profiling Software and customized SQL Database Software (MS SQL Server, MS Access, MS Excel)
Quality Assurance Testing
Performing detailed Analysis of parsing and matching results obtained, comparing results from multiple software systems / projects
Participates in meetings with both external and internal clients
Research/knowledge improvement in best practices for Data Cleansing, Address Standardization and Customer Linking
Coordinating and applying modifications to the database with project management and development staff
Define and implement data transfer and data conversion strategies
Implement ETL processes and data flows
Maintaining existing T-SQL code and DTS/SSIS packages
General Qualifications/Assets
College or University degree in Computer Science / Mathematics or a related discipline
A minimum of 1-2 years work experience in data processing and/or database development
Ability to work in team as well as independently
Excellent analytical and problem-solving skills as well as attention to detail
Document code with detailed inline comments, and create clear external documentation as required
Good communication skills, both oral and written and ability communicate effectively with both technical and non-technical individuals
Ability to quickly learn and grasp new matching/cleansing partner software and technologies
Experience in marketing database industry and/or data cleansing and matching would be an asset
Design and development experience with SAP Business Objects Data Services a major plus
Please send your cover letter and resume to careers@axis-dbm.com. No attachments other than Microsoft Word or Acrobat PDF will be accepted. You may also copy and paste your resume and cover letter into the email body.