BI & Data Architecture Lead

BlackStone eIT; India; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

A leading IT consulting firm in India is seeking a skilled Data Architect & Business Intelligence Specialist. The role involves designing robust data architectures, implementing data pipelines, and utilizing BI tools like Power BI and Tableau. The ideal candidate should have over 5 years of experience, a degree in a related field, and expertise in SQL and cloud platforms. This position offers full-time employment with a focus on advanced data handling and analytics.

Qualifications

• 5+ years of experience in data architecture, modeling, pipelines, and BI/reporting.
• Strong expertise in SQL, data modeling, and data architecture.
• Experience with cloud platforms and data warehouse technologies essential.

Responsibilities

• Design and maintain enterprise data architecture aligned with business requirements.
• Develop ETL/ELT processes using industry-standard tools.
• Design, implement, and manage modern data warehouses.
• Build interactive dashboards and reports using BI tools.
• Develop ETL/ELT processes using Airflow, Talend, Informatica, or Azure Data Factory.
• Design and manage data warehouses (Snowflake/Redshift/BigQuery/Synapse).
• Collaborate with stakeholders to map old data structures to new architecture.
• Create dashboards and reports using Power BI, Tableau, Looker, or Qlik.

Skills

Data modeling

SQL

Data architecture

Cloud platforms (AWS, Azure, GCP)

BI/reporting tools

Data visualization

Education

Bachelor's or Master's degree in Computer Science, Information Systems, Data Engineering

Tools

Apache Airflow

Talend

Informatica

Azure Data Factory

Snowflake

Redshift

BigQuery

Synapse

Power BI

Tableau

Looker

Qlik

Job description

We are seeking a skilled and analytical Data Architect & Business Intelligence Specialist to design, model, and implement robust data architectures, pipelines, and reporting frameworks. This role will be responsible for building and maintaining data models, overseeing data migrations, and developing scalable data warehouse solutions to support business intelligence and analytics initiatives.

Key Responsibilities:

• Data Architecture & Modeling
• Design and maintain the enterprise data architecture aligned with business and technical requirements.
• Develop logical and physical data models using industry best practices.
• Establish and maintain metadata standards and data dictionaries.
• Ensure data consistency, quality, and governance across all systems.
• Design and build efficient and scalable data pipelines for structured and unstructured data.
• Develop ETL/ELT processes using tools like Apache Airflow, Talend, Informatica, or Azure Data Factory.
• Optimize data ingestion, transformation, and loading procedures to support analytics.
• Plan and execute data migration projects from legacy systems to modern data platforms.
• Ensure data integrity and minimal downtime during migration activities.
• Collaborate with stakeholders to map old data structures to new architecture.
• Design, implement, and manage modern data warehouses (e.g., Snowflake, Redshift, BigQuery, Synapse).
• Ensure high performance, scalability, and security of data warehousing environments.
• Implement data partitioning, indexing, and performance tuning techniques.
• Collaborate with business stakeholders to gather reporting and analytics requirements.
• Build interactive dashboards and reports using tools like Power BI, Tableau, Looker, or Qlik.
• Enable self-service reporting and ensure data accuracy in BI platforms.
• Monitor data usage, performance, and drive continuous improvement in reporting frameworks.

Requirements:

Education & Experience:

• Bachelor's or Master's degree in Computer Science, Information Systems, Data Engineering, or a related field.
• 5+ years of experience in data architecture, modeling, pipelines, and BI/reporting.

Technical Skills:

• Strong expertise in SQL, data modeling (3NF, dimensional, star/snowflake schemas).
• Experience with data warehouse technologies and cloud platforms (AWS, Azure, GCP).
• Proficiency in BI/reporting tools and data visualization best practices.
• Knowledge of Python, Scala, or other scripting languages is a plus.
• Familiarity with data governance, security, and compliance standards.

Soft Skills:

• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills with both technical and non-technical stakeholders.
• Ability to translate complex technical concepts into business language.

Seniority level: Mid-Senior level

Employment type: Full-time

Job function: IT Services and IT Consulting