Senior Data/ETL Engineer Full Time

Join our team! As a global leader in providing title insurance, settlement services and risk solutions for real estate transactions, First American (NYSE: FAF) is an ideal place to build your career. We have been entrusted with helping our customers achieve and protect their dream of homeownership since 1889. We believe that our people are the key to the company’s continued success, and we invest in diverse talents and backgrounds and empower our teams to achieve more than they could anywhere else. First American has created an award-winning culture and has been named to the Fortune 100 Best Companies to Work For® list for the fifth consecutive year and to more than 50 regional Best Places to Work lists. For more information, please visit www.careers.firstam.com

Job Summary

Reporting to the ETL Manager, the Senior Data Engineer/ETL Developer will work collaboratively with our Data Architecture, Analytics, Development, and Business Product Management teams to design, implement and maintain data warehousing and data management solutions to support business reporting, analytical requirements and data integrations between enterprise systems. The right resource will also contribute to building next-generation data platforms utilizing cloud technologies. In addition, they will be responsible for production support, documentation of system requirements, development of standards and guidelines, and implementation of processes and procedures to deliver maximum functionality, flexibility, and reliability to ensure a high standard of performance and reliability to our customers.

*Remote work available.

Responsibilities:

• Work with technical and business stakeholders to capture requirements related to data and data solutions
• Design and build data models or information marts that will meet business requirements and align with our enterprise architecture
• Get a deep understanding of business rules and transformations logic used by various groups within the company
• Understand and implement best practices in managing enterprise data including master data, data quality, lineage and security
• Document objects, resources, processes in the data catalog
• Interface with the department’s business analysts, developers, data architects and system administrators on daily support tasks and project-driven activities
• Contribute to technical and system architectural planning and the development of innovative solutions for the business
• Establish relationships with vendors and internal associates to resolve technical issues
• Design, test and implement new technical solutions
• Work with the administration team to create and maintain best-practice standards and procedural guidelines
• Participate in on-call rotation schedule for after-hours support

Qualifications:

Experience

• Bachelor’s degree in Information Systems, Information Technology, Computer Science or Engineering
• 6-10 years demonstrated experience integrating and analyzing data as well as designing, tuning, and developing SQL including SQL, Stored Procedures, Views, and ETL packages
• 1+ years of working with Cloud technologies in data movement, transformation and retrieval activities
• Extensive experience and knowledge in data modeling
• Experience with the full stack BI technologies: Oracle, Microsoft, Talend, Informatica or similar other tools
• Experience designing and building complete processes for moving and transforming data
• 3+ years of production support experience
• Experience working directly with non-technical (business) individuals to understand business process and capture business requirements

Knowledge

• Expert SQL knowledge and ability to improve and tune complex SQL statements
• Strong knowledge of data warehousing concepts and data analysis
• Strong understanding of data and analytics solution architecture, including experience with Big Data, Relational databases, OLAP, streaming and batch data processing
• System Development Life Cycle and Agile Methodology familiarity

Soft Skills

• Strong data analysis skills (debugging data anomalies)
• Excellent oral and written communication skills
• Demonstrated creative problem-solving abilities (think out of the box)
• Excellent documentation skills
• Self-starter with initiative and ability to work independently or on a small team
• Highly organized, and able to run with multiple tasks at once
• A desire to understanding business models and processes in order to apply the right solution

Desired Skills

• Experience with Snowflake data warehouses
• Familiarity with Azure, AWS, s3/blob storage, streaming services such as Event Hubs or Kinesis
• Understanding of Data Vault 2.0 architecture and modeling
• Experience and knowledge analyzing and documenting data taxonomies
• Experience supporting Decision Science initiatives
• Knowledge with Change-Data-Capture (CDC) and Replication technologies
• Familiar with BEAM methodology or similar processes for requirements gathering

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. For more information about our Company and our dedication to putting People First, check out firstam.com/careers.

Appcast