• Design scalable, low-latency, and highly reliable data systems • Own the architectural vision for the Market Data Lakehouse • Collaborate closely with teams to enable fast experimentation • Drive performance optimization and long-term scalability • Document architectural decisions and maintain technical roadmaps

• Design, develop, and maintain scalable data models and transformation pipelines using dbt and Snowflake. • Build and manage end-to-end data workflows, from raw ingestion to curated analytical layers. • Develop reusable, modular, and scalable transformations using Jinja and dbt macros. • Select and implement appropriate materializations based on performance and business needs. • Define and implement robust data testing strategies (generic and custom tests). • Ensure high data quality and reliability using tools such as dbt-expectations, dbt-utils, Elementary. • Collaborate with cross-functional teams to understand requirements and deliver data solutions. • Troubleshoot and resolve data quality, performance, and transformation issues. • Contribute to best practices in data modeling, version control, and CI/CD pipelines.

• Design, develop, and maintain scalable data models and transformation pipelines using dbt and Snowflake • Build and manage end-to-end data workflows, from raw ingestion to curated analytical layers • Develop reusable, modular, and scalable transformations using Jinja and dbt macros • Select and implement appropriate materializations (incremental, snapshot, table, view, ephemeral) • Define and implement robust data testing strategies (generic and custom tests) • Ensure high data quality and reliability using tools such as dbt-expectations, dbt-utils, Elementary • Collaborate with cross-functional teams (Data Analysts, Data Scientists, Engineers) to understand requirements and deliver data solutions • Troubleshoot and resolve data quality, performance, and transformation issues • Contribute to best practices in data modeling, version control, and CI/CD pipelines

• Collaborate with stakeholders and source data system teams to understand data requirements • Architect and implement scalable workspace, data lake, dimensional models, data pipelines, data warehouses and other ETL/ELT processes using Fabric. • Work with Fabric assets, Power BI, and other services to build end-to-end data solutions • Ensure data quality, security, and compliance with regulations by implementing data validation, logging, monitoring, and role-based access controls. • Perform root cause analysis on internal/external data and processes to answer specific business questions and identify opportunities for improvement. • Manage platform cost optimization, data quality/governance, and performance tuning • Follow software quality process and methodology standards, including those for design, data quality, code, version control, defect/change request tracking, documentation, work product review, unit testing and environment management. • Review requirements / user stories and provide feedback to the team. Includes participation/input to the requirements process • Integrate AI/ML models and GenAI capabilities into data products and workflows • Help the QA and functional team to identify and define testing strategies for existing and new features • Ability to ensure that solutions developed by development teams fit the business needs • Able to work under pressure and meet deadlines • Comfortable working in evening hours (2pm to 11pm IST)