XTIVIA, Inc.
If you can imagine the business outcome, we can create it with technology.
Data Warehouse Architect
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 Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Data Engineer92 days ago
Full TimeRemoteTeam 1-10H1B No Sponsor
Data Engineer & Power Platform Specialist at Choreo
AWSAzureCloudETLGoogle Cloud PlatformMS SQL ServerMySQLOraclePostgresPythonScalaSQL
Data Engineer92 days ago
Full TimeRemoteTeam 11-50H1B No Sponsor
Lead Data Engineer building a data platform at Benepass's fintech.
Amazon RedshiftAWSETLPythonSQL
Data Architect
Magnet ForensicsWe 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
Data Engineer92 days ago
Full TimeRemoteTeam 11-50Since 2023
Data Engineer transforming customer data into high-fidelity datasets for AI training
Massachusetts