BI Data Warehouse Architect

Unclassified - Carlsbad, CA

Full-time

Carlsbad, CA

About the position

The Business Intelligence Data Warehouse Architect is responsible for the design, implementation, and maintenance of the Data Warehouse ecosystem. This role involves managing Extract Transform Load (ETL) processes, utilizing Data Modeling Tools, Oracle Database, and MicroStrategy for reporting. The architect will ensure effective communication between different systems and support the enhancement of current Business Intelligence systems while managing data-related risks according to internal policies.

Responsibilities

• Write technical Extract Transform Load documents.
• Monitor and administer the Data Warehouse batches during critical implementations and maintenance windows to ensure optimal operation of the system.
• Help in the on-call rotation to support the Business Intelligence applications 24/7.
• Ensure adherence to company standards and best practices for development activities.
• Design changes, provide solutions, and manage additions to the Enterprise Data Warehouse and Data Marts using standard data modeling tools.
• Perform Oracle Structured Query Language (SQL) optimization on existing database queries.
• Identify database requirements by meeting with other Information Technology teams; analyze department applications, programming, and operations; evaluate existing systems and design proposed solutions.

Requirements

• 5-7 years of active senior practical experience in Business Intelligence and data management roles
• 7+ years of data integration experience
• 5+ years of data modeling experience using industry standard tools (such as Erwin, ER/Studio, Visio or Enterprise Architect)
• 5+ years of experience in software development
• 4+ years of experience with Oracle databases 10g and 11g, SQL, PL/SQL and SQL for data manipulation and performance tuning
• 5+ years of experience with large, complex integrated data warehouse environments
• 3+ years developing and tuning Oracle SQL
• 5+ years of Business Intelligence implementations with Dimensional Data Models, integrating data from various sources and providing analytical reporting to business users using MicroStrategy or other BI tools