Hybrid Data Engineer: Real-Time ETL & Regulatory Reporting

Blutic; New York (NY); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Hybrid work model

New York office

Job summary

Blutic is seeking a Data Engineer with 5+ years of experience in ETL, database design and reporting development. The role focuses on building scalable real-time and batch pipelines for OTC derivatives data, onboarding datasets, and developing regulatory and business reports using SQL, Python, Snowflake, DB2, and tools like Business Objects or Tableau.

This is a W2 hybrid opportunity in New York.

Experience with data governance, CI/CD and data security is expected.

Qualifications

• 5+ years in ETL and reporting development.
• 5+ years SQL experience and writing stored procedures.
• Experience with Snowflake and DB2 databases.
• Experience with cloud platforms (Azure/GCP/AWS) is a plus.

Responsibilities

• Design and build scalable ETL pipelines for OTC derivatives data.
• Develop and optimize database objects and batch processes for ETL workflows and reporting.
• Design data models, SQL views, and stored procedures for ETL and regulatory reporting.
• Build real-time and batch pipelines for data ingestion, transformation, reconciliation and provisioning.
• Support data migration and onboarding with validation routines and cutover processes.
• Develop, automate and support regulatory and business reports using Python and SQL in enterprise reporting platforms like Business Objects and Tableau.
• Write complex SQL queries and reusable reporting logic for business users and regulatory consumers.
• Ensure data controls, access governance and quality checks across ETL pipelines and databases.
• Participate in Agile delivery and CI/CD practices for ETL jobs and reporting workflows.
• Provide production support for ETL and reporting processes including monitoring and root-cause analysis.

Skills

ETL

SQL

Python

Snowflake

DB2

Tableau

Business Objects

Agile/DevOps

Data governance

Job description

Blutic is seeking a Data Engineer with 5+ years of experience in ETL, database design and reporting development. The role focuses on building scalable real-time and batch pipelines for OTC derivatives data, onboarding datasets, and developing regulatory and business reports using SQL, Python, Snowflake, DB2, and tools like Business Objects or Tableau.

This is a W2 hybrid opportunity in New York.

Experience with data governance, CI/CD and data security is expected.