Data Warehouse Architect

3 weeks ago


New York, New York, United States Unreal Gigs Full time
Unreal Gigs is seeking a highly skilled Data Warehouse Architect to design and develop scalable and efficient data warehouse solutions. The ideal candidate will have a strong background in data engineering and experience with data warehouse platforms and technologies such as Amazon Redshift, Google BigQuery, Snowflake, or Microsoft Azure SQL Data Warehouse.

Key Responsibilities:

* Design and architect scalable and efficient data warehouse solutions, including data models, schemas, and storage structures.
* Develop and maintain ETL (Extract, Transform, Load) processes to extract data from source systems, transform it to meet business requirements, and load it into the data warehouse.
* Design and implement dimensional and normalized data models to support reporting, analytics, and business intelligence applications.
* Integrate data from diverse sources, including databases, applications, APIs, and flat files, ensuring data consistency and integrity.
* Optimize data warehouse performance for query speed, concurrency, and scalability, tuning SQL queries, indexing strategies, and partitioning schemes.
* Implement data quality checks and validation rules to ensure the accuracy, completeness, and consistency of data in the warehouse.
* Monitor data warehouse performance and health, proactively identifying and addressing issues to minimize downtime and optimize resource utilization.

Requirements:

* Bachelor's degree or higher in Computer Science, Engineering, or related field.
* Strong background in data engineering, with hands-on experience in designing, building, and maintaining data warehouse solutions.
* Proficiency in SQL and database technologies such as PostgreSQL, MySQL, SQL Server, or Oracle.
* Experience with data warehouse platforms and technologies such as Amazon Redshift, Google BigQuery, Snowflake, or Microsoft Azure SQL Data Warehouse.
* Familiarity with ETL tools and technologies such as Apache Airflow, Talend, Informatica, or AWS Glue.
* Strong problem-solving abilities and analytical thinking, with a keen attention to detail and a passion for tackling complex technical challenges.
* Excellent communication and collaboration skills, with the ability to work effectively in cross-functional teams and communicate technical concepts to non-technical stakeholders.

Benefits:

* Competitive salary: The industry standard salary for Data Warehouse Engineers typically ranges from $140,000 to $210,000 per year, depending on experience and qualifications.
* Comprehensive health, dental, and vision insurance plans.
* Flexible work hours and remote work options.
* Generous vacation and paid time off.
* Professional development opportunities, including access to training programs, conferences, and workshops.
* State-of-the-art technology environment with access to cutting-edge tools and resources.
* Vibrant and inclusive company culture with team-building activities and social events.
* Opportunities for career growth and advancement within the company.
* Exciting projects with real-world impact across diverse industries.
* Chance to work alongside top talent and industry experts in the field of data warehouse engineering.

Unreal Gigs is an equal opportunity employer and welcomes applications from diverse candidates.

If you are a motivated and experienced Data Warehouse Architect looking for a new challenge, please submit your application, including your resume and a cover letter, to careers@unrealgigs.com.

  • New York, New York, United States Tech Tammina Full time

    Job Title:Data Warehouse ArchitectLocation:NYC, NYExperience:14+ years in the IT industry with a strong focus on data architecture and engineering. 8+ years working with US companies in the US, with a proven track record of delivering successful data warehouse solutions. 8+ years as a Data Architect/Engineer, with expertise in designing and implementing ETL...


  • New York, New York, United States Mindlance Full time

    Job Summary:The ideal candidate will be responsible for designing and developing enterprise data warehouse solutions that meet the business needs of Mindlance. This role requires a strong background in technology, analysis, and critically evaluating information from multiple sources. The successful candidate will have extensive experience in architecting and...


  • New York, New York, United States Unreal Gigs Full time

    Unlock the Power of Data Warehouse EngineeringAt Unreal Gigs, we're revolutionizing the way organizations harness the power of data to drive insights and innovation. As a Data Warehouse Engineer, you'll play a pivotal role in designing, building, and maintaining our data warehouse infrastructure and systems.Key Responsibilities:Design and architect scalable...


  • New York, New York, United States Unreal Gigs Full time

    Unlock the Power of DataAt Unreal Gigs, we're on a mission to harness the power of data to drive insights and innovation. As a Data Warehouse Engineer, you'll play a crucial role in designing, building, and maintaining our data warehouse infrastructure and systems.Key Responsibilities:Data Warehouse Design:Design and architect scalable and efficient data...


  • New York, New York, United States VedaInfo Full time

    Job Requirements:As a seasoned Data Warehouse Architect, you will be responsible for designing and implementing complex DW solutions using Greenplum and other DW Appliances. Your expertise in architecting DW implementations will be crucial in driving business growth and improving data-driven decision-making.Key Responsibilities:Design and implement DW...


  • New York, New York, United States Unreal Gigs Full time

    Unreal Gigs is seeking a highly skilled Senior Data Warehouse Architect to join our team. As a key member of our data engineering team, you will be responsible for designing, building, and maintaining our data warehousing solutions.### Key Responsibilities:* Design and implement data warehouse solutions, including data models, schemas, and architecture, to...


  • New York, New York, United States Kargo Global LLC Full time

    Data Architect Data AnalyticsWe are seeking a highly skilled Data Architect Data Analytics to join our team at Kargo Global LLC. As a key member of our data engineering team, you will be responsible for designing, developing, and maintaining our petabyte-scale data warehouse.You will work closely with data scientists and engineers to categorize, document,...

  • Data Architect

    3 weeks ago


    New York, New York, United States Medidata Solutions Full time

    Job Title: Data ArchitectWe are seeking a highly skilled Data Architect to join our team at Medidata Solutions. As a Data Architect, you will be responsible for designing and implementing optimal data pipeline architecture to support our growing analytics capabilities.Key Responsibilities:* Design and implement data pipelines required in the data warehouse...

  • Senior Data Architect

    4 weeks ago


    New York, New York, United States Vichara Full time

    Job Title: Senior Data ArchitectAt Vichara, we are seeking a highly skilled Senior Data Architect to lead the development of our Enterprise Data Warehouse. The ideal candidate will have extensive experience in designing and implementing data models, ETL processes, and data governance frameworks.Key Responsibilities:Design and implement data models for the...


  • New York, New York, United States VedaInfo Full time

    Job Description:As a seasoned Data Warehouse Architect with Greenplum expertise, you will be responsible for designing and implementing complex DW solutions. Your expertise in Greenplum and other DW appliances will be invaluable in this role.Key Responsibilities:- Design and implement DW solutions- Collaborate with cross-functional teams- Ensure data quality...

  • Data Architect

    4 weeks ago


    New York, New York, United States The TCW Group Full time

    Job Title: Data ArchitectWe are seeking a highly skilled Data Architect to drive design requirements and technical implementation of long-term data projects. The ideal candidate will have a strong data engineering background, experience in implementing end-to-end data lifecycle solutions, and a background working in financial services.Key...

  • Cloud Data Architect

    3 weeks ago


    New York, New York, United States Diverse Lynx Full time

    Job Title: Cloud Data ArchitectThis role will augment Diverse Lynx Technology Advisory Group consulting and architecture team. You will lead architecture team for Complex / Multi Year Cloud transformation program and guide team of Business & technology architects. You will engage with CxO's and become their trusted advisors.Responsibilities:Designing and...


  • New York, New York, United States Mindlance Full time

    Job Summary:The ideal candidate will have extensive experience in designing and developing data warehouse solutions for enterprise-scale applications. They will work closely with project managers, IT staff, and other stakeholders to define development requirements for the enterprise data warehouse. The successful candidate will have a strong understanding of...

  • Senior Data Engineer

    4 weeks ago


    New York, New York, United States The Data Sherpas Full time

    Job SummaryWe are seeking a highly skilled Senior Data Engineer to lead our team in designing, developing, and deploying high-performance data analytics solutions on Google Cloud Platform (GCP). As a key member of our team, you will be responsible for architecting transformation and modernization of enterprise data solutions on GCP, integrating native GCP...

  • Data Architect

    3 weeks ago


    New York, New York, United States Servant Talent Full time

    About the RoleWe are seeking a highly skilled Data Architect to join our team at Servant Digital. As a Data Architect, you will play a critical role in shaping and supporting the strategic direction of our data initiatives.Key ResponsibilitiesCollaborate with the Data Strategist to assess and recommend tools for data storage, integration, processing, and...

  • Data Architect

    4 weeks ago


    New York, New York, United States CCG Business Solutions, LLC Full time

    Data Engineer Job DescriptionCCG Business Solutions, LLC is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, building, and maintaining our data pipelines and architectures.The ideal candidate will have a strong background in data engineering, with experience in designing and implementing data...

  • Azure Data Architect

    4 weeks ago


    New York, New York, United States Harnham Full time

    Job Opportunity:We are seeking a highly experienced Data Architect to join our team as a Principal Data Engineer, Azure. This role involves designing and developing Azure data warehouses and data pipelines for ML model execution, collaborating with a cross-functioning team, and serving as an Azure subject matter expert to lead the design and development...


  • New York, New York, United States Tek Leaders Inc Full time

    Job Title: Healthcare Data ArchitectAt Tek Leaders Inc, we are seeking a highly skilled Healthcare Data Architect to join our team. As a key member of our data architecture team, you will be responsible for designing and implementing data architectures that meet the needs of our healthcare clients.Key Responsibilities:Design and implement data architectures...


  • New York, New York, United States Unreal Gigs Full time

    Unlock the Power of Data-Driven InnovationWelcome to Unreal Gigs, where we're revolutionizing the way companies harness the power of data. As a Senior Data Warehouse Engineer, you'll play a pivotal role in designing, building, and maintaining our cutting-edge data warehousing solutions.Key Responsibilities:Design and implement data warehouse architectures...

  • Senior Data Architect

    3 weeks ago


    New York, New York, United States Financial Insight Technology, Inc. dba SmartAsset Full time

    Job SummaryAs a Senior Data Architect at Financial Insight Technology, Inc. dba SmartAsset, you will lead data engineering efforts by collaborating with cross-functional teams to harness the power of data and turn it into a strategic asset that drives business forward. This role requires a strong understanding of data engineering principles, including data...