Full-time
Description
XTIVIA: Data Warehouse Architect
Work Location: Remote
Duration: 3+ Months Contract
Start Date: January 1st or 2nd week
How You Will Make a Difference
Seeking a highly skilled Data Warehouse Architect to evaluate, analyze & design future ready enterprise data warehouse (EDW) solutions and create a road-map to onboard multiple data sources as per business need. The ideal candidate will have deep expertise in data modeling, Data Engineering, and data integration, ensuring that the organization's data infrastructure is scalable, efficient, and optimized for analytics, reporting and AI needs.
Key Responsibilities
- 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.
- Evaluate and recommend data warehouse technologies, tools, and best practices.
- 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.
What you bring to your new team
- 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.
- Experience with cloud data warehouse assessment (Snowflake, Databricks, AWS, Azure, GCP).
- Familiarity with data governance frameworks and compliance requirements, data quality and data security best practices.
- Certifications in data management, cloud platforms, or data architecture.
- Strategic thinking and the ability to evaluate complex data environments and design for scalability and long-term growth.
- Attention to detail and commitment to data accuracy.
- Strong collaboration and presentation skills.
- Ability to translate technical findings into actionable design
$70-$80/hr
About the company
Company website•IT Services and IT Consulting
Our power comes from our people. Since XTIVIA’s inception 30 years ago, we have worked to assemble a team with deep expertise. As trusted industry thought leaders, we’re committed to providing integrated technology solutions and services that deliver measurable results.
XTIVIA has established a proven global reputation as a company that delivers leading-edge IT solutions and technology support for our client’s specific requirements, regardless of project complexity. Our passion, combined with a dedicated leadership team and unparalleled technical staff, creates customer relationships that stand the test of time. We do what it takes to help customers achieve their goals.
Our service areas include Application Development, Business Intelligence, and Data Warehousing, as well as Web Portal, Customer Relationship Management, Digital Experience Solutions and facilitating Digital Transformation.
We are recognized as a leader in Remote DBA Services, assisting national customers in managing their database environments across all the major platforms: Microsoft SQL Server, IBM Db2, IBM Informix, Oracle, Sybase, MongoDB, and PostgreSQL.
Through Hydus, an XTIVIA company, we specialize in Enterprise Information Management (EIM), which helps govern information across organizations to improve efficiency, promote transparency, and enable business insight.
Through GovCon365, an XTIVIA company, we are recognized as the leader in delivering the premier Microsoft DCAA-compliant ERP, financial management, and project accounting solution to high-growth government contractors and product resellers around the world. Only GovCon365 offers a Microsoft solution that was created specifically for growing government contractors to help manage and optimize their business and government contracts. GovCon365 also offers Project Management, Human Resources, and Business Development solutions. XTIVIA has offices in Colorado, New York, New Jersey, Texas, Virginia, and India.