BI Architect

Pune, Bengaluru
March 25, 2026
Full Time
Apply Now

Job Description

We are looking for an experienced BI Architect to design and implement scalable Business Intelligence and Data Warehouse solutions. The ideal candidate will have strong expertise in analytics architecture, ETL processes, data modeling, and visualization tools.

Job Details

  • Role: BI Architect
  • Industry Type: Software Product
  • Department: Data Science & Analytics
  • Employment Type: Full Time, Permanent
  • Role Category: Business Intelligence & Analytics
  • Experience: 6–12 Years
  • Education: Bachelor’s in Computer Science / Data Science / Related field

Key Responsibilities

🏗️ BI Architecture & Data Warehouse Design

  • Design scalable BI and Data Warehouse solutions
  • Develop analytics architecture using tools like Power BI and Tableau
  • Translate business requirements into technical BI solutions

🔄 Data Integration & ETL

  • Manage ETL processes using SQL Server Integration Services
  • Oversee data extraction, transformation, and loading
  • Ensure data consistency and reliability

🧠 Data Modeling & Database Management

  • Create analytical data models
  • Write complex SQL queries and stored procedures
  • Handle joins, cursors, and transformations
  • Work with databases such as:
    • Snowflake
    • PostgreSQL
    • Redshift
    • MongoDB

📊 Visualization Development

  • Build interactive dashboards and reports
  • Follow data visualization best practices
  • Optimize reporting performance

⚡ Performance & Governance

  • Optimize BI solutions for scalability
  • Implement data governance and quality standards
  • Ensure compliance and accuracy

👥 Collaboration & Leadership

  • Gather requirements from stakeholders
  • Mentor junior BI developers
  • Guide analytics best practices

Required Skills & Qualifications

  • 6–12 years in BI architecture and development
  • Strong expertise in:
    • SQL Server
    • Data Warehousing
    • ETL processes
  • Experience with:
    • Power BI
    • Tableau
    • SSIS
  • Python for:
    • Data analysis
    • Automation
  • Knowledge of CRISP-DM model
  • Experience with version control and code quality

Technical Skills

Programming & Analytics

  • Python (Pandas, NumPy, PySpark)
  • SQL
  • JSON, CSV, Parquet

Data Engineering & Pipelines

  • Airflow for ETL orchestration
  • Data pipeline automation

Cloud & Infrastructure

  • AWS (S3, Lambda)
  • Azure Databricks

Visualization Tools

  • Power BI
  • Tableau
  • QuickSight
  • Plotly / Dash

Preferred Skills

  • Azure SDK experience
  • REST API integration
  • Web scraping capabilities
  • Advanced cloud analytics knowledge

Key Skills

BI Architecture, Data Warehouse, SQL, SSIS, Power BI, Tableau, Python, Data Modeling, ETL, Analytics.

Related Jobs