Data Architect (India)

About Epsilon Technologies Group :

Epsilon is a capital markets technology solutions and services firm helping financial institutions manage everything on their balance sheet with a scalable and innovative product line as well as our highly experienced and independent consulting services.

Epsilon is looking for a hands-on Data Architect who will design, build, and deploy data-centered solutions including data sourcing, validation, transformation, analysis and presentation. This pivotal role will actively engage with both onshore and offshore teams.

To find out more, visit https : / / www.epsilontg.com

About the Role :

We're seeking an experienced Data Architect to design, build, and maintain enterprise-scale data solutions. This role combines strategic data architecture with hands-on technical delivery, requiring the candidate who can translate business objectives into robust, scalable data platforms while maintaining the highest standards of data governance.

What You Will Do :

• Design and implement end-to-end data delivery solutions from acquisition through analysis, visualization, and decision support
• Data acquisition and scoping and preparation to validation, transformation, through analysis into visualization, insights, and decision support models
• Design and implement scalable ETL / ELT processes using tools such as Matillion, Fivetran, SAP BI, Trifacta, and custom SQL and Python scripts
• Analyze existing architecture diagrams, data dictionaries, lineage documentation, and system integration maps to quickly and thoroughly assess and document existing data infrastructure, pipelines, and dependencies across complex enterprise environments
• Layout the foundations of data architecture to meet business objectives, project budgets and timelines, and client’s technology goals and constraints
• Lead data discovery, scoping, model development, and presentation efforts
• Present architectural designs for peer and client review, responding thoughtfully to challenges and feedback
• Incorporate regulatory compliance, data governance, and data quality standards into all designs
• Optimize effectiveness and efficiency considering data volumes, refresh frequency and platform capabilities across the end-to-end data stack
• Design and implement Materialized Views in Snowflake to pre-compute and store complex aggregations, joins, and transformations that are frequently accessed by business users and reporting systems
• Leverage Snowflake Dynamic Tables for automated, continuously refreshed data pipelines that maintain up-to-date aggregated datasets without manual orchestration
• Design and implement end-to-end data delivery solutions from acquisition through analysis, visualization, and decision support
• Data acquisition and scoping and preparation to validation, transformation, through analysis into visualization, insights, and decision support models
• Design and implement scalable ETL / ELT processes using tools such as Matillion, Fivetran, SAP BI, Trifacta, and custom SQL and Python scripts
• Analyze existing architecture diagrams, data dictionaries, lineage documentation, and system integration maps to quickly and thoroughly assess and document existing data infrastructure, pipelines, and dependencies across complex enterprise environments
• Layout the foundations of data architecture to meet business objectives, project budgets and timelines, and client’s technology goals and constraints
• Lead data discovery, scoping, model development, and presentation efforts
• Present architectural designs for peer and client review, responding thoughtfully to challenges and feedback
• Incorporate regulatory compliance, data governance, and data quality standards into all designs
• Optimize effectiveness and efficiency considering data volumes, refresh frequency and platform capabilities across the end-to-end data stack
• Design and implement Materialized Views in Snowflake to pre-compute and store complex aggregations, joins, and transformations that are frequently accessed by business users and reporting systems
• Leverage Snowflake Dynamic Tables for automated, continuously refreshed data pipelines that maintain up-to-date aggregated datasets without manual orchestration

What We Are Looking For :

Why Join Us :

Location and Working Hours :

Remote, India. Availability to work in UK hours (13 : 30 – 22 : 30 pm IST) is required. Occasional work after hours and on weekends is required to complete assigned projects, support production deployment and assist clients on production issues