Technical and BI Architect

  • Sacramento, CA
  • Posted 2 days ago | Updated 2 days ago

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 24 Month(s)

Skills

Data Warehouse
architecture
application development
database management
operations
BI architecture
DevOps
Generative AI
AI application development
SQL Server
Snowflake
AWS Redshift
Informatica
AWS Glue
Talend
Power BI
Tableau

Job Details

Position Summary:

The Technical and Business Intelligence Architect (Tech & BI Architect) will lead the design, architecture, and implementation of Company s enterprise BI and Data Warehouse solutions. The role requires expertise in data warehouse lifecycle management, cloud-based BI/analytics, DevOps, and Generative AI. The Architect will serve as a subject matter expert, guiding cross-functional teams, ensuring best practices, and enabling knowledge transfer to internal staff.

Key Responsibilities:

  • Design and build AI infrastructure and applications, with a focus on Generative AI.

  • Architect and implement BI & DW solutions including data modeling, ETL, and reporting frameworks.

  • Develop and optimize CI/CD pipelines on AWS or Azure cloud platforms.

  • Define and enforce BI standards, guidelines, and best practices.

  • Collaborate with BI Developers, Data Architects, and Analysts to deliver reporting and analytics solutions.

  • Provide technical governance on cloud architectures, deployments, and operations.

  • Contribute to DevOps development activities ensuring scalable and maintainable solutions.

  • Identify and manage technical risks and dependencies, documenting impacts and mitigation strategies.

  • Deliver weekly/monthly project status reports and maintain alignment with schedules.

  • Lead knowledge transfer sessions to internal staff to ensure sustainability.

Minimum Qualifications:

  • 10+ years of hands-on experience with full lifecycle Data Warehouse design & development (logical/physical modeling, ETL, metadata, reporting).

  • 5+ years of experience spanning at least two IT disciplines (architecture, application development, database management, operations, etc.).

  • 5+ years experience in BI architecture design and predictive analytics on cloud-based DW platforms.

  • 3+ years experience using DevOps toolchains and processes.

  • 1+ year experience in Generative AI architecture and AI application development.

Desirable Qualifications:

  • 10 years of experience with SQL Server, Snowflake, or AWS Redshift.

  • 3 years working with ETL tools such as Informatica, AWS Glue, or Talend.

  • 3 years of experience with visualization tools such as Power BI or Tableau.

  • Cloud Architect and AI certifications.

  • Bachelor s degree in Computer Science or related field.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Shivark Inc.