Canada DBA Job


DBA Resources



Developer / Data Analyst - AXIS Database Marketing, INC

More Database and SAP Jobs in Mississauga , Ontario

Company Profile:

AXIS Database Marketing, INC - Mississauga , Ontario; AXIS Integrated™ was founded in 1996 by our current President—Michael Booth—to deliver world class marketing and sales database driven solutions for mid-tier and large Canadian Corporations. Over the years AXIS has evolved into a leader in providing our Clients with end-to-end business process outsource solutions; Past job postings: Developer / Data Analyst ; DBMS: SQL Server, SAP Business Objects; Career Opportunities .

Job Description :

AXIS Database Marketing Group Inc. 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 :
  • 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

Other Requirements (e.g. travel, overtime) 

  • The position will involve some overtime including weekends, especially during implementation phases of projects
  • Must be able to pass Enhanced Security Clearance with RCMP


  • Intensive training in SAP Business Objects Data Services
  • On-going training and professional development is encouraged

Please send resume to with "IT013 - Developer / Data Analyst" in the subject line.

No attachments other than Microsoft Word or Acrobat PDF will be accepted. You can also copy and paste your resume and cover letter into the E-mail body.

Please provide cover letter and resume.

Last updated on September 12, 2011