Keyrus logo
Keyrus

#MakeDataMatter #HumanizingTheFuture

Senior Data Warehouse Architect, Data Vault 2.0

Data EngineerData EngineerContractRemoteSeniorTeam 1,001-5,000Since 1996H1B SponsorCompany SiteLinkedIn

Location

Portugal

Posted

11 days ago

Salary

€50K - €60K / year

Seniority

Senior

Bachelor Degree7 yrs expEnglishAirflowCloudETLSQLVault

Job Description

Senior Data Warehouse Architect, Data Vault 2.0

Keyrus

• Design, implement, and maintain enterprise data warehouse solutions following Data Vault 2.0 methodology • Develop and optimise Hubs, Links, Satellites, PIT, and Bridge tables • Lead conceptual, logical, and physical data modelling activities across multiple initiatives • Define and promote data architecture standards, modelling guidelines, naming conventions, and documentation practices • Ensure scalability, performance, reliability, and maintainability of data warehouse architectures • Provide technical leadership and architectural guidance to Data Engineers and development teams • Drive the standardisation and automation of ELT processes, metadata management, and deployment practices • Collaborate closely with Business Analysts, Product Owners, Data Governance teams, and other stakeholders to translate business requirements into robust data solutions • Support reporting and analytics teams by delivering optimised and business-ready data structures

Job Requirements

  • Minimum 7 years of experience in Data Engineering, Data Architecture, Business Intelligence, or Data Warehouse environments
  • Proven expertise in Data Vault 2.0 modelling and architecture
  • Strong experience designing and implementing enterprise-scale Data Warehouse solutions
  • Advanced SQL skills and strong data modelling expertise
  • Experience with modern cloud data platforms (Snowflake, Databricks, etc.)
  • Experience with ETL/ELT tools and orchestration frameworks (DBT, Airflow, etc.)
  • Strong understanding of: Data Governance, Metadata Management, Data Lineage, Master Data Management (MDM), DataOps practices
  • Experience providing technical leadership and architectural guidance to engineering teams
  • Fluency in English
  • Must be a Portuguese or European citizen, or hold a valid work permit for Portugal

Benefits

  • Meal allowance: €10.20/day
  • Flexible benefits plan
  • Private medical insurance
  • 22 days of annual leave, increasing every 3 years (up to 25 days)
  • Continuous learning via KLX – Keyrus Learning Experience
  • A collaborative, international, and human-centred work environment

Related Categories

Related Job Pages

More Data Engineer Jobs

Essnova Solutions, Inc. logo

Data Engineer, Data Modeler

Essnova Solutions, Inc.

Federal contracting company specializing in technical, geospatial, healthcare, and administrative solutions.

Data Engineer11 days ago
Full TimeRemoteTeam 11-50Since 2005H1B No Sponsor

• Designing and maintaining scalable database architectures for analytical workloads, ensuring optimal performance through indexing, partitioning, caching, and query tuning. • Developing, automating, and maintaining data ingestion, transformation, validation, and loading pipelines to support high-quality data flows. • Building reusable data connection modules and backend infrastructure components to streamline data operations and support future scalability. • Supporting data preprocessing, normalization, and rigorous data quality validation processes. • Contributing to cloud migration planning, governance, and evaluation of cloud solutions for security, compliance, interoperability, and performance. • Producing comprehensive data models, architecture diagrams, flowcharts, and technical documentation for internal and external stakeholders. • Utilizing PowerShell scripting and automation to enhance data engineering workflows and system integration. • Collaborating with technical, security, and stakeholder teams throughout the project lifecycle to deliver high-impact data solutions.

United States
Air InfoSec logo

Data Architect

Air InfoSec

Where mission meets momentum. Veteran-built. Future-focused.

Data Engineer11 days ago
ContractRemoteTeam 1-10Since 2023H1B No Sponsor

• Design the vision and blueprint of the organization's data framework to support public health informatics objectives. • Design and manage data systems, establishing policies for how data is stored, accessed, and governed. • Coordinate various data sources within the organization to ensure consistency and integrity across the data environment. • Integrate new data technologies into existing IT infrastructures. • Perform data modeling and design activities to support reporting, analytics, and operational needs. • Develop and maintain ETL pipelines to support data movement and transformation. • Write and optimize SQL queries in support of data operations and system requirements. • Administer database environments in coordination with application and infrastructure teams. • Submit weekly status reports detailing completed and ongoing project activities, including risks as applicable. • Maintain accurate records of work performed and hours expended in accordance with OTS Task Order requirements.

Louisiana
$56 - $66 / hour

Senior Data Engineer

Gordon Food Service - GFS

Gordon Food Service (GFS) is self-described as North America's largest family-operated broad-line food distribution company. The company believes in the "power

Data Engineer11 days ago

Title: Senior Data Engineer Location: - Wyoming, Michigan - Atlanta, Georgia time type Full time Job Description: Welcome to Gordon Food Service! We are excited that you are thinking about opportunities with us, and we have an amazing story to share. See below for a quick glance of who we are and the impact you could have on the food service industry. There's a seat at our table for you... Position Summary: The Senior Data Engineer guides the development of GFS' Data Platform consisting of the data lake, analytics, enterprise data sandboxes, and certified internal data products. Identifies and translates Big Data challenges into technical approaches yielding actionable recommendations across multiple, diverse domains. Helps define the team's technical design principles and has the tenacity to implement them. Guides the Data Engineering team in their collaboration with teams across IT as well as the organization. Contributes to the design and architecture of Data Engineering technical solutions in an agile and incremental manner. Empathizes with the challenges the business faces and helps develop a technical solution to address them. Is a leader in refining and following team processes to increase efficiency and capacity. Has extremely strong personal skills to develop relationships with and become a mentor to more junior developers. What you will do: - Provide expertise and guidance in defining the technical strategy and direction for the Data Platform environment at GFS, including tools, techniques, and processes. - Provide guidance to the scrum master and product owner to determine priority and effort for features. - Mentor to other team members in the appropriate use and application of new and existing tools and processes. - Design and build technology solutions across multiple initiatives at the same time. - Automate repetitive data engineering tasks and build proactive monitoring and alerting systems. - Collaborate with others inside and outside of IT to rapidly architect, design, prototype, and implement technical architectures to deliver insightful solutions. - Translate business analytics problems into technical solutions that yield actionable recommendations across multiple, diverse domains. - Document technical designs and systems thoroughly to ensure long-term sustainability and ease of knowledge transfer within the team - Help build a high-performing team focused on results and relationships within and outside of the team. - Perform other duties as assigned. When you will work: - Monday to Friday, 8am to 5pm - Hybrid schedule, 4 days in office in Wyoming MI or Atlanta GA, with 1 day remote What you will bring to the table: - Bachelor's degree in Computer Science, Information Technology, Advanced Analytics, Statistics, or related field required. - At least 8 years of experience in technical design, development, and delivery of data engineering technical solutions. - Highly experienced with cloud computing platforms, preferably Google Cloud Platform (GCP). - Deep experience with Change Data Capture (CDC) processes (Qlik Replicate preferred) and relational database management/optimization (specifically PostgreSQL and SQL Server). - Highly experienced in modern data movement technologies (e.g. serverless, real-time, as needed computing, low latency data movement, high volume data management, etc...). - Proven track record as a self-starter and quick learner with strong documentation skills, capable of taking ownership of existing systems. - Expert in modern devops practices to deliver code quickly with a high degree of confidence and quality - Business Influence - Ability to present and explain technical and complicated information in an easy to understand format, both verbally and in writing. - Highly experienced in understanding and developing complex data models - Knowledge of data governance, expectations and leading practices - Business Judgement: High degree of ingenuity, creativity, and innovation to solve unique and complex business challenges; evaluate alternative solutions, considering costs and benefits. - Preferred languages include but are not limited to Python, Terraform, SQL and Java. - Preferred tool experience include but not limited to Apache Airflow, Kafka, Qlik Replicate, PostgreSQL, SQL Server, Solarwinds DPA. - Experience working with the SAP data model. - Experience working with artificial intelligence / machine learning platforms and practices. BE PART OF AN AMAZING CULTURE WHERE WHAT MATTERS TO YOU, MATTERS TO US! Gordon Food Service values our customers and understands that their success is largely dependent upon their workforce. To demonstrate our commitment to our partnership, we will require any candidate who works for a Gordon Food Service customer to provide a letter of support from their management if they are selected for the interview process. Equal Employment Opportunity is a matter of policy at Gordon Food Service, Inc. and we are committed to a work environment in which all individuals are treated with respect and dignity. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, status as a protected veteran, or status as a qualified individual with disability. If you require reasonable accommodation for any part of the application or hiring process due to a disability, please submit your request and use the words "Accommodation Request" in your subject line. All Gordon Food Service locations are tobacco-free. Gordon Food Service is a drug-free workplace and conducts pre-employment drug tests.

Michigan + 1 moreAll locations: Michigan | Georgia
KATBOTZ® logo

Data Migration Functional Lead

KATBOTZ®

Driving Customer Success Through Finance Transformation: Advanced Processes, Analytics, & AI.

Data Engineer11 days ago
ContractRemoteTeam 1-10Since 2021H1B No Sponsor

• Lead and execute SAP Data Migration activities for enterprise transformation projects. • Work extensively on Material Master, Purchase Orders, Outline Agreements, BOM, Routing, and Contracts data objects. • Perform data extraction, cleansing, mapping, validation, and reconciliation activities. • Collaborate with business users, functional consultants, and technical teams to define migration requirements and data standards. • Support migration strategy, mock loads, cutover planning, and go-live activities. • Ensure data quality, governance, and compliance throughout the migration lifecycle. • Conduct functional validations and support issue resolution during testing and deployment phases. • Coordinate with cross-functional teams including procurement, manufacturing, supply chain, and master data management teams. • Create migration documentation, mapping sheets, SOPs, and status reports. • Mentor junior team members and support knowledge-sharing initiatives.

United States