Ocean Technologies Group logo
Ocean Technologies Group

Powering teams that deliver for people & planet, with maritime learning, crew and fleet management and GRC solutions

Data Architect

Data EngineerData EngineerFull TimeRemoteLeadTeam 201-500Since 2020H1B No SponsorCompany SiteLinkedIn

Location

Romania

Posted

2 days ago

Salary

0

Seniority

Lead

Postgraduate Degree8 yrs expEnglishApacheSQL

Job Description

Data Architect

Ocean Technologies Group

• Own the data architecture across OneOcean's data organisation — operational, lakehouse, analytical-serving and vector layers — providing a coherent target state and a pragmatic path to it. • Lead the discovery, documentation and specification of the data structures and models required to support product and analytics roadmaps. • Reverse-engineer source data from OneOcean SaaS products — building accurate logical models of upstream systems and identifying the data contracts, grain and semantics our pipelines depend on. • Design the right data store for each use case — choosing between OLTP, columnar / OLAP, lakehouse and vector approaches; making the trade-offs explicit. • Define and maintain conceptual, logical and physical data models; produce clear ERDs, lineage and dimensional designs (star / snowflake, conformed dimensions, surrogate keys). • Establish and enforce modelling standards, naming conventions, data contracts and schema-evolution practices across teams. • Partner with the Data Team Lead, BI Team Lead and AI Team Lead — translating product and analytics needs into specifications their engineers can build from, and unblocking architectural decisions as they arise. • Collaborate with Product, Architecture and Engineering Team Leads to align data direction with the wider engineering strategy. • Champion data governance — cataloguing, lineage, ownership, quality, security and privacy. • Document architectural decisions (ADRs) so the why is preserved alongside the what. • Mentor engineers across the data organisation on modelling, design and architectural reasoning — without line-managing them. • Stay current with the data landscape and bring in proven techniques as they mature; foster a culture of continuous improvement, innovation and knowledge sharing.

Job Requirements

  • 8+ years of commercial experience in data engineering, BI engineering or data architecture roles, with significant time spent on modelling and specification.
  • Demonstrable experience owning data architecture across multiple workloads — operational, analytical, lakehouse and (ideally) AI / vector.
  • Deep data-modelling expertise — conceptual, logical and physical; dimensional / star-schema; SCD; data contracts; semantic-layer design.
  • Strong SQL across multiple dialects; comfortable reading and reasoning about complex source-system schemas.
  • Proven ability to reverse-engineer SaaS / operational systems — discovering grain, primary keys, relationships, soft-delete patterns and quirks that aren't in the docs.
  • Solid working knowledge of analytical serving (e.g. Apache Druid, Apache Superset, Power BI) and the modelling patterns that make them perform.
  • Working knowledge of lakehouse approaches (e.g. Delta Lake) — MERGE semantics, partitioning, schema evolution.
  • Pragmatic decision-making — able to balance ideal architecture against delivery pressure and explain the trade-offs clearly.
  • Excellent written and visual communication — produces specifications and diagrams that engineers can build from with minimal ambiguity.
  • Exceptional collaboration and stakeholder skills — comfortable bridging engineering, BI, AI, product and business audiences.
  • Documentation discipline — Confluence-grade architectural records, ADRs, model dictionaries and onboarding material.

Related Categories

Related Job Pages

More Data Engineer Jobs

Ziff Davis logo

Data Architect

Ziff Davis

Ziff Davis, Inc. is an internet and media company whose portfolio includes leading media, entertainment, cybersecurity, and health brands. The company’s brand

Data Engineer2 days ago

• Design and implement scalable data models, storages and pipelines for critical product features • Drive the evolution of our data platform to meet future needs of real-time big data processing • Create and evolve architectural roadmaps for the data platform • Turn product requirements into viable and scalable data architectures and implementations • Act as a bridge between data science, product engineering, and stakeholders • Establish and follow data governance frameworks, standards, and best practices • Mentor senior engineers and architects on complex data modeling and distributed system challenges

Spain
€80K - €95K / year

Role Description Step into a role where you don’t just work with data—you bring it to life. You’ll help design, build, and maintain powerful, scalable data pipelines and platforms that keep our data easy to find, trustworthy, and ready for real-world use. Get hands-on with cutting-edge tools like Databricks and modern cloud technologies as you automate ETL processes, uncover insights from rich geospatial data, and champion best practices in metadata, testing, and governance. You won’t just be part of the team—you’ll be right at the heart of it, helping turn our data strategy into reality and shaping the next generation of our data lakehouse. Responsibilities - Build and Maintain - Design, build, and run robust data pipelines using Databricks and AWS, transforming large-scale geospatial datasets into high-quality, usable data. - Automate core ETL processes to enable smooth, reliable, and scalable data flows across the organisation. - Play a key role in shaping and delivering our medallion architecture, ensuring well-structured bronze, silver, and gold layers that power our data products. - Support the development of metadata frameworks and data cataloguing, making our data easier to find, understand, and trust. - Collaborate and Support - Partner with senior engineers and product teams to deliver data products that are not just reliable, but genuinely useful and easy to work with. - Get stuck into code reviews—sharing ideas, learning from others, and helping the whole team level up. - Be an advocate for best practices in testing, governance, and documentation, helping to build a strong and consistent data culture. - Maintain Excellence & Innovate - Contribute to automated data testing frameworks that keep data accurate, consistent, and geospatially sound. - Spot opportunities to make things faster and better—optimising pipelines and queries with techniques like spatial indexing. - Keep everything aligned with security, licensing, and governance standards—no shortcuts. - Stay curious and proactive, exploring new tools and smarter ways of working to keep improving how we handle data. Qualifications - Data Engineering & ETL: Skilled, Essential - Cloud Platforms (Databricks/AWS): Skilled, Essential - Programming (Python): Skilled, Essential - SQL & Spatial Databases: Skilled, Essential - Data Transformation: Skilled, Essential - Geospatial Tools: Competent, Desirable - Data Visualisation / BI: Competent, Desirable Our Culture in Action - Addresscloud 8 Core Elements - Customer Focus - Growing Yourself and Others - Innovation by Nature - Organisational Maestro - All-in Commitment - High-Quality/High-Impact Work - Teamwork & Collaboration - Narrative Advantage

United Kingdom

Role Description We are looking for a freelance Data Engineer focused on data integration to build and maintain the pipelines that connect our many source systems into a unified, trustworthy data foundation. You will design ETL/ELT processes, integrate APIs and third-party platforms, model data for reporting, and ensure data quality across the organization. This is a fully remote role working closely with analytics, finance, and engineering stakeholders. Key Responsibilities - Design, build, and maintain scalable ETL/ELT pipelines that move and transform data between systems. - Integrate data from diverse sources — APIs, databases, SaaS platforms, flat files, and spreadsheets — into a central warehouse. - Develop and maintain connectors and reconciliation logic across business systems (e.g., project management, time-tracking, finance, and invoicing tools). - Model and structure data for analytics, reporting, and downstream applications. - Implement data validation, quality checks, monitoring, and alerting to ensure accuracy and reliability. - Optimize queries, storage, and pipeline performance for cost and speed. - Document data flows, schemas, mappings, and transformation logic. - Collaborate with analysts, finance, and engineering teams to understand requirements and deliver clean, usable datasets. - Support data governance, security, and privacy best practices. Qualifications - 3+ years of experience in data engineering, data integration, or a closely related role. - Strong SQL skills and experience with relational databases (PostgreSQL, MySQL, SQL Server). - Proficiency in Python (or a comparable language) for data processing and automation. - Hands-on experience building ETL/ELT workflows and orchestration (e.g., n8n, or similar). - Experience integrating REST APIs, webhooks, and third-party SaaS data sources. - Experience with data warehouses (BigQuery, Snowflake, or similar). - Understanding of data modeling, warehousing concepts, and data quality practices. - Comfort working with messy, real-world data across formats (CSV, Excel, JSON, XML). - Strong problem-solving skills and clear communication in a remote team. Nice to Have - Experience with cloud data platforms (AWS, or Azure). - Exposure to finance or operational data and cross-system reconciliation. - Experience with BI/visualization tools (Looker, Power BI, Tableau). - Experience in an agency or multi-entity, multi-currency environment. Benefits - Fully remote working with flexible hours. - A collaborative team spanning engineering, analytics, and finance. - Competitive salary and benefits package. How to Apply Submit your CV along with examples of pipelines, integrations, or data projects you have delivered.

Worldwide
UFS Tech logo

Lead Data Engineer

UFS Tech

Technology Outfitter for Community Banks. Empowering community banks and our people to thrive - together.

Data Engineer2 days ago
Full TimeRemoteTeam 51-200Since 1991H1B No Sponsor

• Design the lakehouse: Apache Iceberg (or similar technology) on object storage, a catalog for table management and per-bank isolation, dbt models, and a query engine • Build secure, least-privilege ingestion from bank systems — log-based CDC where permitted, with query-based and batch/SFTP fallbacks, plus an in-bank collector pattern • Own data modeling for the semantic and metric layer (deposits, concentration, uninsured exposure, asset quality, and peer groups) • Handle schema drift, data quality, and reconciliation; make ingestion observable and recoverable • Partner with the AI/ML team on the structured-query path and with Security on PII classification at landing, in alignment with regulatory data-handling requirements • Document data lineage, transformation logic, and access controls to support audit and exam readiness • Define and enforce data contracts, quality thresholds, and alerting for pipeline failures

United States