Peersight
Log In Employers
Navigation
My Profile Log Out

DEVELOPER / DATA ANALYST At AXIS Database Marketing

Location

Mississauga, On

Job Description

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.

Get hired at AXIS Database Marketing

You're one short application away from your dream job