About this role
We are seeking a results-driven Integrations Engineer to design, develop, and optimize data pipelines and database solutions. The role requires experience with SQL, Azure data services, IBM DataStage, and SSIS, and involves building scalable ETL processes across enterprise environments.
What You'll Do
- Design, implement, and optimize robust and scalable data pipelines for extracting, transforming, and loading (ETL) data across enterprise environments.
- Work with stakeholders to gather requirements and design solutions that align with business goals.
- Build and maintain data pipelines using Azure services and SSIS 2019.
- Develop and optimize complex SQL queries, stored procedures, views, and functions; manage relational databases and large datasets.
- Create ETL solutions using IBM DataStage, and contribute to data modeling and data integration.
- Build cloud-based data solutions using Azure technologies (Azure SQL Managed Instance, Azure Data Factory, Azure Blob Storage) and optimize processing and storage costs.
- Integrate data from various sources/files/databases; monitor data quality and consistency.
- Collaborate with business stakeholders, analysts, and engineers to ensure high-quality data infrastructure.
- Monitor performance and tune databases and pipelines for speed, scalability, and cost.
- Stay current with business strategies, risk management practices, regulatory requirements, and evolving technology to deliver effective data solutions.