I am specifically looking for SQL developers. The work will entail ETL into a Microsoft SQL 2008/2014 environment (using SSIS). All our processes, data and delivery execution happen in SQL as well as data interrogation and QA. Once we have completed the delivery requirements we extract and load the data sets to internal or external FTP.

The individuals will thus obviously need to be proficient in MSSQL, ETL processes, SSIS, Visual Studio and Excel. Some Cognos capability will be advantageous. Potential resources will need to pass a logic based assessment (at least 70%) as well as a SQL assessment (at least 80%) before consideration. Each of these assessments is an hour (2 hours for both).

Job Purpose
Provide expertise to acquire, manage, process, load, merge, manipulate, extract and analyze large amounts of data, from various sources. Analysis of bureau & internal data. Monitoring of previous campaigns to refine current processes and further enhance client deliveries. The person will be responsible for interpreting user requirements, developing SQL code, data processing through various software solutions, and ensuring that a consolidated, concise database infrastructure is maintained on a SQL 2008/2014 platform, operating on Microsoft Server 2008, all the while, maintaining the dynamic and evolving process of customer deliveries, support and service.
Key Responsibilities
? _To develop, monitor and maintain a suite of databases to enhance and utilize the data more effectively.
? _To implement strategic and tactical segmentation of customer bases for marketing and analysis.
? _To improve understanding of customer behavior.
? _Maintain contacts with external centers of statistical expertise in order to keep in touch with technical developments and to actively promote the application of best practice techniques.
? _Understands Credit Bureau Data, geo-demographic, Deeds data, and other spatially-based data.
? _Thoroughly prepare data – Retrieving, Combining and Validating Data, from multiple sources. Strong ability to recognize data errors and inconsistencies.
? _Application of agreed rules and processes to extract the relevant information for client marketing campaigns / initiatives.
? _Maintains multiple databases of campaign history and generic data, and feedback files from clients.
? _Initiate process changes and enhancements where necessary and see to successful implementation.
? _Communicate findings and results by means of presentations, and written communication, both internally and externally.
? _Ability to identify trends in information, and recommend actions or alternatives to the findings.
? _Importing, cleaning, transforming, authenticating or modeling data with the purpose of understanding and making sound deductions from the data for decision making purposes.
? _Refining data quality and designing or presenting conclusions gained from analyzing data using statistical tools like Microsoft Excel and others.