Available to hire
Hi, I’m Gaurav Singla, a data consultant with 20+ years of experience in architecting and implementing large-scale, cloud-native data platforms. I specialize in building data lakes and lakehouses on AWS, designing medallion data layers, and crafting scalable ingestion frameworks. I’m proficient in Kimball and Inmon dimensional modeling and enjoy turning complex data into actionable insights.
I’ve collaborated with AWS product teams to improve Glue and Lake Formation for enterprise governance, and I’ve led data platform initiatives from ingestion to governance, lineage, and observability. I’m comfortable with the full stack—from Lambda, DMS, Glue, Kinesis, S3, and Redshift to Snowflake, dbt, Python, and Terraform—while always focusing on security, cost-efficiency, and business value. I thrive working with cross-functional teams to deliver data products that support operations, compliance, and strategic decision-making.
Skills
Work Experience
Data Consultant at Convex Insurance
October 1, 2023 - November 22, 2025Delivered ingestion pipelines for Slips, Endorsements, and Settlement documents into internal applications, enabling downstream consumption by Policy Administration and Credit Control systems for reconciliation, premium tracking, and regulatory reporting. Designed and implemented AWS-based ingestion workflows using Lambda, S3, EventBridge, and DuckDB, ensuring data quality, validation, and audit compliance. Developed Snowflake- and DBT-based transformations to standardize premium-related fields. Applied synthetic masking techniques to protect PII and sensitive data during migration and downstream use. Collaborated with finance, actuarial, and underwriting teams to align ingestion models with PAS migration and WAQS quota share objectives under Lloyd’s Syndicate 1984. Integrated with core Lloyd’s and London Market platforms like PPL, DDM, Whitespace, and broker APIs for seamless document processing.
Data Architect at RX Global
September 30, 2023 - September 30, 2023Led the data lake project and accountable for data initiatives including data quality, pseudo anonymization, data migration, and governance within the global business solutions. Designed the technical architecture for the data platform using a data fabric framework, guiding data engineers to deliver solutions aligning with business information needs. Built end-to-end data lake on AWS analytics stack enabling analysts to generate actionable insights. Architected data flows from internal and external applications into the AWS Data Lake using batch, real-time, and event-driven pipelines. Established a governance model covering data classification, quality, cataloguing, and management to support data security and privacy policies. Implemented DBT-based data integration, migrated on-prem Oracle data to Snowflake, and introduced Apache Hudi to support transactional data lake use cases. Led data quality initiatives using Talend DQ and Melissa.
BI/Data Architect at Acrotrend
November 30, 2014 - November 30, 2014Liaised with stakeholders for requirement gathering, planning, and prioritization; developed end-to-end solution architecture design documents; planned sprints and tracked delivery; created data models using ERStudio; designed the staging layer and enterprise data warehouse following the Oracle reference architecture; built dimensional models (star/snowflake), data marts, slowly changing dimensions, OLAP/OLTP; documented technical requirements and designs; implemented architectural designs while maintaining strong stakeholder relationships.
BI Tech Lead at IBM
January 31, 2010 - January 31, 2010Managed a team of developers delivering BI applications; defined architecture designs based on business requirements; developed ETL programs using Informatica to implement the business requirements; ensured timely releases; configured the BI presentation layer, data security, and repository settings.
Lead Consultant at Oracle SSI
May 31, 2009 - May 31, 2009Delivered GAP analysis, defined scope during Define Phase; produced high-level business requirement documents and technical design documents for BI reporting; developed mappings/sessions using Informatica PowerCenter for data loading; provided business analysis support and technical guidance to customers.
Senior Developer at Accenture
December 31, 2007 - December 31, 2007Hands-on experience delivering efficient and cost-effective technical solutions to meet customer business requirements; led all stages of system development, including requirements, design, development, testing, and support; performed CRM module configuration, migration, and integration tasks including Siebel Config, scripting, Workflow, EAI and EIM.
Lead Data Consultant at RX Global
September 30, 2023 - September 30, 2023Tech Lead for Data Lake project accountable for data quality, pseudo anonymization, data migration, and other data initiatives within the global business solutions. Designed technical architecture for the data platform using data lakehouse architecture and built AWS-based data lakehouse with Glue, Lake Formation, Athena, and EMR to support analytics workloads. Defined data ingestion frameworks (batch, streaming, event-driven) improving data availability for global analytics by 60%. Delivered performance improvements by optimizing Parquet compression and partitioning strategies, reducing query latency by 30%. Led migration of legacy Oracle workloads to Snowflake and S3-based lakehouse with CDC and reconciliation mechanisms. Led data flow design from internal and external applications into the AWS Data Lake using various ingestion patterns. Established data governance model encompassing data classification, data quality, data cataloguing, and data management to complement policies. Imple
BI Tech Lead at IBM, India
January 31, 2010 - January 31, 2010Managed a team of developers delivering BI applications. Responsible for architecture designs based on business requirements, development of ETL programs using Informatica, and ensuring timely releases. Configured presentation, business, and data layers with security and performance considerations.
Lead Consultant at Oracle SSI, India
May 31, 2009 - May 31, 2009Delivered GAP analyses and contributed to the Define Phase. Produced high-level business requirements and technical design documents for BI reporting. Developed mappings/sessions using Informatica PowerCenter for data loading and provided business/technical guidance to customers.
Senior Developer at Accenture, India
December 31, 2007 - December 31, 2007Developed and delivered efficient BI solutions to meet customer requirements. Led all stages of system development efforts including requirements, design, development, testing, and support. Focused on CRM module configuration including Siebel, scripting, workflow, EAI, and EIM.
Education
Qualifications
Executive MBA (Information Technology)
January 11, 2030 - November 22, 2025Bachelor of Engineering in Electronics and Telecommunication
January 11, 2030 - November 22, 2025AWS Big data Architect
January 11, 2030 - November 22, 2025TOGAF 9.2 certified
January 11, 2030 - November 22, 2025AWS Solution Architect
January 11, 2030 - November 22, 2025Executive MBA (Information Technology)
January 11, 2030 - November 22, 2025Bachelor of Engineering in Electronics and Telecommunication
January 11, 2030 - November 22, 2025AWS Big Data Architect
January 11, 2030 - November 22, 2025TOGAF 9.2
January 11, 2030 - November 22, 2025AWS Solution Architect
January 11, 2030 - November 22, 2025Industry Experience
Financial Services, Professional Services, Software & Internet
Skills
Hire Gaurav Singla today
To get started post up your job and then invite Gaurav Singla to your job.