Data Warehouse Developer
Dept of Alcoholic Beverage Control - Richmond, VA

This job posting is no longer available on Virginia Jobs. Find similar jobs:Data Warehouse Developer jobs

VA ABC's mission is to control the distribution of alcoholic beverages; operate efficient, conveniently located retail outlets; enforce the laws of the Commonwealth pertaining to alcoholic beverages and youth access to tobacco products; and provide excellent customer service, a reliable source of revenue, and effective public safety.

The Information Technology Services Division is searching for individuals seeking a dynamic, challenging work environment with experience using Agile software development practices that are interested in helping to develop and solidify our growing adoption of Agile. If you're looking for a friendly, flexible work environment with lots of challenges, look no further!


Creating dimensional (star/snowflake schema) data models.

Maintaining responsibility for global data definitions used in the Data Warehouse.

Performing ETLs and validating results with business representatives.

Integrate data from multiple source systems into Data Warehouse.

Cleansing data.

Transforming and loading data in Oracle 11G environment.

Building ROLAP/MOLAP solutions.

Adhering to standards for the Data Warehouse, including security, archiving, backup and recovery.

Participating in architectural decisions for data transitions from source to staging to ODS to EDW.

Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.

Minimum Qualifications
Knowledge/Skills Required:

Experience with Unix /Linux platform and SQL, PL/SQL programming (Data Staging running on Lunix platform).

Experience with Unix scripting preferred (Korn shell, chron tab scheduler).

Extensive experience in complete life cycle of DW projects and able to provide end to end solutions.

Able to work closely with supporting teams to develop integrated solutions (Legacy Systems, Web Methods, FTP, DBA's, etc).

Experience and understanding with Data Modeling (powerdesigner/ERWIN tool preferred) and Dimensional Modeling.

Experience with Data Warehouse ROLAP/MOLAP and reporting technologies ( Business Objects, OBIEE, Crystal).

Working knowledge of Kimball framework and Methodologies.

Familiarity with unstructured data warehousing.

Preferred Qualifications
Preferred Qualifications:

5+ years of experience in a Decision Support/Data Warehousing/Business Intelligence environment.

College degree or higher ( I really like to say Bachelors Degree in Computer Science, Engineering or a related technical discipline, or the equivalent combination of education, technical training)

Familiarity with Agile Software development.

Working knowledge of OBIEE and/or SAP BO.

Working knowledge of OWB.

Special Requirements