Integration Engineer II-S

Desert Financial Credit Union - Phoenix, AZ

Full-time - Mid Level

Phoenix, AZ

Credit Intermediation and Related Activities

About the position

The Integration Engineer II is responsible for orchestrating the seamless flow of data, ensuring efficient curation for ingestion into the Data Warehouse (DW), and extracting and transforming data from the DW to feed other systems. This role requires a strong understanding of data integration and ETL processes, along with a proactive approach to problem-solving. The engineer will manage new and current integrations accurately and timely, facilitating the creation of curated views for Line of Business (LOB) consumption as part of the integrations.

Responsibilities

• Design and implement data integration solutions to curate diverse data sources for ingestion into the Data Warehouse, including scripting in Python.
• Collaborate with stakeholders to understand data requirements and ensure proper alignment with integration processes.
• Create and monitor performant refreshes on enterprise solutions such as Power BI and SSRS.
• Develop, maintain, and optimize ETL workflows to facilitate the extraction, transformation, and loading of data between systems.
• Ensure ETL processes adhere to best practices for data quality, integrity, and performance.
• Collaborate with Data Warehouse Analysts to optimize data storage, schema design, and indexing for efficient data retrieval.
• Support the maintenance and enhancement of Data Warehouse structures to accommodate evolving business needs.
• Create and maintain processes to extract and transform data from the Data Warehouse for consumption by external systems.
• Implement robust error handling mechanisms to identify and resolve issues in data integration processes.
• Monitor integration pipelines and proactively address performance bottlenecks or data inconsistencies.
• Provide technical support to DW Analysts interpreting relationship databases and optimizing queries for LOB stakeholders.
• Maintain comprehensive documentation of integration processes, data mappings, and system dependencies.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field required.
• 6+ years technical experience in data integration, ETL development, and working with Data Warehouses required.
• 3+ years financial institution experience required.
• 3+ years information security experience related to data transfer and encryption required.
• Proven experience in data integration, ETL development, and working with Data Warehouses required.
• Strong SQL skills and familiarity with database concepts required.
• Proficiency in ETL tools (e.g. Talend, Matillion, Alteryx) required.
• Proficiency in scripting languages (e.g., Python, SQL) required.
• Understanding of data modeling and schema design required.
• Excellent problem-solving and troubleshooting skills required.
• Strong communication and collaboration skills required.
• Knowledge of data governance and security best practices required.

Nice-to-haves

• Master's degree in Computer Science, Information Technology preferred.
• Certification: Microsoft Power BI Data Analyst Professional preferred.

Benefits

• Comprehensive health insurance coverage
• 401k retirement savings plan
• Paid time off and holidays
• Professional development opportunities
• Flexible work hours