Senior Financial Analyst

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. The Mortgage Solutions division provides title insurance settlement services, signing services, portfolio analytics, retention and acquisition services; property valuations; and default solutions for the mortgage banking industry. In fact, Mortgage Solutions works with a multitude of people across the entire origination, servicing and default continuum, and has helped close millions of real estate transactions nationwide.

Job Summary

Role Summary:

We are looking for a Reporting Analyst - Finance with strong knowledge of Excel and intermediate experience in Power BI. The role involves preparing finance reports, handling complex formulas, analyzing financial data, and creating dashboards for management reporting.

Key Responsibilities
• Prepare daily, weekly, and monthly finance reports.
• Work on revenue, cost, expenses, budget, forecast, and variance analysis reports.
• Manage Excel reports with large data, multiple sheets, and complex formulas.
• Use formulas such as XLOOKUP, VLOOKUP, SUMIFS, IF, INDEX-MATCH, Pivot Tables, and charts.
• Check data accuracy and perform basic reconciliations.
• Create summary reports and management dashboards.
• Build and maintain Power BI dashboards for finance reporting.
• Use Power Query to clean and transform data.
• Create basic to intermediate DAX measures such as revenue, cost, margin, variance, MTD, and YTD.
• Manage relationships between tables in Power BI.
• Refresh reports and ensure dashboards are updated on time.
• Coordinate with finance, accounting, and business teams for reporting requirements.

Required Skills
• Strong knowledge of Microsoft Excel and complex formulas.
• Experience working with large datasets.
• Intermediate knowledge of Power BI Desktop.
• Knowledge of Power Query for data cleaning and preparation.
• Ability to create Power BI visuals, slicers, filters, cards, charts, and tables.
• Basic to intermediate understanding of DAX formulas.
• Good understanding of P&L, budget vs actuals, expense reports, and variance analysis.
• Ability to validate data and identify reporting errors.
• Good analytical skills, attention to detail, and ability to meet deadlines.

Experience
2 to 5 years of experience in finance reporting, MIS reporting, Power BI reporting, or similar roles.

Preferred Requirements
• Knowledge of Excel Power Query, macros, or basic VBA will be an added advantage.
• Experience in preparing management reports, P&L reports, budget reports, and financial dashboards.
• Ability to explain reports and insights to finance and business teams.

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.