Job Details

Business Intelligence Architect

San Francisco, CA | Full time

Job ID:



Long Term


7-10 years

Career Level:

Senior Level




Information Technology and Services

Job Description

  • Leads technical project team and responsibilities using project management standards and methodologies. Develops project management artifacts and documentation.
  • Define, capture and document metadata and rules associated with ETL processes, Develop and test ETL processes
  • Work with end users, business analysts, technical team, and developers to define the data requirements and data structure for BI solutions
  • Makes recommendations to improve operational processes relative to efficiency and effectiveness; provides input and organizational context to major architectural designs to ensure consistency, maintainability and flexibility with respect to overall system.
  • Utilizes data-mining skills and business knowledge to convert raw data into solutions that provide clear and concise insights into the health of the business
  • Design and implement conceptual and logical models for the data warehouse or data mart (data structure, storage, and integration). Lead the database analysis, design, and build efforts.
  • Designs, develops, implements, and supports highly complex BI applications of strategic or functional importance for an enterprise audience including: integration with data sources; highly automated data refresh processes; best-in-class data visualizations, dashboards, and reports that communicate critical insights to drive decision making; testing methodology and criteria to ensure data/information quality; delivery of training and demos to business users.

Required Experience

  • 8+ years of experience in data warehouse/BI intelligence architecture, design and development. Significant experience as BI/DW architect on several BI/DW initiatives / projects.
  • Experience in BI development using the Microsoft Power BI platform
  • Excellent understanding of Microsoft Power platform (Power Apps, Power Automate, Power BI) and other Microsoft BI platforms (SSRS, SSAS, etc.)
  • Experience with Microsoft Business Intelligence reporting and analytical tools (SSIS, SSAS, SSRS, and SQL Server). Knowledge of other commercial or Open Source tool sets is an asset (SAS, Tableau, etc…)
  • Expert data modeler who can define transformed schemas and cubes for analytics use
  • Extensive SQL programming skills and solid understanding of relational databases and data architectures in one or more vendor product: Oracle, SQL Server, PostgreSQL, RDS, Aurora, etc
  • Self-starter who is able to take ownership and thrive in an independent environment and drive teams through technology change
  • Strong experience with ETL tools such as SSIS and SAS, as well as familiarity with standard data extract, de-duping, cleansing, integration, and aggregation techniques and best practices
  • Strong project management skills with high attention to detail on data and a strong focus on meeting deliverables with time limitations - must have ability to multitask and prioritize

Similar Jobs