AI-Enabled Data Architect

About Us

Founded in 2015, Touchcore Systems is a mid-sized IT company providing software solutions and services in the healthcare space. We are a team of engineers and designers building innovative and cutting-edge software solutions. We are a people-centric organization where we aim to not only make profits but create a space that motivates people to be creative and give their    best at work. We offer a suite of healthcare products and services that aim to improve quality of care and outcomes for patients.

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 platforms—with 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:

a. Bachelor's degree in Computer Science, Information Systems, Information Technology, or equivalent combination of education and relevant experience

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

c. 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.

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

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

f. Skilled in .NET / C# development for backend API and microservice design, data integration, and business logic implementation, with experience building end-to-end solutions using React/Angular (preferred), .NET backend, and SQL-based data services.

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

h. 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.

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

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

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

Perks & Benefits

Management's 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.