HOUSTON OR RICHARDSON OFFICE
This is a position within the Development Services department of the Client Delivery Services business unit. This individual works as part of a development team designing software solutions supporting client's relationship marketing activities. Software solutions include creating and supporting data warehouses and data marts of client's customers and prospects; creating extract, transform and load (ETL) data movement processes; creating automated reports; and creating data extraction processes supporting client's marketing campaigns.
Duties / Responsibilities:
Working under general supervision or independently, this individual performs the following functions:
: Interacts frequently with Account Managers, Project Managers, and clients.
: Designs data warehouses and data marts hosted in Oracle.
: Designs data marts to support Business Intelligence reporting using Business Objects and campaigning using Unica, Epiphany other other CRM tools.
: Designs ETL processes using Informatica PowerCenter
: Assists developers with difficult Oracle PL/SQL code needed for queries, triggers, and stored procedures
: May design automated reports using Business Objects and other technologies
: Conducts reviews of developed code
: Mentors developers on established guidelines and best practices
: Diagnoses and corrects system problems
: Creates design and other system documentation in accordance with established processes and policies
Minimum Job Requirements:
: Bachelor's Degree in Computer Science, Management Information Systems, Mathematics, Engineering, or equivalent
: Eight years relevant job experience
: Interest in learning the concepts and practices, acquiring the skills, and developing the expertise needed to succeed in this position
Skill / Knowledge / Experience Requirements:
: Must possess good interpersonal skills
: Must possess good communication skills in both verbal and written English
: Must already be sufficiently competent in dimensional data modeling to design data warehouses and data marts
: Must have demonstrated expertise in core competencies of data modeling, ETL (preferably using Informatica), and SQL (preferably using Oracle PL/SQL).
: Experience with Unica, Epiphany or other CRM tools is a plus.
Alleare Consulting - 18 months ago