Data Pipeline & Integration Engineer

BankUnited is seeking a Pipeline & Integration Engineer to develop, maintain, and support enterprise ETL pipelines and data integration workflows. The role involves implementing ETL transformations, ensuring data quality, and collaborating with senior engineers to deliver reliable data pipelines.

Responsibilities:

• Designs, develops, and maintains ETL pipelines using Informatica and related tools
• Builds mappings, workflows, and sessions to support data ingestion and transformation
• Implements transformations including joins, aggregations, parameterization, and error handling
• Ensures ETL jobs are restartable, efficient, and aligned with SLAs and dependencies
• Monitors and supports production ETL pipelines and scheduled jobs
• Troubleshoots ETL failures, analyze logs, and identify root causes
• Resolves defects and data issues within defined timelines
• Contributes to improving pipeline reliability and reducing recurring issues
• Designs and maintains data flows across staging, ODS, and data warehouse layers
• Develops and maintains data interfaces across systems and applications
• Supports data acquisition strategies and integration patterns
• Optimizes ETL processes for performance and scalability
• Implements validation checks, reconciliation processes, and data quality controls
• Ensures compliance with data governance and audit requirements
• Works with business analysts and stakeholders to refine data requirements
• Coordinates with QA, scheduling, and downstream consumers for deployment and execution
• Participates in Agile or hybrid delivery models
• Follows coding standards, naming conventions, and documentation practices
• Participates in code reviews and design walkthroughs
• Maintains documentation for pipelines and interfaces
• Gains exposure to cloud and modern platforms such as Snowflake, AWS, dbt, and streaming technologies
• Supports hybrid architecture environments combining legacy ETL and modern platforms
• Support audit, reconciliation, and data lineage requirements
• Adheres to and complies with applicable, federal and state laws, regulations and guidance, including those related to anti-money laundering (i.e. Bank Secrecy Act, US PATRIOT Act, etc.)
• Adheres to Bank policies and procedures and completes required training
• Identifies and reports suspicious activity

Requirements:

• Bachelor's Degree in Computer Science, Information Systems, or related field
• 4+ years of experience in ETL / data engineering / data integration
• Hands-on experience with Informatica (PowerCenter / IDMC)
• Strong SQL and relational database experience
• Exposure to modern data platforms tools such as Snowflake, AWS, dbt, or other cloud-based data environments, and their orchestration tools
• Understanding of ETL/ELT and data pipeline design
• Strong understanding of ETL/ELT concepts, data integration, and pipeline orchestration
• Solid knowledge of data warehouse architecture, including staging, ODS, and enterprise data warehouse layers
• Strong SQL skills and experience querying relational databases
• Ability to troubleshoot ETL failures, analyze logs, and identify root causes
• Ability to follow and contribute to coding standards, documentation, and best practices
• Strong analytical and problem-solving skills
• Strong attention to detail and operational discipline
• Ability to collaborate with cross-functional teams including QA, business analysts, and downstream consumers
• Familiarity with Agile or hybrid delivery models
• Understanding of data governance, security, and regulatory requirements in banking environments
• Understanding of data quality, reconciliation, and audit requirements