AI Enabled Data Architect

Job Description 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. (ref:hirist.tech)