Data Engineer
Blutic · New York, United States
- On site
- Full-time
- New York, United States
Tailored resume — keyword-matched to this role.
Hiring manager — we find who's hiring.
Intro email — drafted to reach them directly.
About the role
Requirements
- 5+ years of experience in ETL and reporting development
- 5+ years of experience with SQL and writing stored procedures
- 5+ years of experience building ETL pipelines
- 5+ years of experience in Snowflake and DB2 databases.
- Strong knowledge of SQL for reporting and data analysis
- Have Worked in Agile, DevOps and Git
- 3-5 years of experience with Python for ETL and report generation
- Perform of data validation and reconciliation.
- Knowledge of reporting tools such as Business Objects or Tableau is good to have.
- Experience in cloud platforms (Azure/GCP/AWS) good to have
Responsibiliti
- esDesign and build scalable ETL pipelines to ingest, transform and load large volumes of OTC derivatives data for downstream reporting and analytic
- s.Develop and optimize database objects, stored procedures and batch processes that support ETL workflows, report generation and data deliver
- y.Design data models, schemas, SQL views and stored procedures to support efficient ETL processing and regulatory, operational and business reportin
- g.Build and maintain real-time and batch ETL pipelines for trade and confirmation data ingestion, transformation, reconciliation and report-ready data provisionin
- g.Support data migration and onboarding activities by building validation routines, reconciliation checks and ETL cutover processes to ensure reporting continuit
- y.Develop, automate and support regulatory and business reports using Python, SQL stored procedures and enterprise reporting platforms such as Business Objects and Tablea
- u.Write complex SQL queries, stored procedures and reusable reporting logic to generate accurate, timely outputs for business users and regulatory consumer
- s.Ensure strong data controls, access governance and quality checks across ETL pipelines, reporting datasets and database environment
- s.Participate in Agile delivery and contribute to automation, scheduling and CI/CD practices for ETL jobs, reporting workflows and production deployment
- s.Provide production support for ETL and reporting processes, including job monitoring, issue triage, data reconciliation and root cause analysi