Data Warehouse Architect

Job Title: Data Warehouse Architect (Relocation Opportunity USA) Location: United States (Relocation Supported)
Employment Type: Full-Time
Experience Level: Senior / Lead
Visa Sponsorship: Available for qualified international candidates
Relocation Support: Yes includes visa sponsorship, travel, and housing transition assistance About the Role We are looking for a highly experienced Data Warehouse Architect to lead the design and implementation of enterprise-scale data warehousing solutions. This role offers an exciting opportunity for international candidates seeking to relocate to the USA and work with cutting-edge technologies in a collaborative and data-driven environment. Key Responsibilities

• Design, architect, and manage large-scale data warehouse solutions tailored to business requirements
• Develop data models (star/snowflake schemas), ETL pipelines, and data integration strategies
• Collaborate with stakeholders to gather data requirements and translate them into architectural blueprints
• Optimize data storage and access strategies to ensure performance, scalability, and security
• Oversee data migration, transformation, and loading (ETL/ELT) processes
• Ensure high data quality and integrity across all data systems
• Lead performance tuning and troubleshooting of warehouse systems
• Provide mentorship and technical guidance to data engineering teams
• Work closely with BI/analytics teams to support data consumption use cases

Required Skills & Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field
• 7+ years of experience in data warehousing and architecture
• Hands-on experience with enterprise data warehouse platforms (e.g., Snowflake, Amazon Redshift, Google BigQuery, Azure Synapse)
• Proficiency in SQL, data modeling tools, and ETL development (e.g., Informatica, Talend, Apache Nifi, or custom ETL in Python/Scala)
• Experience designing both batch and real-time data processing systems
• Familiarity with data governance, data quality, and master data management concepts
• Strong understanding of cloud platforms (AWS, Azure, or Google Cloud Platform) and related data services
• Excellent communication and leadership skills

Preferred Qualifications

• Certification in AWS/Google Cloud Platform/Azure data services
• Experience with tools like dbt, Airflow, or Fivetran
• Familiarity with data lake architectures (e.g., Delta Lake, Apache Hudi, Lakehouse)
• Exposure to BI tools such as Tableau, Power BI, or Looker
• Experience working in Agile/Scrum environments

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity. Report this job

• Dice Id: 91165378
• Position Id: 2025-64