Full-Time
Data Warehouse Architect
Arete Technologies
No salary listed
East Lansing, MI, USA
In Person
Category
 Data & Analytics (2) |
|---|
| , |
Required Skills
Bash
SQL
RDBMS
ETL
Linux/Unix
Requirements
- Five or more years of Teradata physical modeling and indexing techniques.
- Teradata physical modeling and indexing.
- Teradata ETL development.
- UNIX / Linux shell scripting.
- Unix / Linux operating system.
- Teradata SQL.
- Teradata security.
- ETL tools - Datastage.
- BI inquiry tools including Business Objects, BI-Query.
Responsibilities
- Designs, implements and supports data warehousing.
- Implements business rules via stored procedures, middleware, or other technologies.
- Defines user interfaces and functional specifications.
- Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse.
- Knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning.
- Demonstrated problem resolution skills with team of persons, and strong leadership with implementation team.
- Experience in data warehouse design and data modeling (both relational and dimensional) and development and maintenance of multi-dimensional data models.
- Development experience in implementation of data warehousing utilizing RDBMS.
- Understanding of data warehouse Metadata concepts, tools and different data warehouse methodologies.
- Expertise in SQL and proficiency in database tuning techniques.
- Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments.
- Develop strategies for flexibility and scalability, and define the future technical architecture direction for the business intelligence reporting physical environment.
- Responsible for proper selection of appropriate hardware, software, tools and system lifecycle techniques for the different components of the end-to-end data warehouse architecture including ETL, metadata, data profiling software, database platform, performance monitoring, reporting and analytic tools.
- Defining and documenting the technical architecture of the data warehouse, including the physical components and their functionality.
- Setting or enforcing standards and overall architecture for data warehouse systems.
- Monitoring the data warehousing industry and assisting in establishing the organization's data warehousing strategy and section of strategic warehousing tools and techniques.
- Ensuring compatibility of the different components of the DW architecture and ensuring alignment with broader IT strategies and goals.
- Ability to educate the project teams on the standards and architecture of each component of the data warehouse architecture.
- Very strong written and oral communication skills, including some presentation skills.