Data Integration Engineers

Synechron; New York (NY); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Competitive compensation

Global opportunities

Paid annual leave and holidays

Maternity & paternity leave

Comprehensive insurance

Retirement savings plans

Education benefits

Udemy for Business access

Training & coaching programs

Opportunities with tier-one banks

Job summary

Synechron, a global consulting firm, is seeking a Data Integration Engineer with strong enterprise payment systems experience to join a strategic Digital Payments initiative in New York. You will design and optimize data pipelines, work with SQL, Python (Pandas, PySpark), and cloud data platforms (AWS, Snowflake, Redshift), and collaborate across finance and technology teams.

Ideal candidates understand time-series data, data quality and lineage, and streaming/batch processing with Kafka, Spark,

Qualifications

• Understanding of post-trade data flows including allocations, confirmations, settlement, risk, finance, and regulatory reporting.
• Knowledge of securities data modeling and financial data structures including reference data and transactional trade data.
• Understanding of time-series data management and financial market data is a strong plus.
• Strong SQL development skills with experience designing and optimizing relational data models and database schemas.
• Proficiency in Python with data processing frameworks such as Pandas and PySpark.
• Strong understanding of data warehouse, data lake, and Data Lakehouse concepts.
• Experience with large-scale transactional and analytical data platforms.
• Experience with PostgreSQL, SQL Server, Snowflake, Redshift, Databricks, or similar cloud-native technologies.
• Experience with stream and batch data processing technologies such as Kafka, Spark, Flink.
• Experience building batch and streaming data pipelines using Python and SQL.
• Strong understanding of data quality, data lineage, data validation, and reconciliation processes.
• Experience with messaging technologies such as Kafka, RabbitMQ, IBM MQ.
• Familiarity with Datadog, Prometheus, and Grafana for monitoring and observability.
• Understanding of data security, privacy, and regulatory compliance requirements.
• Exposure to data science, machine learning, and AI/GenAI data preparation concepts is a plus.

Skills

SQL

Python (Pandas, PySpark)

Data warehouse concepts

Cloud platforms (AWS)

Streaming/batch processing

Data quality & lineage

Kafka, Spark, Flink

PostgreSQL/SQL Server/Snowflake/Redash

Databricks

Data modeling

Regulatory/compliance awareness

Tools

Datadog

Prometheus

Grafana

Kafka

RabbitMQ

IBM MQ

PostgreSQL

SQL Server

Snowflake

Redshift

Databricks

AWS

Spark

Flink

Pandas

PySpark

Job description

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,500+, and has 58 offices in 21 countries within key global markets.

We are seeking a skilled Data Integration Engineers with strong experience in enterprise payment systems to join a strategic Digital Payments initiative. Candidates with a solid background in payment processing and modern Java technologies who are eager to learn emerging payment technologies are encouraged to apply.

Required Qualifications

• Understanding of post-trade data flows including allocations, confirmations, settlement, risk, finance, and regulatory reporting.
• Knowledge of securities data modeling and financial data structures. Experience with reference data, security master data, and transactional trade data.
• Understanding of time-series data management and financial market data is a strong plus.
• Strong SQL development skills with experience designing and optimizing relational data models and database schemas.
• Proficiency in Python, including data processing frameworks such as Pandas and PySpark.
• Strong understanding of data warehouse, data lake, and Data Lakehouse concepts.
• Experience working with large-scale transactional and analytical data platforms.
• Experience with PostgreSQL, SQL Server, Snowflake, Redshift, Databricks, or similar database and data warehouse technologies on cloud, preferably AWS.
• Experience with stream and batch data processing technologies such as Kafka, Spark, Flink, or similar platforms.
• Experience building batch and streaming data pipelines, including ETL/ELT workflows, using Python and SQL.
• Strong understanding of data quality, data lineage, data validation, and reconciliation processes.
• Experience working with messaging technologies such as Kafka, RabbitMQ, IBM MQ, or similar platforms.
• Familiarity with monitoring and observability tools such as Datadog, Prometheus, and Grafana.
• Understanding of data security, privacy, and regulatory compliance requirements.
• Exposure to data science, machine learning, and AI/GenAI data preparation concepts is a plus.

We offer:

• A highly competitive compensation and benefits package.
• A multinational organization with 58 offices in 21 countries and the possibility to work abroad.
• 10 days of paid annual leave (plus sick leave and national holidays).
• Maternity & paternity leave plans.
• A comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region).
• Retirement savings plans.
• A higher education certification policy.
• Commuter benefits (varies by region).
• Extensive training opportunities, focused on skills, substantive knowledge, and personal development.
• On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.
• Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups.
• Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms.
• A flat and approachable organization.
• A truly diverse, fun-loving, and global work culture.

SYNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer.

Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all.

We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company.

We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply.

We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.