data engineer in banking
Summary
A data engineer building and maintaining a bank's core SQL Server data warehouse: onboarding new data sources, writing complex T-SQL, automating reporting, and migrating legacy MS Access/Excel setups into modern pipelines using Python, Apache Airflow, and Git.
Описание:
OBSS is Turkey’s largest technology consultancy, providing product development and technology consulting for an AI-native future. The company serves organizations in banking and finance, insurance, e-commerce, retail, and the startup ecosystem.
Задачи:
- Onboard new data sources into the Data Warehouse from staging through data marts while maintaining strict data quality standards;
- Maintain, optimize, and continuously develop the core SQL Server data warehouse;
- Execute user stories focused on source onboarding, adding new fields, and delivering custom reporting requests;
- Reverse-engineer complex legacy setups based on MS Access, Excel reports, and text files into scalable data solutions;
- Collaborate with cross-functional business teams across the bank to automate reporting environments and align technical solutions with business needs.
Требования:
- At least 5+ years of experience in Data Modeling, Database Administration, and Database Management;
- 5+ Years of deep T‑SQL development experience, including complex stored procedures, functions, views, triggers, and query optimization;
- At least 3+ years of banking‑sector experience with in-depth knowledge of financial products, core banking systems, and their underlying data structures;
- Expertise in Python and Apache Airflow for pipeline development and workflow orchestration;
- Strong knowledge of Git and collaborative version control workflows;
- Practical experience reverse‑engineering complex legacy setups involving MS Access, Excel, and text files and migrating them into modern data pipelines;
- Exceptional problem‑solving and analytical skills focused on automation;
- Effective communication skills for conveying technical concepts to non‑technical stakeholders.
Условия:
- Flexible and hybrid working arrangements;
- Competitive salary;
- Training programs, certifications, and workshops;
- Personalized Individual Growth Program with development goals, trainings, certifications, and personal development milestones;
- Mentorship, knowledge sharing, and participation in tech communities, workshops, and team events.