Solution Architect

Shashwath Solution; Dadri; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

Shashwath Solution is seeking a Solution Architect/Data Engineer to design robust data platforms for the insurance sector. You will lead data architecture, ETL pipelines, and Cognos reporting, enabling advanced analytics across finance, underwriting, claims, and customer service.

The role requires hands-on experience with Cognos, DB2, and Azure Databricks, plus strong SQL/Python skills. You will collaborate with cross-functional teams and ensure data governance and regulatory compliance.

Qualifications

• Bachelors or Masters degree in Computer Science, Information Systems, or a related field.
• Proven experience as a Solution Architect or Data Engineer in the insurance industry with data solutions focus.
• Hands-on Cognos (reporting/dashboarding) and DB2 database management experience.
• Proficiency in Azure Databricks for data processing and analytics.
• Extensive ETL development, data integration, and data transformation experience.
• Strong Python and SQL scripting, with performance-oriented query optimization.
• Experience with cloud platforms (Azure) and hybrid on-prem/cloud environments.
• Knowledge of data governance and regulatory requirements in insurance (e.g., Solvency II, IFRS 17).
• Excellent communication and collaboration with business stakeholders.

Responsibilities

• Design scalable data architectures for the insurance domain.
• Lead ETL pipelines across sources, ensuring data quality and performance.
• Oversee Cognos reporting systems and develop custom dashboards for business users.
• Build and maintain data models, pipelines, and databases for BI and analytics.
• Develop data solutions on Azure, integrating with DB2 and legacy systems.
• Write and optimize complex SQL for data extraction and reporting.
• Ensure data governance and compliance across all data solutions.
• Collaborate with stakeholders, data scientists, and analysts to deliver insights.
• Provide architectural leadership and scalable, cost-effective solutions.
• Monitor and tune database and ETL performance to meet SLAs.
• Create comprehensive technical documentation and data dictionaries.

Skills

Cognos

DB2

Azure Databricks

Python

SQL

ETL development

Data governance

Cloud platforms

Analytics

Education

Bachelor's or Master's in Computer Science / Information Systems

Tools

Cognos

DB2

Azure Databricks

Python

SQL

Azure

Power BI

Tableau

Job description

The Solution Architect Data Engineer will design, implement, and manage data solutions for the insurance business, leveraging expertise in Cognos, DB2, Azure Databricks, ETL processes, and SQL.

The role involves working with cross-functional teams to design scalable data architectures and enable advanced analytics and reporting, supporting the company's finance, underwriting, claims, and customer service operations.

Key Responsibilities:

• Data Architecture & Design: Design and implement robust, scalable data architectures and solutions in the insurance domain using Azure Databricks, DB2, and other data platforms.
• Data Integration & ETL Processes: Lead the development and optimization of ETL pipelines to extract, transform, and load data from multiple sources, ensuring data integrity and performance.
• Cognos Reporting: Oversee the design and maintenance of Cognos reporting systems, developing custom reports and dashboards to support business users in finance, claims, underwriting, and operations.
• Data Engineering: Design, build, and maintain data models, data pipelines, and databases to enable business intelligence and advanced analytics across the organization.
• Cloud Infrastructure: Develop and manage data solutions on Azure, including Databricks for data processing, ensuring seamless integration with existing systems (e.g., DB2, legacy platforms).
• SQL Development: Write and optimize complex SQL queries for data extraction, manipulation, and reporting purposes, with a focus on performance and scalability.
• Data Governance & Quality: Ensure data quality, consistency, and governance across all data solutions, implementing best practices and adhering to industry standards (e.g., GDPR, insurance regulations).
• Collaboration: Work closely with business stakeholders, data scientists, and analysts to understand business needs and translate them into technical solutions that drive actionable insights.
• Solution Architecture: Provide architectural leadership in designing data platforms, ensuring that solutions meet business requirements, are cost-effective, and can scale for future growth.
• Performance Optimization: Continuously monitor and tune the performance of databases, ETL processes, and reporting tools to meet service level agreements (SLAs).
• Documentation: Create and maintain comprehensive technical documentation including architecture diagrams, ETL process flows, and data dictionaries.

Required Qualifications:

• Bachelors or Masters degree in Computer Science, Information Systems, or a related field.
• Proven experience as a Solution Architect or Data Engineer in the insurance industry, with a strong focus on data solutions.
• Hands-on experience with Cognos (for reporting and dashboarding) and DB2 (for database management).
• Proficiency in Azure Databricks for data processing, machine learning, and real-time analytics.
• Extensive experience in ETL development, data integration, and data transformation processes.
• Strong knowledge of Python, SQL (advanced query writing, optimization, and troubleshooting).
• Experience with cloud platforms (Azure preferred) and hybrid data environments (on-premises and cloud).
• Familiarity with data governance and regulatory requirements in the insurance industry (e.g., Solvency II, IFRS 17).
• Strong problem-solving skills, with the ability to troubleshoot and resolve complex technical issues related to data architecture and performance.
• Excellent verbal and written communication skills, with the ability to work effectively with both technical and non-technical stakeholders.

Preferred Qualifications:

• Experience with other cloud-based data platforms (e.g., Azure Data Lake, Azure Synapse, AWS Redshift).
• Knowledge of machine learning workflows, leveraging Databricks for model training and deployment.
• Familiarity with insurance-specific data models and their use in finance, claims, and underwriting operations.
• Certifications in Azure Databricks, Microsoft Azure, DB2, or related technologies.
• Knowledge of additional reporting tools (e.g., Power BI, Tableau) is a plus.

Key Competencies:

• Technical Leadership: Ability to guide and mentor development teams in implementing best practices for data architecture and engineering.
• Analytical Skills: Strong analytical and problem-solving skills, with a focus on optimizing data systems for performance and scalability.
• Collaborative Mindset: Ability to work effectively in a cross-functional team, communicating complex technical solutions in simple terms to business stakeholders.
• Attention to Detail: Meticulous attention to detail, ensuring high-quality data output and system performance.

Mandatory Key Skills:

• ETL development
• SQL
• data governance
• machine learning
• Microsoft Azure
• Solution architecture
• Data engineering
• Cognos Reporting
• DB2
• Azure Databricks
• Python*