Senior Data Engineer

Company Summary

First American (India) is a GCC (Global Capability Center) of the First American Financial Corporation (NYSE: FAF) family of companies. FAI is a proud member of the FORTUNE 500 companies and has been amongst the Fortune 100 Best Companies to Work For® list for eight consecutive years. First American Financial Corporation provides comprehensive title insurance, closing/settlement, property data and technology solutions. First American (India) creates quality solutions for its customers by combining software, back office, and knowledge processing operations to fulfill First American's business requirements. Our priorities are our employees, customers, and shareholders - in that order. First American (India) has been ranked amongst India's Best Companies To Work For™ 2023: Listed amongst the Top 100 by Great Place To Work® India, FAI is also certified Best Workplaces for Women and Workplace with Inclusive Practices. First American maintains and curates the industry’s largest property and ownership dataset with over 7 billion document images. Our major platforms and products include: DataTree®, FraudGuard®, RegsData™, TaxSource™ and ACI®. The First American Data & Analytics division boasts more than 20 patents and remains at the forefront of innovation - leveraging technology and data to deliver best-in-class decisioning solutions. Fueled by our industry-leading data and using our technology and proprietary process, our solutions provide lenders, real estate and title companies with actionable insights - enabling them to make better, increasingly automated, decisions.

Job Summary

Role Summary 

 

As a Senior Software Engineer, you'll drive innovation and excellence by delivering high-quality work, collaborating with your manager to advance team goals, and prioritizing effectively. You'll participate in core processes, recommend improvements, and invigorate the team by questioning the status quo. You'll respond urgently to operational issues, contribute to the software development lifecycle, and improve team processes. Engaging in code reviews, building cross-team relationships, and clarifying technical ambiguities will be key to your role, ensuring the team's success and shaping our technology's future.

Responsibilities and Duties 

 

As a Senior Software Engineer, you will work closely with the Engineering Manager, Architect, Product Manager and team.

·       Acts with urgency and delivers high-quality work that adds value to the business, stakeholders, and customers.

·       Works with the manager to focus on advancing team goals.

·       Prioritizes effectively and proposes scope adjustments when necessary.

·       Participates in core team processes and recommends improvements.

·       Questions the status quo to invigorate the team.

·       Responds urgently to operational issues and owns resolution within scope.

·       Is resilient, detail-oriented, and takes initiative, especially in crises.

·       Contributes significantly to the full software development lifecycle.

·       Improves team processes, code, and work items.

·       Asks questions, learns from others, and receives feedback humbly.

·       Seeks help when stuck and needs decision support.

·       Actively participates in code reviews, providing meaningful feedback.

·       Builds relationships across teams to achieve positive outcomes.

·       Communicates and coordinates team requirements with other groups.

·       Identifies technical blind spots and clarifies ambiguity in ideas.

 

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.

FAI is committed to create an environment that respects, supports and inspires all individuals. We do not discriminate on the basis of color, religion, sex, gender identity, sexual orientation and age. At FAI, we celebrate diversity and believe that an inclusive workforce benefits employees, the organization and our community. We are an Equal Opportunity Employer. For more information about our company and dedication to putting People First, check out https://firstam.wd1.myworkdayjobs.com/faicareers.