Senior Business Intelligence Engineer – First American Title

Company SummaryJoin a team that puts its People First! Since 1889, First American (NYSE: FAF) has held an unwavering belief in its people. They are passionate about what they do, and we are equally passionate about fostering an environment where all feel welcome, supported, and empowered to be innovative and reach their full potential. Our inclusive, people-first culture has earned our company numerous accolades, including being named to the Fortune 100 Best Companies to Work For® list for six consecutive years. We have also earned awards as a best place to work for women, diversity and LGBTQ+ employees, and have been included on more than 50 regional best places to work lists. First American will always strive to be a great place to work, for all. For more information, please visit www.careers.firstam.com.Job Summary

Responsible for managing projects and perform various tasks including collecting disparate info-sec data, translate business needs to support the Information Security and external stakeholders. Provide complex data analysis and develop business intelligence solutions for information security operations. Developing, authoring and leading automation processes and adoption. Automating data collection from different data sources. Implementing Azure SQL Server, SSIS on Azure (Azure Data Factory) solutions. Collaborating with various groups to set data strategy and planning for each group. Understanding business needs and requirements and translating into user stories. Mining data in large databases to locate information related to information security. Performing independent research on trends and creating metrics to evaluate data models. Fulfilling complex data analysis and identifying process improvement opportunities in data management. Driving data validation for accuracy and completeness. Serving as data SME across information security operations to employ best practices for data quality tools and technologies. Tracking delivery service levels and data analytics project schedules. Communicating to all stakeholders about any risks, issues and expectations.

Education And Experience Requirements

Bachelor’s degree or foreign equivalent in Computer Science, Management Information Systems or related field plus 5 years of experience in job offered or related IT occupation.

REQUIRED SKILLS: Expertise/knowledge sufficient to adequately perform the duties of the job

being offered. Expertise/knowledge may be gained through employment experience or education.

Must possess expertise/knowledge sufficient to adequately perform the duties of the job being offered. Expertise/knowledge may be gained through employment experience or education. Such expertise/knowledge cannot be “quantified” by “time.”

Experience With

• Data integration/ETL tools including SSIS, Azure Data Factory.
• Writing complex SQL queries and stored procedures: PL/SQL, T-SQL.
• BI Visualization tools including Tableau/Power BI.
• Scripting skills using Python.
• Cloud environments: Azure, AWS.
• ASP.Net languages/PowerShell.
• Project management, data management and data modeling.
• Statistical and data analysis.
• Data requirements and methods of extracting various data assets.
• Providing complex data analysis and develop business intelligence Solutions.
• Experience with relational/dimensional databases.
• Employer will accept any suitable combination of education, training or experience.

OTHER: Job Site: First American Title Insurance Company – 5 First American Way, Santa Ana, CA 92707. 40 hours/week. If offered employment must have legal right to work in U.S. EOE. Position eligible for Employee Referral Program.

CONTACT: Send resumes to 1 First American Way, Santa Ana, CA 92707. Refer to Req# above.

First American invests in its employees’ development and well-being, empowers them to provide superior customer service and encourages them to serve the communities where they live and work. First American is committed to diversity and inclusion. We are an equal opportunity employer.Based on eligibility, First American offers a comprehensive benefits package including medical, dental, vision, 401k, PTO/paid sick leave and other great benefits like an employee stock purchase plan.