Dharamvir Singh
Dharamvir Singh

Data Architect

Actively looking · Member since 18 Sep 2026
Location
Delhi, India
Desired salary
Unspecified
Work preference
Remote Only
Experience level
Lead

About

Professional summary

I am a Data Architect and enterprise data strategy professional with over 15 years of experience designing, governing, and scaling enterprise data platforms. My career has progressed from software engineering and data analysis to hands-on technical leadership in data architecture.

I specialize in conceptual, logical, and physical data modelling, dimensional modelling, enterprise data standards, and modern cloud data architecture. I have designed and governed Snowflake, AWS, and Azure data platforms that support scalable analytics, warehousing, integration, and lakehouse workloads.

I build reliable ETL and ELT solutions, data warehouses, migrations, and analytics-ready data products. My hands-on experience includes DBT, Python, SSIS, AWS DMS, Airflow, Snowflake, and cloud-native data services, along with BI enablement through Power BI, Tableau, SSRS, and SSAS.

I have led enterprise data governance initiatives covering RBAC, data quality, metadata management, data cataloguing, and regulatory compliance. I work closely with business, analytics, operations, marketing, and IT stakeholders to translate requirements into governed and scalable architecture.

I also have experience architecting agentic AI applications that combine LLM-based reasoning, real-time data, API and tool integrations, workflow automation, and messaging channels. As a technical leader and SME, I mentor engineers and analysts, drive delivery standards, and communicate architecture decisions effectively to both technical teams and senior stakeholders.

Skills

35 capabilities

Tech stack & tools

Working toolkit

Experience

Career history

Data Engineer Royal Bank of Scotland

Architected and scaled an enterprise Snowflake-based data platform, defining target architecture, conceptual, logical, and physical data models, and enterprise data standards. The platform supported fivefold data growth and improved processing performance by 20%.

Co-led data strategy and governance initiatives covering governance policy, RBAC, data quality, and metadata and catalog management. Designed ETL/ELT pipelines, data warehousing, and migration solutions using dbt, Python, SSIS, and AWS DMS, improving pipeline efficiency by 25%.

Partnered with BI, analytics, operations, and business teams to deliver scalable architecture and expand Power BI and Tableau adoption, producing $200K in cost savings. Served as a data architecture SME, led mentoring for engineers and analysts, and guided architectural reviews, performance improvements, and compliance initiatives.

Created bank-wide Test-Driven Development and Trunk-Based Development frameworks adopted across more than 10 applications, improving code quality, release safety, and delivery efficiency.

Technical Lead IB Technology

Led the design and implementation of data solutions spanning BI modelling, data warehousing, ETL processes, and data governance. Developed scalable architecture scenarios focused on data integration, data quality, and analytical data modelling.

Implemented data mining solutions to extract insights from large datasets for strategic decision-making. Worked with stakeholders to gather requirements and deliver business intelligence solutions aligned with organizational needs.

Analyst Bank of America

Performed advanced data analysis to identify trends, patterns, and actionable insights that supported data-driven decisions across business functions. Designed, implemented, and optimized ETL/ELT pipelines to improve data accuracy, completeness, integrity, scalability, and performance.

Developed enterprise reports and interactive dashboards using SSRS and Tableau, increasing accessibility to key business metrics. Collaborated with cross-functional stakeholders to convert complex business requirements into governed, analytics-ready data solutions.

Software Engineer Porteck Info Services

Contributed to the development of healthcare management software solutions, with a focus on data integration and workflow automation.

Collaborated directly with clients to understand requirements and customize solutions to their operational needs. Provided technical support and troubleshooting for software issues.

Software Engineer Iteamic Solutions

Designed and developed web-based applications for multiple clients using C#. Developed stored procedures, reports, and application components using SSRS and SSIS.

Worked closely with project managers and stakeholders to deliver high-quality software solutions on schedule and within budget.

Software Engineer One97 Communications Pvt Ltd

Contributed to the development of mobile applications and services, focusing on UI design and backend development.

Collaborated with cross-functional teams to implement new features and enhancements while maintaining application performance and user experience.

Education

Learning history

UP Technical University

Master of Computer Applications, Computer Applications

Master of Computer Applications (MCA).

This professional hasn’t added portfolio projects yet.

This professional hasn’t listed any services yet.

People also viewed

All talent ›
Jobs Talent AI Tools Salaries
Menu