What are the responsibilities and job description for the Integration Engineer II-S position at SwitchThink Solutions?
The Integration Engineer II is responsible for orchestrating the seamless flow of data, ensuring efficient curation for ingestion into the Data Warehouse (DW), as well as extracting and transforming data from the DW to feed other systems. They demonstrate a strong understanding of data integration, ETL processes, and a proactive approach to problem-solving. They ensure new integrations and management of current integrations are managed accurately and in a timely fashion. This role also facilitates the creation of curated views for LOB consumption as part of the integrations.
What you will do here:
Data Integration:
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.
ETL Development:
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.
Data Warehouse Management:
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.
Develop and deploy data model changes in support of the above
Data Extraction for External Systems:
Create and maintain processes to extract and transform data from the Data Warehouse for consumption by external systems.
Work closely with end-users and system owners to understand data requirements for downstream applications.
Error Handling and Monitoring:
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.
Technical Support
Support DW Analysts interpreting relationship databases providing technical insight.
Optimize queries on behalf of LOB stakeholders and other BI team members
Documentation:
Maintain comprehensive documentation of integration processes, data mappings, and system dependencies.
Contribute to the development of integration standards and best practices..
What you will need:
Bachelor's degree in Computer Science, Information Technology, or a related field required.
Master's degree in Computer Science, Information Technology preferred.
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 related to handling sensitive data 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.
Certification: Microsoft Power BI Data Analyst Professional preferred.
We are proud to be an EEO/AA employer M/F/D/V. We maintain a drug-free workplace and perform pre-employment substance abuse testing.
For additional information about our organization, careers, and benefits visit: http://www.desertfinancial.com/careers.