Integration Engineer - Open Systems Technologies

Skills

Python SQL Data Warehousing Data Architecture SQL Server Analytics Snowflake Databricks PySpark ETL Processes

Job Specifications

Integration Engineer (SSIS, Python, SQL, Data Warehousing)
We are looking for a skilled Integration Engineer with strong experience in SSIS, Python, SQL, and data warehousing within enterprise environments. This role combines technical expertise with the ability to collaborate directly with business stakeholders and analysts to deliver robust data integration solutions.
Key Responsibilities:
Provide Level 2/3 support for existing ETL workflows.
Monitor, troubleshoot, and optimize scheduled ETL jobs, identifying root causes and resolving performance issues.
Design and develop efficient ETL processes using SSIS, Python, and SQL (SQL Server/Oracle).
Write complex SQL queries and stored procedures; reverse engineer existing logic where required.
Build and optimize data pipelines for seamless ingestion, transformation, and loading across structured, semi-structured, and unstructured data sources.
Ensure data quality, integrity, and consistency across processes.
Follow and enforce data management, security, and governance best practices.
Conduct code reviews to validate performance, compliance with standards, and alignment with business requirements.
Required Qualifications:
Minimum 5 years of hands-on experience in:
SSIS development
Python scripting for ETL or data processing
SQL Server-based development, working with large datasets
Preferred Qualifications:
Experience in the Financial Services industry
Familiarity with enterprise scheduling/orchestration tools such as Tidal or Airflow
Experience with cloud data platforms (e.g., Snowflake)
Solid understanding of data warehousing concepts, including OLTP, dimensional modeling, and facts/dimensions
Knowledge of cloud-based data architecture, messaging systems, and analytics
Experience developing and deploying ETL pipelines using Databricks (PySpark)
Bachelor's degree in Computer Science, Engineering, or a related field (Master's preferred)

About the Company

Open Systems Technologies is a tier-one vendor for the world's most competitive financial and technology companies, offering both full-time and contract recruiting services across the country. We offer a positive, entrepreneurial, high performing culture where all employees have the unique opportunity to run a full desk. Our office looks, feels, and operates like a start-up, but with the stability, clientele, and resources that only an industry veteran can provide. At our core, we are structured to be flexible. With over 3... Know more