Product Data Architect

About the job

Sofico is evolving its platform capabilities to deliver scalable, reliable, and future-proof solutions for the Miles Enterprise suite. As part of this evolution, we are strengthening our data streaming platform team.
As a Product Data Architect, you will take a leading role in optimizing migration SQL and data transformation logic in the context of a data streaming platform. You will work closely with product teams, platform engineers, and architects to ensure database workloads are efficient, scalable, and aligned with domain boundaries and long-term product strategy.
This role requires deep Oracle expertise with a product oriented mindset: you will help teams ship domain capabilities safely and fast, while keeping performance, maintainability, and operational excellence as a focus point.

Your responsibilities

• Lead the analysis and optimization of complex migration SQL (bulk loads, delta processing, reconciliation) used in data streaming & initial load flows.

• Partner with product teams to translate domain and non-functional requirements into high-performance data access and transformation designs.

• Support domain-driven delivery by aligning database models and migration logic with Domain Driven Design concepts.

• Establish and maintain standards for SQL quality, review practices, and performance testing (benchmarks, regressions, workload simulation).

• Contribute to observability and operational readiness: instrumentation, performance dashboards, alert thresholds, and troubleshooting.

• Document decisions (ADRs) and coach teams on best practices.

Your Profile

• Significant hands-on experience with Oracle Database in production environments (performance tuning and troubleshooting at scale).

• Strong SQL expertise, including the ability to optimize complex queries and migration scripts with measurable outcomes.

• Proven experience with Oracle performance tooling and concepts.

• Solid understanding of data migration patterns and reliability concerns (idempotency, consistency, reconciliation, error handling, etc.).

• Clear communicator who can explain trade-offs to both technical and non-technical stakeholders and collaborate across teams.

What we offer you

• Competitive salary package

• Company car with fuel card/ charging card

• Meal vouchers

• Group and hospitalization insurance

• Additional benefits: bike leasing, flexible working hours, work from home up to 2 days per week

Join an international, multicultural company with more than 35 years of experience, which doubles in size every 5 years. We encourage a horizontal, open corporate culture where career development and personal growth are central. You benefit from a comprehensive 6-month onboarding, including a dedicated job coach, and receive ongoing learning opportunities. Participate in fun team activities such as after-work drinks, barbecues, family days, and company weekends. Additionally, you work in a modern and easily accessible office, equipped with charging stations for electric cars and bikes, as well as free shared bikes.