XTIVIA, Inc.

If you can imagine the business outcome, we can create it with technology.

Data Warehouse Architect

Data EngineerData EngineerContractRemoteTeam 201-500Since 1993H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

91 days ago

Salary

$70 - $80 / hour

Bachelor Degree8 yrs expEnglishAmazon RedshiftBig QueryCloudETLOracleSQLTableauVault

Job Description

• Conduct comprehensive assessments of existing data sources, architectures, data flows, data models and reporting. • Collaborate with business and IT stakeholders to understand current and future data requirements and translate them into robust solutions and design. • Evaluate data quality, consistency, and compliance with governance standards. • Evaluate and recommend data warehouse technologies, tools, and best practices. • Define to be a data warehouse data model as per EDW standards and high level logical and physical data models. • Review data integration, storage, and data retrieval processes for efficiency and cost-effectiveness. • Advise on best practices for cloud migration, data security, and compliance. • Design and present a scalable and high-performance data warehouse architecture to business and IT stakeholders. • Work closely with data analysts, data engineers and IT/business stakeholders to implement, and maintain scalable and high-performance data warehouse solutions.

Job Requirements

  • Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
  • Extensive experience (8+ years) in designing and implementing data warehouse solutions.
  • Strong knowledge of data modeling (star schema, snowflake schema, data vault schema) and dimensional modeling.
  • Proficiency in modern ETL tools.
  • Experience with SQL and database technologies (Oracle, SQL Server, Teradata, Snowflake, Databricks Redshift, BigQuery, etc.).
  • Implementation experience of cloud data warehouse platforms and architectures.
  • Experience evaluating and proposing future ready enterprise data warehouses roadmap.
  • Familiarity with BI tools such as Tableau, Power BI, or Looker.
  • Strong problem-solving, analytical, and communication skills.

Related Categories

Related Job Pages

More Data Engineer Jobs

Associate Director, Data Engineering, Development

Choreo

We Help Businesses Choreograph Change.

Data Engineer92 days ago
Full TimeRemoteTeam 1-10H1B No Sponsor

Data Engineer & Power Platform Specialist at Choreo

AWSAzureCloudETLGoogle Cloud PlatformMS SQL ServerMySQLOraclePostgresPythonScalaSQL
United States
$120K - $135K / year

Lead Data Engineer

Benepass

We help companies take care of their people.

Data Engineer92 days ago
Full TimeRemoteTeam 11-50H1B No Sponsor

Lead Data Engineer building a data platform at Benepass's fintech.

Amazon RedshiftAWSETLPythonSQL
United States
$180K - $200K / year

Data Architect

Magnet Forensics

We provide organizations with innovative tools to investigate cyberattacks and digital crimes

Data Engineer92 days ago
Full TimeRemoteTeam 201-500Since 2009H1B No Sponsor

Data Architect leading data storage strategy across SaaS platform.

AWSAzureCloudDynamoDBElasticSearchGoogle Cloud PlatformKubernetesMongoDBMySQLNoSQLPostgresRedis
United States
$154K - $264K / year

Data Engineer – Manufacturing

Foundation EGI

Engineering General Intelligence

Data Engineer92 days ago
Full TimeRemoteTeam 11-50Since 2023

Data Engineer transforming customer data into high-fidelity datasets for AI training

Massachusetts