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 :

- Bachelors degree in Computer Science, Information Systems, Information Technology, or equivalent combination of education and relevant experience.

- 5-8 years of experience in Handling Big data.

- Expertise in Microsoft SQL Server technologies, including SQL Azure, Azure Data Warehouse, Azure Data Factory, SSIS, SSRS, and SSAS, with strong hands-on T-SQL skills for developing database scripts, stored procedures, and automation.

- Proven experience in ETL architecture and development using SSIS and Azure Data Factory, with solid knowledge of data modeling, transformation, cleansing, and profiling techniques.

- Advanced proficiency in Power BI, including data modeling, DAX, MDX, KPI creation, and interactive dashboard design for enterprise analytics.

Skilled in :

- Experience integrating AI and ML models via Azure Machine Learning, Cognitive Services, or OpenAI APIs for predictive analytics, automation, and intelligent reporting.

- Practical exposure to AI pair programming tools such as GitHub Copilot, ChatGPT, and Azure AI Studio, leveraging them for faster, cleaner, and smarter code generation.

- Hands-on experience with Agile methodologies, CI/CD pipelines, and version control tools (Git, Azure DevOps), ensuring high-quality, maintainable, and collaborative delivery.

- Strong understanding of data governance, security, and compliance frameworks in cloud-based data environments.

- Excellent analytical, problem-solving, and communication skills, with a continuous learning mindset and commitment to innovation.

Perks & Benefits :

- Managements commitment to maintain work-life balance.

- Performance based bonus.

- Challenging role with meaningful impact.

- Several new initiatives will require building solutions from scratch.

- End-to-End ownership of work and ability to make independent decisions.