This job has closed.

SwitchThink Solutions · 1 day ago

Integration Engineer II-ST

Phoenix, AZ

Full-time

Hybrid

Senior Level

6+ years exp

SwitchThink Solutions is seeking an Integration Engineer II, responsible for orchestrating data flow and ensuring efficient data curation for ingestion into the Data Warehouse. The role involves designing data integration solutions, developing ETL workflows, and collaborating with stakeholders to meet data requirements.

Financial ServicesInformation ServicesInformation Technology

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

Develop and deploy data model changes in support of the above

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

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

Support DW Analysts interpreting relationship databases providing technical insight

Optimize queries on behalf of LOB stakeholders and other BI team members

Maintain comprehensive documentation of integration processes, data mappings, and system dependencies

Contribute to the development of integration standards and best practices

Qualification

Data integrationETL developmentData Warehouse managementSQLETL toolsScripting languagesData modelingData governanceInformation securityProblem-solvingCommunication skills