ASSOCIATE PROJECT MANAGER - SQL

Position Summary
We are seeking a hands-on Senior Developer with deep SQL expertise to join our Integration Team. This role designs, builds, and optimizes the data transformations that power our enterprise integrations, and business applications ? translating complex business rules into performant SQL logic, supporting data flows across ERP, order management, warehouse, and e-commerce systems, and automating processes with Python. The ideal candidate is a strong individual contributor who thrives on solving data problems end-to-end: from profiling and modeling source data, to writing and tuning complex queries, to ensuring data lands accurately and on time in downstream systems.
Key Responsibilities
Design and develop complex SQL transformations supporting enterprise integrations between core systems (ERP, order management, warehouse management, product data, and e-commerce platforms).
Implement business logic in SQL ? stored procedures, views, functions, and transformation layers ? translating functional requirements into reliable, maintainable database code.
Develop and maintain Python scripts for data movement, validation, automation, file processing, and API-based integrations.
Perform query and database performance tuning: analyze execution plans, optimize indexing strategies, refactor inefficient queries, and resolve throughput bottlenecks in high-volume transactional and reporting workloads.
Support ETL/ELT pipelines and data workflows across on-prem (DB2/iSeries, SQL Server) and cloud (Azure) environments.
Partner with integration developers to define data mappings, transformation rules, and reconciliation logic for interfaces built on middleware platforms (e.g., Boomi).
Conduct data profiling, root-cause analysis, and data quality remediation for production issues; provide timely resolution for integration and reporting defects.
Document data models, transformation logic, and technical designs; follow change management and deployment standards.
Collaborate with business analysts, QA, and cross-functional IT teams (onsite and offshore) throughout the development lifecycle.
Required Qualifications
Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent practical experience.
7+ years of hands-on SQL development experience, including complex joins, window functions, CTEs, stored procedures, and set-based transformation logic.
Proven experience implementing business rules and data transformations for system-to-system integrations.
2+ years of Python scripting for data processing, automation, or integration tasks (pandas, pyodbc/SQLAlchemy, REST API consumption, or similar).
Demonstrated expertise in performance tuning: reading execution plans, index design, statistics management, and query refactoring on large datasets.
Experience with at least one enterprise RDBMS at scale (SQL Server, DB2, Oracle, or PostgreSQL).
Strong data analysis and problem-solving skills; ability to trace data issues across multiple systems.
Effective communication skills and experience working with distributed onsite/offshore teams.
Preferred Qualifications
Strong hands-on experience with Microsoft SQL Server as the primary development platform (T-SQL, stored procedures, SSMS, query optimization), with the ability to work across heterogeneous database environments.
Working knowledge of IBM DB2 on iSeries/AS400, Oracle, and other enterprise RDBMS platforms ? comfortable reading, querying, and integrating data from these systems as integration sources and targets.
Exposure to Azure data services (Azure SQL, Data Factory, Synapse, Databricks, or Cosmos DB) and hybrid on-prem/cloud data environments.
Familiarity with integration middleware such as Boomi, MuleSoft, or similar iPaaS platforms.
Experience in supply chain, distribution, or retail domains ? order management (IBM Sterling OMS), warehouse management (Infor WMS), or product/master data (STIBO PIM/MDM).
Experience with source control (Git), CI/CD for database code, and Agile delivery.
SQL, Integrations, SQL Server, DB2

Work arrangement
No