Senior Data & Analytics Consultant

Odensoft; Fatih; On-site; TRY 350,000 - 550,000; Full time

Benefits offered by this job

Competitive salary

Collaborative environment

Professional growth opportunities

Job summary

Odensoft, a boutique consultancy, seeks a Senior Data & Analytics Consultant to lead large-scale data transformation projects for market-leading enterprises across industries. You will design and implement ETL/ELT pipelines, build data warehouses, and mentor teammates while shaping the technical direction of the program.

The role emphasizes data quality, governance, and collaboration with cross-functional teams; strong SQL/PL-SQL and Informatica PowerCenter skills are required, with a background

Qualifications

• Bachelor's or Master's degree in Computer Science, Engineering, Information Technology, or a related field.
• 4-7 years of experience in data engineering or a similar role.
• Advanced knowledge of SQL is a must; PL/SQL is a plus.
• Strong experience with data integration tools; Informatica PowerCenter knowledge is preferred.
• Solid understanding of data architecture, modeling, and integration processes.
• Proven experience in dimensional and relational data modeling for enterprise data warehouses.
• Excellent data management skills, including database optimization and data governance.
• Strong problem-solving skills, attention to detail, and ownership mindset.
• Excellent communication skills and ability to work effectively in a team environment.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines and data integration processes using enterprise integration tools.
• Contribute to the design and development of enterprise data warehouse (DWH) solutions, from data modeling to end-to-end data flows.
• Collaborate with cross-functional teams to gather requirements and deliver high-quality data solutions.
• Ensure data quality, reliability, and security across all systems.
• Establish data management best practices and standards across projects.
• Manage and optimize databases and data storage solutions.

Skills

SQL

PL/SQL

Informatica PowerCenter

Data modeling

ETL/ELT

Data warehouse

Data governance

Communication

Teamwork

Education

Bachelor's or Master's in CS/Engineering/IT

Job description

At Odensoft, we turn data into a strategic asset. As a boutique consultancy with a global mindset, we work with organizations across the insurance, telecommunications, manufacturing and banking industries to design and deliver data-driven solutions that enable confident, forward-looking decisions.

We are seeking a Senior Data & Analytics Consultant to join our team and take a key role in delivering and driving an ongoing, large-scale data transformation program at a market-leading enterprise organization. This position offers the opportunity to take ownership, influence technical direction, and mentor others while building high-impact data platforms.

Key Responsibilities

• Design, develop, and maintain ETL/ELT pipelines and data integration processes using enterprise integration tools.
• Contribute to the design and development of enterprise data warehouse (DWH) solutions, from data modeling to end-to-end data flows.
• Collaborate with cross-functional teams to gather requirements and deliver high-quality data solutions.
• Ensure data quality, reliability, and security across all systems.
• Establish data management best practices and standards across projects.
• Manage and optimize databases and data storage solutions.

Qualifications

• Bachelor's or Master's degree in Computer Science, Engineering, Information Technology, or a related field
• 4-7 years of experience in data engineering or a similar role
• Industry experience in insurance is an advantage
• Advanced knowledge of SQL is a must; PL/SQL is a plus
• Strong experience with data integration tools is required; Informatica PowerCenter knowledge is preferred
• Solid understanding of data architecture, data modeling, and data integration processes
• Proven experience in dimensional and relational data modeling for enterprise data warehouses
• Excellent data management skills, including database optimization and data governance
• Strong problem-solving skills, attention to detail, and ownership mindset
• Excellent communication skills and ability to work effectively in a team environment

What We Offer

• Hands-on involvement in large-scale data programs for leading enterprises across multiple industries.
• Competitive salary and benefits package.
• Opportunities for professional growth and development.
• Collaborative and innovative work environment.