Bachelor’s degree in Computer Science/related field or equivalent combination of education and experience 5-8 years of directly related experience Experience working in Agile SDLC methodology Proficient with SQL and T-SQL programming skills Working experience building data/ETL pipeline and data warehouse Advanced to expert-level proficiency in Python Advanced proficiency in Azure General knowledge of machine learning models and their utilization Demonstrated expertise in data modeling, database maintenance, monitoring and performance tuning on SQL Server, MongoDB or other NoSQL databases Exceptional analytical skills analyzing large and complex data sets Perform thorough testing and data validation to ensure the accuracy of data transformations Strong written and verbal communication skills, with precise documentation Self-driven team player with ability to work independently and multi-task Analytical, creative thinker and innovative problem solver Working knowledge/proficient in modern cloud computing technology Responsibilities The Data Engineer is a data expert and plays a key role in the development and deployment of innovative big data platforms for advanced analytics and data processing Viewed as a data expert; drives innovation and plays a key role in the department Participates in highly visible initiatives that have broad impact Identify, design, and implement internal process improvements: automate manual processes, optimize data delivery, redesign infrastructure for greater scalability Design, develop, code, test, and document architectures and applications Work closely with team members and cross-functional teams to ensure design/architecture/deliverables support business requirements and align with best-practices Troubleshoot and resolve a wide range of data issues Makes innovative recommendations to improve data reliability, efficiency and quality Required to perform duties outside of normal work hours based on business needs Pay Range: $80,000 – $167,000 annually This hiring range is a reasonable estimate of the base pay range for this position at the time of posting Pay is based on a number of factors which may include job-related knowledge, skills, experience, business requirements and geographic location 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 Qualifications Bachelor’s degree in Computer Science/related field or equivalent combination of education and experience 5-8 years of directly related experience Experience working in Agile SDLC methodology Proficient with SQL and T-SQL programming skills Working experience building data/ETL pipeline and data warehouse Advanced to expert-level proficiency in Python Advanced proficiency in Azure General knowledge of machine learning models and their utilization Demonstrated expertise in data modeling, database maintenance, monitoring and performance tuning on SQL Server, MongoDB or other NoSQL databases Exceptional analytical skills analyzing large and complex data sets Perform thorough testing and data validation to ensure the accuracy of data transformations Strong written and verbal communication skills, with precise documentation Self-driven team player with ability to work independently and multi-task Analytical, creative thinker and innovative problem solver Working knowledge/proficient in modern cloud computing technology Responsibilities The Data Engineer is a data expert and plays a key role in the development and deployment of innovative big data platforms for advanced analytics and data processing Viewed as a data expert; drives innovation and plays a key role in the department Participates in highly visible initiatives that have broad impact Identify, design, and implement internal process improvements: automate manual processes, optimize data delivery, redesign infrastructure for greater scalability Design, develop, code, test, and document architectures and applications Work closely with team members and cross-functional teams to ensure design/architecture/deliverables support business requirements and align with best-practices Troubleshoot and resolve a wide range of data issues Makes innovative recommendations to improve data reliability, efficiency and quality Required to perform duties outside of normal work hours based on business needs Benefits Pay Range: $80,000 – $167,000 annually This hiring range is a reasonable estimate of the base pay range for this position at the time of posting Pay is based on a number of factors which may include job-related knowledge, skills, experience, business requirements and geographic location 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 Who We Are Join a team that puts its People First! As a member of First American’s family of companies, National Commercial Services provides single-point service for simple to multi-property/multi-state national commercial real estate transactions. 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 eight 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 What We Do The Senior Data Engineer is a data expert and plays a key role in the development and deployment of innovative big data platforms for advanced analytics and data processing. Supports building scalable and effective solutions using modern technology stack to grow and leverage the company’s vast data assets. Works with functional teams and supports software developers, database architects, data analysts, and data scientists on data initiatives and ensures that optimal data delivery architecture is consistent throughout ongoing projects. The Data Engineer is a data expert and plays a key role in the development and deployment of innovative big data platforms for advanced analytics and data processing. Supports building scalable and effective solutions using modern technology stack to grow and leverage the company’s vast data assets. Works with functional teams and supports software developers, database architects, data analysts, and data scientists on data initiatives and ensures that optimal data delivery architecture is consistent throughout ongoing projects. What You’ll Do
- Viewed as a data expert; drives innovation and plays a key role in the department. Participates in highly visible initiatives that have broad impact.
- Identify, design, and implement internal process improvements: automate manual processes, optimize data delivery, redesign infrastructure for greater scalability.
- Design, develop, code, test, and document architectures and applications.
- Work closely with team members and cross-functional teams to ensure design/architecture/deliverables support business requirements and align with best-practices.
- Troubleshoot and resolve a wide range of data issues.
- Makes innovative recommendations to improve data reliability, efficiency and quality.
- Required to perform duties outside of normal work hours based on business needs.
What You’ll Bring
- Bachelor’s degree in Computer Science/related field or equivalent combination of education and experience
- 5-8 years of directly related experience
- Experience working in Agile SDLC methodology
- Proficient with SQL and T-SQL programming skills
- Working experience building data/ETL pipeline and data warehouse
- Advanced to expert-level proficiency in Python
- Advanced proficiency in Azure
- General knowledge of machine learning models and their utilization.
- Demonstrated expertise in data modeling, database maintenance, monitoring and performance tuning on SQL Server, MongoDB or other NoSQL databases
- Exceptional analytical skills analyzing large and complex data sets
- Perform thorough testing and data validation to ensure the accuracy of data transformations
- Strong written and verbal communication skills, with precise documentation
- Self-driven team player with ability to work independently and multi-task
- Analytical, creative thinker and innovative problem solver
- Working knowledge/proficient in modern cloud computing technology
Pay Range: $80,000 – $167,000 annually This hiring range is a reasonable estimate of the base pay range for this position at the time of posting. Pay is based on a number of factors which may include job-related knowledge, skills, experience, business requirements and geographic location. What We Offer By choice, we don’t simply accept individuality – we embrace it, we support it, and we thrive on it! Our People First Culture celebrates diversity, equity and inclusion not simply because it’s the right thing to do, but also because it’s the key to our success. We are proud to foster an authentic and inclusive workplace For All. You are free and encouraged to bring your entire, unique self to work. First American is an equal opportunity employer in every sense of the term. 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 Company information First American Financial Corporation is a premier provider of title, settlement and risk solutions for real estate transactions. With its combination of financial strength and stability built over more than 130 years, innovative proprietary technologies, and unmatched data assets, the company is leading the digital transformation of its industry. First American also provides data products to the title industry and other third parties; valuation products and services; mortgage subservicing; home warranty products; banking, trust and wealth management services; and other related products and services. First American serves home buyers and sellers, real estate professionals, loan originators and servicers, commercial property professionals, homebuilders and others involved in residential and commercial property transactions with products and services specific to their needs. With total revenue of $9.2 billion in 2021, the company offers its products and services directly and through its agents throughout the United States and abroad. In 2022, First American was Insurance, Financial Services, Construction, Technology, Real Estate, Data Analytics, Data Analysis, Data & Analytics, Finance and Insurance, Mortgage Services #J-18808-Ljbffr
Troubleshooting Analytical skills Computer Science Data Engineering Azure Business Requirements Document (BRD) database-management validation cloud-computing data-modeling Performance optimization data-pipelines Machine Learning data-processing Innovativeness infrastructure systems Data Analyst Data Science data-warehouse Python Problem-solving Quality Assurance (QA) MongoDB T-SQL Team player Big data Bachelor’s Degree scalable systems Process improvement SQL ETL Data Platforms NoSQL