Data Engineer III

Job description

Finance of America Holdings LLC, is seeking Data Engineer III in Plano TX. Telecommuting permitted. Summary of Duties: Design, implement, and maintain scalable and efficient data infrastructure and pipelines, extract data from complex and diverse data sources, and build and manage data repositories. Design and develop data pipelines to ingest, transform, and load data from various sources into the data ecosystem. Collaborate with Analytics Engineers and other cross-functional teams to ensure the data infrastructure meets the organization's needs, and support data-driven initiatives and enterprise decision-making. Write complex SQL queries to move data from various source systems (i.e. flat files, SQL Server databases, XIS files, JSON files, etc.) into the data environments. Create reconciliation processes to ensure data is loaded into the ODS completely and accurately. Create error handling and logging processes in the data environments. Collaborate with Analytics Engineers and Data Owners to understand their data requirements and identify and prioritize opportunities to improve efficiencies and processes through integration. Design and implement integration flows and enhancements,...