Solution Architect

Shashwath Solution

Dadri

On-site

INR 2,400,000 - 4,800,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

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

The role emphasizes ETL optimization, data governance, and scalable data platforms, collaborating with cross-functional teams to deliver actionable insights and robust reporting.

Qualifications

  • Bachelor's or Master's degree in a relevant field (CS/IS).
  • Hands-on experience as a Solution Architect or Data Engineer in insurance.
  • Proficiency with Cognos and DB2 for reporting and database management.
  • Proficiency with Azure Databricks for data processing, ML, and analytics.
  • Extensive ETL development, data integration, and transformation experience.
  • Strong Python and SQL skills with optimization focus.
  • Experience with cloud and hybrid data environments (Azure preferred).
  • Knowledge of data governance and insurance regulatory requirements.

Responsibilities

  • Design and implement robust, scalable data architectures in the insurance domain using Azure Databricks, DB2, and other platforms.
  • Lead ETL pipeline development and optimization for multi-source data integration.
  • Oversee Cognos reporting systems, building dashboards for finance, claims, underwriting, and operations.
  • Build and maintain data models, pipelines, and databases for BI and analytics.
  • Develop and manage Azure-based data solutions with seamless system integration.
  • Write and optimize complex SQL queries for data extraction and reporting.
  • Ensure data quality, governance, and regulatory compliance (GDPR, Solvency II, IFRS 17).
  • Collaborate with stakeholders, data scientists, and analysts to translate business needs into technical solutions.
  • Provide architectural leadership to design scalable data platforms and cost-effective solutions.
  • Monitor and tune performance of databases, ETL processes, and reporting tools to meet SLAs.
  • Create and maintain technical documentation including architecture diagrams and data dictionaries.

Skills

Python
SQL
ETL development
Data architecture
Cloud platforms (Azure)
Cognos knowledge
Data modeling
GDPR IFRS17 awareness

Education

Bachelor's or Master's degree in Computer Science / Information Systems or related field

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 the 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…

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*

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Solution Architect
Solution Architect

Shashwath Solution • Pune District

On-site
INR 1,800,000 - 3,000,000
Solution Architect (Data & Analytics)
Solution Architect (Data & Analytics)

Dynatech Systems • Ahmedabad

Hybrid
INR 1,800,000 - 3,200,000
Data Solution Architect
Data Solution Architect

C5i • Bengaluru, Mumbai

On-site
INR 4,200,000 - 6,400,000
Data Solution Architect
Data Solution Architect

EPAM Systems Inc • Chennai District

On-site
INR 3,500,000 - 6,000,000
Data / Solutions Architect
Data / Solutions Architect

Syren Cloud Inc. • Hyderabad

On-site
INR 1,500,000 - 2,500,000
Solution Architect - Insurance
Solution Architect - Insurance

Coforge Limited • Greater Noida

On-site
INR 3,500,000 - 5,000,000
Data Engineer / Data Architect
Data Engineer / Data Architect

Cognizant • Chennai Metropolitan Area

Hybrid
INR 3,000,000 - 4,800,000
Solutioning Lead – Data Solutions Architect
Solutioning Lead – Data Solutions Architect

EXL • Maharashtra

On-site
INR 400,000 - 700,000
Solutioning Architect - Insurance Domain
Solutioning Architect - Insurance Domain

Coforge Limited • Greater Noida

On-site
INR 3,000,000 - 5,000,000
Solutioning Lead – Data Solutions Architect
Solutioning Lead – Data Solutions Architect

ExlService Holdings, Inc. • Pune District

On-site
INR 420,000 - 680,000