Solution Architect

Shashwath Solution; Pune District; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Shashwath Solution is seeking a Solution Architect Data Engineer to design and manage data solutions for the insurance sector. You will leverage Cognos, DB2, and Azure Databricks to enable analytics and reporting across finance, underwriting, claims, and customer service.

The role involves leading ETL pipelines, data modeling, and governance while collaborating with cross-functional teams to deliver scalable, compliant data platforms.

Qualifications

• Bachelor's or Master's in Computer Science, Information Systems, or related field.
• Proven experience as a Solution Architect or Data Engineer in insurance.
• Hands-on Cognos and DB2 expertise.
• Proficiency with Azure Databricks for data processing and ML.
• Extensive ETL development and data integration experience.
• Strong Python and SQL skills.
• Experience with cloud platforms (Azure) and hybrid environments.

Responsibilities

• Design and implement scalable data architectures in the insurance domain.
• Lead ETL development and optimize data pipelines.
• Oversee Cognos reporting and dashboards across finance, underwriting, claims, and ops.
• Build data models, pipelines, and databases for BI and analytics.
• Develop data solutions on Azure Databricks and ensure integration with existing systems.
• Write and optimize complex SQL queries for data extraction and reporting.
• Ensure data governance, quality, and regulatory compliance.
• Collaborate with stakeholders to translate business needs into technical solutions.

Skills

Cognos

DB2

Azure Databricks

ETL

SQL

Python

Power BI

Tableau

Education

Bachelor's or Master's in CS/IS

Tools

Cognos

DB2

Azure Databricks

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.

Keywords :sql,python,machine learning,data transformation,cognos,etl development,azure databricks,data integration,dbms,data processing,etl process,tableau,power bi,etl,microsoft azure,reporting tools,aws,data architecture,cloud infrastructure,Azure Data Lake*