Data Architect (Consultant)

OREDATA is a Digital Transformation & IT Consulting firm with 10+ years of proven expertise and hundreds of successfully implemented projects across the EMEA region. When you join the OREDATA team, you'll be working hand-in-hand with experts focused on tackling digital, operational, analytical & data science challenges with the greatest impact. We foster collaboration with proximity, an agile and autonomous approach and best practices and guiding principles.

Read more: https://medium.com/@oredata-engineering

Apply and be part of our exciting journey!
About the Role

We are looking for an experienced Senior Data Architect to lead the assessment and modernization of our client's existing data environment and help shape the future architecture of their enterprise data platform. (Cargo Industry)

The current environment includes a complex Data Warehouse ecosystem, MsSQL and SSIS-based ETL processes, multiple reporting environments, and legacy systems. The successful candidate will be responsible for understanding the existing architecture, identifying improvement opportunities, and defining the roadmap toward a modernized data platform.

This role requires someone who can combine strong Data Warehouse and data architecture fundamentals with modern cloud data platform knowledge, and who is comfortable taking end-to-end architectural ownership and driving the transformation journey proactively from start to finish.
Responsibilities
- Analyze and assess the existing Data Warehouse architecture, data models, MsSQL environment, SSIS-based ETL processes, and data flows.
- Identify architectural issues, ETL performance bottlenecks, technical dependencies, and modernization opportunities.
- Define the target architecture and transformation roadmap from the existing Data Warehouse environment toward a modernized data platform.
- Lead the architectural design of the future enterprise data platform.
- Redesign and optimize existing data models and structures in line with industry best practices.

- Define architectural principles, standards, patterns, and guidelines for the new data platform.
- Evaluate appropriate cloud technologies and architectural approaches based on business and technical requirements, with experience in at least one of GCP, Azure, or AWS.
- Lead the architectural foundation of Data Governance initiatives. Help establish standards and practices for data quality, data ownership, metadata management, data lineage, security, and access.
- Communicate and collaborate with different teams on both technical and business matters, working closely with Business Intelligence, ETL/Data Engineering teams, and relevant stakeholders
- Provide architectural and technical guidance to teams throughout the transformation.
- Ensure architectural decisions support scalability, performance, security, maintainability, and long-term sustainability.

- Take end-to-end ownership of the transformation journey, proactively driving progress and decision-making rather than waiting for direction
- Travel to the client's Istanbul location when required by the project.