Work in Washington Veterans Jobs

Job Information

First American Title Insurance Company Data Architect in Seattle, Washington

Company SummaryJoin 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 Summary**Remote candidates will be considered with a preference for Pacific Time Zone**We're looking for an experienced Data Architect to join our Business Technology Solutions (BTS) organization. Our Data Architect will lead a high-impact, high-velocity initiative to bring our Agency technology up to date. This role collaborates with various engineering teams and business leaders to ensure the Agency teams make the best technical, product and people decisions.In this role, you'll be responsible for the design of new systems and guide the delivery teams in building high performing, scalable, secured, highly available and easy to understand cloud services based on your blueprints. You'll operate as a key contributor in teams of dedicated professionals toward a common product vision. You must be comfortable presenting ideas to our Executive & IT Leadership team. Presenting your ideas clearly, concisely to business and leadership will be a key attribute to your suite of skills. You'll bring to bear your proven track record of expertise in hands-on AWS experience.Responsibilities:Create a well-informed cloud strategy and manage the adaption process.Regularly evaluate cloud databases and infrastructureTune and optimize database performance both before and after cloud transformationTroubleshoot database problems and provide corrective action within a short amount of timeAssist in installing, upgrading and configuring database management system software including AWS RDS instances in the cloudDevelop and organize cloud systems.Work closely with IT security to monitor the company's cloud privacy.Offer guidance in infrastructure movement techniques including bulk application transfers into the cloud.Identify the top cloud architecture solutions to successfully meet the strategic needs of the company.Advanced knowledge of Microsoft SQL Server systems to install, upgrade, configure, implement, secure, tune, monitor and maintain required database objectsAdvanced knowledge of database design to produce sound logical and physical data modelsAdvanced knowledge of SQL and coding techniques to code stored procedures and triggersExperience with varied forms of data design, such as online transaction processing, online analytical processing, data warehousing, operational data stores, and decision support systems. Specific knowledge writing ETL for data warehousingRequired to perform duties outside of normal work hours based on business needsRequirements:Bachelor's degree or equivalent software work experience2+ years of Architecture experience3+ years developing and optimizing large scale data pipelines, with experience in both structured and unstructured data setsExperience in data transformation, migration, synchronization, and troubleshooting across more than one Database Platform (e.g., SQL Server, MongoDB, MySQL, PostgreSQL, Cassandra etc.) and one or more Cloud Database Platforms (e.g., AWS RDS, AWS DynamoDB, Azure Cosmos DB, Azure MySql, GCP Cloud SQL, GCP DataStore, etc.)