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. Software Services helps build First American's product suite that encompasses the best in class Title Insurance, Settlement and Mortgage solutions platforms. Leverages technology product stack across Microsoft platform predominantly to develop, enhance and maintain the best in class applications. The R & D division delivers solutions for the title insurance industry leveraging the best of NLP, AI and ML.

Job Summary Job Title: Senior Data Engineer Location: Bangalore / Remote Experience: 8+ years Job Summary We are seeking a highly skilled Senior Data Engineer to design, build, and scale modern data platforms and pipelines. The ideal candidate will have strong hands-on experience with ETL/ELT frameworks, cloud data platforms, and data warehousing, along with the ability to drive technical excellence, collaborate across teams, and mentor junior engineers. Key Responsibilities Design and develop scalable ETL/ELT pipelines and data workflows Develop and optimize T-SQL queries, stored procedures, and database solutions Build and manage data solutions using Snowflake, MSSQL, and Databricks Develop data pipelines using Python and Spark (Databricks) Implement and manage CI/CD pipelines for data engineering deployments Ensure data quality, governance, and performance optimization Design and implement data models and data warehouse architectures Collaborate with business and technical teams to translate requirements into scalable solutions Perform code reviews, troubleshooting, and production support Mentor junior data engineers and promote engineering best practices Contribute to architecture discussions and technology decisions Required Skills Strong expertise in T-SQL and SSIS (SQL Server Integration Services) Basic DBA skills (indexing, backup/recovery, performance tuning) Hands-on experience in ETL/ELT implementation and data pipeline development Experience with Snowflake and Microsoft SQL Server (MSSQL) Strong working knowledge of Databricks and Python Solid understanding of data modeling and data warehousing concepts Experience with CI/CD tools and automated deployment pipelines Hands-on experience with cloud platforms (AWS or Azure) Strong knowledge of performance tuning and query optimization Knowledge of data governance, security, and compliance practices Good to Have Experience with Neo4j or graph databases Experience with Talend Soft Skills Strong technical leadership and mentoring skills Excellent analytical and problem-solving abilities Effective communication and stakeholder management Ability to work independently in a remote/hybrid environment Strong collaboration and teamwork skills

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.