Data Warehouse Developer

Overview

Allied Consultants, Inc. is an Austin-based firm which has for 33 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Data Warehouse Developer to be a key resource on a technical services team.

 

Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law.  Offers of Employment are contingent on a successful background checkAllied Consultants is an equal opportunities employer.

Responsibilities

The Worker(s) will provide the following services:

Designing the data structures needed to meet the business requirements. Ensuring database development standards are followed. Providing specifications for data quality. Documenting the “as-is” schemas currently in use at client. Performing other analysis and documentation tasks as required to facilitate and support client’s Enterprise Data Warehouse. Work is accomplished in a highly collaborative environment. May also work independently with minimal supervision and be required to meet tight deadlines. Perform other duties as assigned to maintain operations.

Qualifications

 

Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements(skills/experience) will not be considered for this opportunity.

Years ( leave no blanks)

Years

Skills/Experience

 

 

1-3

Hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc., preferably Oracle

 

 

1-3

Experience with Oracle PL/SQL

 

 

1-3

Hands-on experience with data modeling preferably in a data warehouse environment

 

 

1-3

Experience with Informatica product suite in the Informatica cloud

 

 

1-3

Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities

 

 

1-3

Communication, analytical and interpersonal skills at all levels

 

 

1-3

Technical writing skills

 

 Preferred:

 

 

Years

Skills/Experience

 

 

3

More than one type of RDBMS (DB2, SQL Server, Oracle)

 

 

2

Experience in Public Sector delivery

 

 

2

Experience writing dynamic SQL

 

 

 

Client Experience