Senior Staff Engineer (Data Warehousing, ETL)

TL;DR

Senior Staff Engineer (Data Warehousing, ETL): Designs and develops data warehousing solutions, focusing on ETL processes and data pipeline automation. Focus on understanding client's business use cases, translating them into technical designs, and ensuring adherence to non-functional requirements during project implementation.

Company

hirify.global is a Digital Product Engineering company that builds products, services, and experiences.

What you will do

• Convert client's business use cases and technical requirements into technical designs.
• Translate mapping decisions into developer-friendly requirements.
• Identify and narrow down the best solutions to meet client's requirements.
• Define guidelines and benchmarks for non-functional requirements.
• Write and review design documents explaining overall architecture and high-level design.
• Resolve issues during code review through systematic root cause analysis.

Requirements

• Experience: 7.5+ Years
• Strong SQL scripting expertise, preferably in SQL Server.
• Solid hands-on experience with Data Warehousing design, modeling, and ETL development.
• Experience building and maintaining data pipelines, data integration workflows, and automated jobs.
• Strong understanding of data modeling, including star/snowflake schemas and normalization concepts.
• Good understanding of banking finance processes and financial data structures.

Nice to have

• Familiarity with cloud platforms (AWS/Azure/GCP) and basic knowledge of data storage services.
• Proficiency in Python or Shell scripting for data processing and automation.
• Exposure to SAS DI and SAS EG.

Culture & Benefits

• Dynamic and non-hierarchical work culture.