Sr. Data Engineer

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

Benefits offered by this job

Competitive compensation

Global offices in 21 countries

10 days paid annual leave

Maternity & paternity leave

Comprehensive insurance plans

Training & Udemy access

Job summary

Synechron seeks a Data Engineer to design and optimize data models for financial data, including reference, security master, and transactional trade data. You will develop scalable data pipelines, working with PostgreSQL, SQL Server, Snowflake, Redshift, and Databricks on AWS.

Knowledge of Kafka and batch/streaming processing is essential. The role emphasizes data quality, lineage, and regulatory compliance, with exposure to AI/GenAI data prep as a plus.

Qualifications

• Experience with post-trade data flows and financial data structures.
• Proficiency in SQL development and relational data modeling.
• Strong Python data processing using Pandas or PySpark.
• Experience with data warehouse, data lake, and Data Lakehouse concepts.
• Experience with cloud data platforms (AWS) and data integration pipelines.
• Knowledge of streaming and batch data processing (Kafka, Spark, Flink).
• Familiarity with data quality, lineage, validation, and reconciliation processes.
• Exposure to data science/ML data prep is a plus.

Responsibilities

• Understand post-trade data flows including allocations, confirmations, settlement, risk, finance, and regulatory reporting.
• Model securities data and reference data with robust data structures.
• Design and optimize relational data models and database schemas.
• Develop data pipelines using Python/SQL (ETL/ELT).
• Build batch and streaming pipelines on cloud data platforms.
• Ensure data quality, lineage, and reconciliation throughout pipelines.
• Work with messaging systems (Kafka, RabbitMQ, IBM MQ).
• Utilize observability tools (Datadog, Prometheus, Grafana).

Skills

SQL development

Python

Pandas

PySpark

Data warehousing

Data Lake/Lakehouse

Cloud data platforms (AWS)

Database technologies (PostgreSQL, SQL

Tools

Databricks

Snowflake

Redshift

DBMS (PostgreSQL, SQL Server)

Kafka

RabbitMQ/IBM MQ

Grafana/Datadog/Prometheus

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 Engineer with strong experience data modeling and financial data structures. Experience with reference data, security master data, and transactional trade data.

Job responsibility

• 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.