Senior Data Warehouse Developer

DefineX Consulting Inc.; Fatih; On-site; TRY 100,000 - 130,000; Full time

Job summary

A next-generation consulting firm in Turkey is seeking a Data Management Consultant to lead the analysis and modernization of data systems in the banking sector. The ideal candidate will have at least 4 years of experience with SQL and ETL processes, contributing to critical data-driven initiatives. Join a dynamic team focused on transforming technology in finance, with benefits including 20 vacation days and private health insurance.

Benefits

20 vacation days per annum

Private health and life insurance

Volunteering opportunities with local NGOs

Qualifications

• Min 4 years of hands-on experience in data warehouse projects, preferably in banking.
• Strong knowledge of relational data design.
• Experience working with Oracle and MS SQL Server environments.

Responsibilities

• Lead modernization of performance management data marts within the bank’s DWH.
• Work closely with stakeholders to understand KPI structures.
• Provide guidance on DWH modernization best practices.

Skills

SQL

Data modeling methodologies

ETL flow analysis

Communication skills

Education

Bachelor’s or Master’s degree in Computer Engineering, MIS, Statistics

Tools

Oracle Data Integrator (ODI)

Oracle

MS SQL Server

Job description

DefineX Team:

DefineX is a next-generation consulting house and venture builder, helping financial institutions shape bold visions and turn them into real-world impact focusing on two core themes: Winning in Tech and Winning in Digital.

At the heart of everything we do? Our people: DefineXers. A diverse team of consultants, engineers, designers, and strategists driven by purpose and united by a shared ambition: to build what’s next.

We don’t just aim high, we playLarger Than Life. It’s more than a motto. It’s the game we’ve chosen.

If you’re ready to learn fast, think sharp, and solve real problems, this role is for you.

Apply now and#FindYourForwardat DefineX.

Your Impact:

• Lead the analysis, design, and modernization of performance management data marts within the bank’s enterprise DWH.
• Work closely with business stakeholders to understand KPI structures, target/actual data models, and reporting logic.
• Redesign and implement SQL structures and ETL flows to ensure scalability, flexibility, and performance.
• Translate functional business requirements into optimized source-to-target data mappings and transformation logic.
• Contribute to metadata modeling, data quality frameworks, and governance practices.
• Provide guidance on best practices in DWH modernization using ODI, Oracle, and other enterprise-grade tools.
• Collaborate with client teams in agile environments and provide consultancy support throughout the project lifecycle.

What You Bring to the Table:

• Bachelor’s or Master’s degree in Computer Engineering, MIS, Statistics, or a related field.
• Min 4 years of hands-on experience in data warehouse projects, preferably in the banking or financial domain.
• Strong knowledge of SQL, data modeling methodologies (e.g. Inmon/Kimball), and relational data design.
• Proven experience in ETL flow analysis, design, and optimization.
• Practical knowledge and project experience with ODI (Oracle Data Integrator) is a significant advantage.
• Exposure to performance management or financial KPI reporting processes is a strong plus.
• Familiarity with enterprise data warehouse modernization and cloud migration projects is a plus.
• Experience working with Oracle or MS SQL Server environments.
• Strong communication skills, with the ability to translate complex technical solutions into business terms.
• A proactive, self-driven consultant mindset who enjoys client engagement and solving real-world data problems.

Benefits and Perks:

We highly value:A mentally and physically enabling environment where Best People want to be part of; we always respect and invest in talent to foster team success.

GrowthandDevelopment:Be part of a growing global team of professionalswith training and support to help you grow.
EveryDefineXer has aGrowthCoachtoacceleratetheirgrowththroughfeedback!

IndependenceandOwnership: Blur in creative and challenging business and technology transformation projects.

Time Off:20 vacation days per annum.

We love to Give Back:You will get certain hours a year to volunteer and organize office volunteer programs with local NGOs.

HealthandWellness: Competitive private health and life insurance coverage.

Need more convincing that DefineX is a great place to work?

• Follow us on Instagram to take a deep dive into who we really are: IG@teamdefinex!
• Get to know more about ourextraordinary minds,
• Also,hearfrom our tech leaders as they talk about why they love what they do and how the culture at DFX enables them to take part in exciting projects!

At DefineX, we don't just accept difference - we celebrate it, we support it, and we thrive on it for the benefit of TeamDefineX! We are proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, marital status, disability, gender identity or veteran status. TeamDefineX will advocate for, and provide reasonable accommodations to those applicants requiring them, based on the Turkish Disabilities Act, to ensure equal opportunity in the application process.

Protecting your privacy and the security of your data is a top priority for DefineX Consulting | Technology | Labs. We collect and process your personal data as confidential as part of the recruitment process. Please read our Statement of Personal Data Protection Law and Consent Letter to know more details.