Data Engineer

About FAI

At First American (India), we dont just build softwarewe 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 innovative

design.

If you're driven by impact, thrive in collaborative environments, and want to shape how

world-class products are deliveredthis 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: Hybrid

Job Location: Hyderabad