ETL Data - Senior Engineer

Job Description

We are seeking two highly skilled Data & Reporting Engineers to support a critical initiative: the migration of our existing reporting suite to a modernized reporting platform. These roles are essential to ensuring continuity, accuracy, and scalability of business-critical reporting across multiple systems.
The ideal candidates will have strong experience with SQL-based data environments, proficiency in Java development, and a demonstrated ability to transform and organize data from multiple sources into clear, actionable outputs. Experience in financial services-particularly in trading, securities workflows, or Order Management Systems (OMS)-is highly desirable.
This is a high-impact, high-visibility opportunity to contribute to a fast-moving project with immediate business priority.

Key Responsibilities
. Design, develop, and migrate reports from a legacy reporting platform to a new reporting ecosystem
. Write and optimize complex SQL queries across MSSQL and PostgreSQL databases
. Develop and maintain ETL processes using SSIS and related tools
. Utilize tools such as SQL Server Management Studio (SSMS) and DBeaver for querying and data exploration
. Build and maintain Java-based components to support reporting workflows and data processing
. Integrate data from multiple internal and external sources into cohesive reporting structures
. Ensure data accuracy, consistency, and performance across all reporting outputs
. Collaborate with business stakeholders to translate reporting requirements into technical solutions
. Validate and reconcile reports to ensure alignment with legacy outputs during transition
. Document data flows, transformation logic, and reporting definitions
. Assist in identifying opportunities to improve performance, scalability, and maintainability of reporting systems

Required Qualifications
. 3-7+ years of experience in data engineering, reporting development, or similar role
. Strong proficiency in:
o SQL (MSSQL and PostgreSQL)
o SQL Server Management Studio (SSMS)
o ETL tools, especially SSIS
. Hands-on experience querying PostgreSQL environments (preferably using DBeaver or similar tools)
. Solid experience writing and maintaining Java code in production environments
. Proven ability to work with complex data models and integrate data from multiple sources
. Strong analytical and problem-solving skills with attention to detail
. Ability to work independently in a fast-paced environment with tight timelines

Preferred Qualifications (Nice to Have)
. Experience with Order Management Systems (OMS) or trading platforms
. Understanding of securities lifecycle, trading workflows, and financial instruments
. Familiarity with regulatory reporting requirements (e.g., trade reporting, compliance data)
. Experience with data warehousing concepts (star schemas, normalization, dimensional modeling)
. Knowledge of performance tuning and query optimization techniques
. Exposure to modern data pipelines, automation, or orchestration tools
. Experience working in Agile or iterative delivery environments

Key Competencies
. Strong data organization and transformation skills
. Ability to translate complex data into business-friendly outputs
. Effective communication with both technical and non-technical stakeholders
. Detail-oriented with a focus on data quality and accuracy
. Proactive and solution-oriented mindset

Mandatory Competencies