Data Warehouse & Business Intelligence Engineer

Agility Software Solutions - Sacramento, CA

Full-time

Sacramento, CA

Publishing Industries

About the position

The Data Warehouse & Business Intelligence Engineer role focuses on designing, developing, and maintaining data warehouse solutions, with a strong emphasis on business intelligence infrastructure. The position requires extensive experience in data warehousing concepts, architectures, and methodologies, particularly within the state of California.

Responsibilities

• Design and implement data pipelines to capture data from multiple sources.
• Develop methods for system recovery strategy, failure detection, and data recovery.
• Design, implement, and maintain end-state data repositories including Data Lake, Data Pools, and both virtual and physical Data Warehouse Architecture.
• Perform ETL transformations and manage various schema dimensional types, including star, galaxy, and snowflake.
• Design, implement, and maintain Artificial Intelligence (AI) solutions.

Requirements

• Minimum of 12 years of experience in data warehousing and business intelligence.
• Proven experience in database management, data modeling, and database schema design.
• Strong knowledge of data warehousing concepts, architectures, and methodologies.
• Experience in building flexible and scalable business intelligence infrastructure.