Wednesday, August 07, 2013

Regional Transportation District - Data Architect

Hiring Range: $80,000 - $106,724 - $133,400

This position is responsible for design and architecture of relational databases for data storage and processing and will require participation in the creation and ongoing updates to the Business Intelligence strategy roadmap, developing and documenting strategies for an enterprise data warehouse implementation, data acquisition, data quality and archive recovery.

Duties & Responsibilities:

- Designs the overall enterprise data architecture, data governance strategies and data quality standards.
- Designs and implements an enterprise data warehouse infrastructure including data marts, data models/dimensions and meta data registry.
- Must understand functionality, scalability, performance, security, and integration requirements for an enterprise business intelligence platform.
- Develops, documents and maintains a formal description of the data and data structures.
- Develops entity and attribute descriptions and definitions for the models and ensures that conflicts in descriptions and definitions are resolved.
- Analyzes performance statistics and performs required tuning activities.

Qualifications:

- Bachelor's degree in Engineering, MIS, Computer Science, Mathematics, Statistics or related field.
- A minimum of seven years of Enterprise Data Warehouse (EDW) experience in dimensional modeling/data warehousing, developing data integration plans, engineering and managing hardware and software architectures and ensuring compatibility and optimal integration of multiple systems.
- A minimum of five years experience in planning, developing, and supporting ETL systems to achieve data transformation goals including the design and architecture of operational data stores to support enterprise data integration goals.
- A minimum of five years experience with Business Intelligence tools such as Oracle Business Intelligence Enterprise Edition (OBIEE), Cognos, Crystal Reports and other enterprise level BI platforms and tools.
- A minimum of five years experience as a data architect involved in implementing company wide data policies, governance procedures, creating metadata repositories and working with data stewards to improve data quality.
- Experience with data mining techniques.
- Ability to work a flexible work schedule, on-call 24/7