AI Enabled Data Architect - Business Intelligence

Description :

Experience Level : 5-8 Years.

Location : Pune office.

Joining : Immediate or up-to 1 months notice.

Summary :

We are seeking an experienced AI-Enabled Data Architect & BI Lead with deep expertise in Microsoft SQL Server, Azure Data Services, Power BI, and .NET technologies.

You will design and implement scalable, intelligent, cloud-native data solutions that power advanced analytics and decision-making.

This role blends data engineering, BI architecture, and AI integration, requiring hands-on experience with SQL Azure, Azure Data Factory, SSIS, Power BI, and .NET Core for end-to-end solution delivery.

You will leverage AI-assisted tools such as GitHub Copilot, ChatGPT, and Azure AI Studio to accelerate development, automate workflows, and deliver smarter, faster outcomes.

As a technical leader, you will design data models, build ETL pipelines, and develop analytical dashboards and AI-driven insights, collaborating closely with data engineers, developers, and business stakeholders to deliver enterprise-grade analytics solutions.

If you are passionate about uniting data architecture, business intelligence, and applied AI in a collaborative Agile environment, this role offers the opportunity to shape the next generation of intelligent data platformswith a strong focus on delivering high-quality, secure solutions for healthcare applications.

Key Responsibilities :

• Translate business and functional requirements into data architecture and design blueprints, serving as the Technical Architect and Lead Developer for BI, data warehousing, and AI-integrated analytics solutions.
• Design and implement optimized data models, OLAP cubes, star / snowflake schemas, and slowly changing dimensions for analytics and reporting.
• Build and maintain Azure Data Factory pipelines and SSIS packages for high-performance data ingestion, transformation, and orchestration.
• Develop advanced Power BI dashboards and reports using DAX, role-based security, and embedded analytics; integrate AI / ML models to automate insights.
• Implement robust data validation, governance, and security frameworks to ensure reliability, scalability, and compliance.
• Develop and maintain .NET APIs and microservices to securely expose and integrate enterprise data.
• Collaborate with cross-functional teams and continuously explore Azure AI, Power BI, and .NET innovations to improve platform intelligence and performance.

Qualifications :

Skilled in :

Perks & Benefits :

(ref : hirist.tech)