Data Warehouse Developer

DefineX Consulting Inc.; Fatih; On-site; TRY 620,000 - 828,000; Full time

Job summary

A consulting firm in Turkey is seeking a Data Warehouse Consultant to lead the modernization of performance management data. The ideal candidate will have 1-3 years of experience in data warehouse projects, strong SQL skills, and the ability to translate business requirements into technical solutions. This role offers growth opportunities and a supportive work environment.

Benefits

20 vacation days per annum

Private health and life insurance coverage

Time off for volunteer work

Qualifications

• 1-3 years of hands-on experience in data warehouse projects.
• Strong knowledge of SQL, data modeling methodologies.
• Experience in ETL flow analysis and design.

Responsibilities

• Lead the analysis, design, and modernization of performance management data marts.
• Work closely with business stakeholders to understand KPI structures.
• Redesign and implement SQL structures and ETL flows.

Skills

SQL

Data modeling methodologies (e.g. Inmon/Kimball)

ETL flow analysis

Communication skills

Client engagement

Education

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

Tools

Oracle

MS SQL Server

Job description

Overview

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 play larger 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 find your forward at 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.
• 1-3 years of hands-on experience in data warehouse projects.
• Strong knowledge of SQL, data modeling methodologies (e.g. Inmon/Kimball), and relational data design.
• Experience in ETL flow analysis, design, and optimization.
• 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.

Growth and Development: Be part of a growing global team with training and support to help you grow. Every DefineXer has a Growth Coach to accelerate their growth through feedback.

Independence and Ownership: 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.

Health and Wellness: Competitive private health and life insurance coverage.

Disclaimer and Privacy

We are an equal opportunity workplace and an affirmative action employer, 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. We will provide reasonable accommodations to applicants as required to ensure equal opportunity in the application process.

Protecting your privacy and the security of your data is a top priority. 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.