Etl Informatica Developer Remote Jobs in California

Who We Are
Join a team that puts its People First! As a member of First American's family of companies, Data & Analytics is a national provider of property-centric information, analytics, risk management and valuation solutions. First American maintains and curates the industry's largest property and ownership dataset with over 7 billion document images. Our major platforms and products include: DataTree®, FraudGuard®, RegsData™, TaxSource™ and ACI®. The First American Data & Analytics division boasts more than 20 patents and remains at the forefront of innovation - leveraging technology and data to deliver best-in-class decisioning solutions. Fueled by our industry-leading data and using our technology and proprietary process, our solutions provide lenders, real estate and title companies with actionable insights - enabling them to make better, increasingly automated, decisions. With offices in all major metropolitan areas, including California and New York, DNA teams work collaboratively from across the country. 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 eleven 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.
What We Do
Primary point of responsibility, accountability and activity for the assessment, improvement and governance of quality and ongoing fitness-for-purpose of an organizations critical data assets. Using SQL queries, monitors, tracks and reports ongoing data quality levels of the data loaded into the database systems. Identifies data quality metrics and executes data quality audits to benchmark the state of data quality. Provides production job support from a quality perspective serve as a data quality subject matter expert partnering with Product and Technology Teams to implement data logic and product releases. Engages with business leadership to quantify and articulate the business impact of data quality issues.
HOW YOU'LL CONTRIBUTE

• Serves as a data subject matter expert & partner with the product development & IT team to implement data logic and product releases.
• Owns customer vision and requirements full cycle, including requirements, design, implementation, testing, user acceptance, deployment, and maintenance.
• Collaborates with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.
• Works independently with users to define concepts and under direction of Product Managers.
• Serves as the conduit between the customer community (internal and external customers) and the software development team through which requirements flow.
• Provides primary support to the ETL team on testing new data logic and derived content and provide data insight for ETL and IT development teams.
• Conducts data quality reviews using various tools and methodologies.
• Participates in projects involving new data aggregations and custom solutions.
• Utilizes tools to analyze, query and manipulate data according to defined business rules and procedures.
• Performs system and visual QC tests to verify data integrity.
• Assists in correcting minor data quality errors.
• Documents and works to resolve basic problems.
• Updates and maintains database with reviewed and corrected data.
• Communicates issues to programmers to resolve data quality issues.
• Works with offshore partners that will be responsible for reoccurring fulfillments and/or QC processes.
• Critically evaluates information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up form low-level information to a general understanding, and distinguish user requests from the underlying true needs.
• Proactively communicates and collaborates with external and internal customers to analyze information needs and functional requirements.
• Other duties as assigned

WHAT YOU'LL BRING
Required Education, Experience, Certification/Licensure

• Bachelor's degree in relevant discipline (C.S., CIS, Statistics, etc.) or equivalent combination of education and experience.
• 5-7 years of experience working with public record assessor data.

KNOWLEDGE, SKILLS, AND ABILITIES (KSAs)

• Experience with SQL and ETL tools
• Extensive experience performing data quality reviews and analysis.
• Ability to enhance, edit and correct data content issues based on knowledge and experience.
• Excellent verbal and written communication skills, and experience interfacing with clients, data modeling and/or data scientist teams
• Ability to make independent approval decisions on behalf of the quality team.
• Ability to follow and develop data quality standards, metrics, and audit procedures.
• Conveys technical issues/problems to programmers in a clear/concise manner. Must be familiar with basic data/programming terminology to communicate as much of problem and solution as possible.
• Strong analytical and product management skills required, including a thorough understanding of how to interpret customer business needs and translate them into application and operational requirements.
• Strong leadership and mentoring skills.
• Detail oriented with strong organizational skills.
• Excellent interpersonal, relationship-building and teamwork skills
• Ability to manage multiple tasks, respond quickly to emergent problems, and focus both on long-range projects and immediate tasks.
• Proficient in Microsoft Word, Excel and PowerPoint.
• Experience with Databricks preferred.

Pay Range: $87,800-$111,100 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.
** Note that the following statements only apply to candidates who will be working from an unincorporated area within Los Angeles County. **
First American will consider for employment all qualified applicants, including those with arrest or conviction records, in a manner consistent with the requirements of applicable state and local laws (e.g., the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act).
First American intends to conduct a review of an applicant's criminal history in connection with a conditional offer. First American reasonably believes that a criminal history may have a direct, adverse and negative relationship with the following material job duties for this position potentially resulting in the withdrawal of the conditional offer of employment: handling of confidential, proprietary or trade secret information belonging to First American or its customers, administrating or facilitating financial transactions, and the ability to meet customer-imposed criminal history requirements.
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 is inclusive for all employees - not just because it's the right thing to do, but 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.