Job Title

About FAIAt First American (India), we don’t just build software—we build the future of real estate technology. Our people- first culture empowers bold thinkers and passionate technologists to solve real-world challenges through scalable architecture and innovativedesign.If you're driven by impact, thrive in collaborative environments, and want to shape howworld-class products are delivered—this is the place for you.Core Responsibilities:- Enterprise Data Architecture & Strategy - Collaborate with architects and stakeholders to design and implement robust enterprise data solutions aligned with business goals. - Ensure architectural consistency across data platforms, pipelines, and storage layers. - ETL Development & Orchestration (Matillion) - Design, build, and maintain scalable ETL pipelines using Matillion for Snowflake. - Optimise data ingestion and transformation workflows for performance, reliability, and cost-efficiency. - Data Transformation & Modeling - Develop complex data transformation logic to support analytics, reporting, and machine learning use cases. - Implement and maintain dimensional models, star/snowflake schemas, and normalised structures. - Point-in-Time Data Storage - Architect and implement solutions for capturing and storing point-in-time snapshots of data for audit, historical analysis, and compliance purposes. - Cloud-Native Platform Expertise (Snowflake) - Extensive hands-on experience with Snowflake, including: - Schema design, performance tuning, and query optimization. - Role-based access control and data security best practices. - Integration with BI platforms (ThoughtSpot) and third-party tools. - Data Governance & Quality - Implement data quality checks, lineage tracking, and metadata management. - Ensure compliance with data protection regulations and internal policies. - Collaboration & Reporting - Work closely with business and data analysts to deliver reliable and timely data products.Preferred Experience:- 5+ years in data engineering or related roles. - Strong understanding of enterprise architecture principles. - Proven experience with Matillion and Snowflake in production environments.Mode Of work: HybridJob Location: Hyderabad