Alleare Consulting - Richardson, TX

This job posting is no longer available on Alleare Consulting. Find similar jobs: Senior Database Architect jobs - Alleare Consulting jobs


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 - 20 months ago - save job - block
Recommended Jobs
Architect 1
Bank of America - Addison, TX
Bank of America - 7 days ago

Enterprise Architect
Collabera - Plano, TX
Collabera - 19 hours ago

Business Solutions Lead Architect
Lennox International - Richardson, TX
Lennox International - 3 days ago