Business Intelligence Architect |
Daugherty Business Intelligence Architects are responsible for analysis and solution design. They lead Business Intelligence Teams and mentor architects, technical team leads and software engineers in BI-related architectural issues and best practices. Business Intelligence Architects lead Business Intelligence Roadmaps. Candidates will have completed several BI project life-cycles.
Other necessary requirements include:
- Completed Data Quality concepts such as Master Data Management, Data Governance and Data Stewardship
- Understanding of leading technologies in Business Intelligence (Teradata, ORACLE, IBM, Microsoft, etc.)
- Strong SQL skills
- Strong Data Analysis and Architect skills:
- Works in a data warehouse environment, which includes data design, data integration, database architecture, metadata and reporting creation.
- Translate business needs into long-term information architecture solution.
- Defines designs and builds dimensional databases.
- Responsible for developing data warehouse blueprints, evaluating hardware and software platforms and integrating systems.
- Evaluates reusability of current data for additional analysis.
- Conducts data quality initiative to rid system of old, unused, or duplicate data.
- Renews object and data models and the metadata reporting to structure the data for better management and quicker access.
- Strong in data modeling (Normalization, Star Schema, “The Vault”)
- Strong in data architecture (Data Warehousing, ODS, Data Marts, Staging)
- Experience in a (or multiple) CASE tools (ERwin, ORACLE Designer 2000, ER/Studio, etc.).
- Expertise in two (or more) integration tools (DTS, SSIS, Informatica, Data Stage, etc.)
- Experience in a (or multiple) OLAP tools (Analysis Services, Cognos, BO, etc.)
- Experience in a (or multiple) Reporting tools (Reporting Services, Crystal Reports, ProClarity, etc.)
Education Requirement: 4-year college degree, preferably in Computer Science or Business-related studies.
Experience Requirement: 7+ years related experience in Business Intelligence.