Senior Data Engineer SSE I

First American; Bengaluru; On-site; INR 600,000 - 1,200,000; Full time

Job summary

First American (India) is seeking a data analyst to join their Bengaluru team. The candidate will work in a large data warehouse environment, gathering data requirements from business and US teams, and developing data ingestion rules and data quality standards.

The role requires SQL proficiency, experience with data visualization tools like Tableau or Power BI, and familiarity with cloud platforms (Snowflake, Azure/AWS). Strong communication and Agile experience are preferred.

Qualifications

• 4+ years of data analyst experience in a large data warehouse environment.
• Strong SQL skills and ability to gather data requirements from business/US teams.
• Experience with data quality rules, data standards and root cause analysis.

Responsibilities

• Analyze and create ingestion requirements for data assets from multiple sources.
• Document data requirements, standards and quality rules.
• Write SQL queries and develop procedures; perform data quality checks.

Skills

SQL queries

Data analysis

Data warehousing

Education

Bachelor's degree in engineering

Tools

Snowflake

Azure Functions

AWS Lambda

Tableau

Power BI

Job description

Company SummaryFirst 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 SummaryResponsibilitiesAt least 4 years of experience as data analyst in huge data warehouse environment.Must have strong experience in gathering data requirements from business & US team.Analyze and create ingestion requirements for data assets from various internal and external sources.Document data requirements, data standards and data quality rules.Help business in identification of Critical Data Elements and the data quality rules associated with them.To perform data analysis and interpret results using standard statistical methodologies.Understand domains and business process.Have good knowledge on gap analysis, writing and reviewing functional solution design and testing document.Perform data quality checks, root cause analysis and remediation.Knowledge to write SQL queries and developing procedures.Good analytical, debugging, problem-solving skills.Should have excellent written and verbal communication skills that will help the frequent conversations with the onshore counter parts.Ability to start working independently in multi-task and fast-paced environment.Experience working with Agile project environment.Bachelor’s degree in engineering4 - 5 years of experience as Data AnalystDesired SkillsBasic knowledge of SnowflakeBasic cloud knowledge of Azure Functions apps & AWS lambdaProblem-solving, troubleshooting, automation and familiarity with cloud platforms.Experience of dashboards with the use of visualization tools like Tableau or Power BI.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.