Data Warehouse Architect

5 days ago


Austin, United States augmentjobs Full time
Job DescriptionJob Description

Job Description:

We are seeking a skilled Data Warehouse Architect to lead the design and development of our data warehouse solutions. The Data Warehouse Architect will play a critical role in defining the architecture, data modeling, and integration strategies for our enterprise data warehouse. This role requires expertise in data architecture, ETL processes, data modeling, and a deep understanding of data warehouse technologies and best practices.

Roles and Responsibilities:

  • Design and implement scalable and robust data warehouse solutions that meet business requirements and support data analytics and reporting needs.
  • Define data architecture principles, standards, guidelines, and best practices for data warehouse development.
  • Collaborate with stakeholders to understand data requirements and translate them into technical solutions.
  • Develop and maintain data models, schemas, and ETL processes for loading and transforming data into the data warehouse.
  • Optimize data warehouse performance through indexing strategies, partitioning, and query optimization techniques.
  • Ensure data quality and integrity within the data warehouse by implementing data governance and quality control processes.
  • Design and implement data integration strategies to consolidate data from multiple sources into the data warehouse.
  • Evaluate and recommend data warehouse technologies, tools, and frameworks based on project requirements and industry trends.
  • Provide technical leadership and mentorship to data engineers and developers working on data warehouse projects.
  • Collaborate with BI developers and analysts to design and deliver efficient and scalable BI solutions.

Skills and Qualifications:

  • Bachelor's degree in Computer Science, Information Systems, or related field (Master's degree preferred).
  • Proven experience (X years) as a Data Warehouse Architect or similar role, designing and implementing enterprise data warehouse solutions.
  • Strong knowledge of data warehouse concepts, methodologies, and best practices.
  • Hands-on experience with data modeling tools (e.g., ERwin, ER/Studio), ETL tools (e.g., Informatica, Talend), and data integration techniques.
  • Proficiency in SQL and database management systems (e.g., SQL Server, Oracle, PostgreSQL).
  • Experience with cloud-based data warehouse platforms (e.g., Snowflake, Google BigQuery, AWS Redshift) is highly desirable.
  • Solid understanding of data governance, data security, and regulatory compliance requirements (e.g., GDPR, CCPA).
  • Excellent analytical and problem-solving skills with the ability to analyze complex data issues and provide solutions.
  • Strong communication and interpersonal skills with the ability to collaborate effectively with cross-functional teams and stakeholders.

Compensation and Benefits:

  • Competitive salary based on experience and qualifications.
  • Comprehensive benefits package including health, dental, vision, and retirement plans.
  • Opportunities for professional development and career advancement within the organization.
  • Flexible work hours and a supportive work environment focused on innovation and growth.

How to Apply:

Please submit your resume and a cover letter outlining your qualifications and interest in the position to Augment Jobs. We look forward to reviewing your application and discussing how you can contribute to our team as a Data Warehouse Architect.

This job description aims to attract experienced Data Warehouse Architects by emphasizing the strategic role in designing and implementing scalable, efficient, and secure data warehouse solutions. Adjustments can be made based on specific company needs or industry standards.


  • Sr. Data Architect

    3 weeks ago


    Austin, United States Saxon Global Full time

    TxDOT requires the services of [1] Sr. Data Architect hereafter referred to as Worker, who meets the general qualification of Enterprise Architect Level 3 and the specifications outlined in this document. The Intelligent Roadway Data Architect at TxDOT will work as part of the core enterprise data management team to build the vision, direction, and data...

  • Sr. Data Architect

    2 weeks ago


    Austin, Texas, United States Saxon Global Full time

    TxDOT requires the services of [1] Sr. Data Architect hereafter referred to as Worker, who meets the general qualification of Enterprise Architect Level 3 and the specifications outlined in this document. The Intelligent Roadway Data Architect at TxDOT will work as part of the core enterprise data management team to build the vision, direction, and data...


  • Austin, United States snipeHIRE Full time

    Job DescriptionJob DescriptionCOMPANYOur client specializes in digital enablement and digital transformation solutions for Fortune companies. Using industry-leading data engineering, process mining and automation platforms, they help large enterprises become more process-efficient and improve their end-customer experience by incorporating the use of RPA, AI...


  • Austin, United States snipeHIRE Full time

    Job DescriptionJob DescriptionCOMPANYOur client specializes in digital enablement and digital transformation solutions for Fortune companies. Using industry-leading data engineering, process mining and automation platforms, they help large enterprises become more process-efficient and improve their end-customer experience by incorporating the use of RPA, AI...


  • Austin, United States snipeHIRE Full time

    Job DescriptionJob DescriptionCOMPANYOur client specializes in digital enablement and digital transformation solutions for Fortune companies. Using industry-leading data engineering, process mining and automation platforms, they help large enterprises become more process-efficient and improve their end-customer experience by incorporating the use of RPA, AI...


  • Austin, United States TestingXperts Inc. DBA Damcosoft Full time

    Job DescriptionJob DescriptionRole: Data Solution ArchitectLocation: Austin TX (Onsite from Day 1 No flexibility)Duration: LongtermFTE Only***Need only independent visa Consultants**Job Description:Solution Architect, having experience in creating Data & BI solutions in BFSI Wealth Management (Sales)Understanding Business reporting and analytics needs and...

  • Data Architect

    4 weeks ago


    Austin, United States UpEquity Full time

    **_About UpEquity:_** _Since its founding in 2019, UpEquity has been building a better way to buy a home. We are a veteran-owned, real estate company on a mission to create more equal access to the American Dream._ - Our flagship solution, the UpEquity Trade Up program, helps homeowners who are buying and selling at the same time. We specialize in unlocking...


  • Austin, United States Saxon Global Full time

    Skills: Need to be senior level Data Architect with strong communication skills as they will be doing client facing work. Strong understanding of Microsoft SQL, SQL Server, Azure Data bricks Data Architecture, Data modelling, data mapping, data flow / transformation skills experience will be critical. Knowledge of Salesforce Marketing Cloud would be nice to...

  • IT Data Architect

    2 weeks ago


    Austin, United States City of Austin Full time

    Position Information **Posting Title** - IT Data Architect**Job Requisition Number** - COA091796**Position Number** - 116910**Job Type** - Full-Time**Division Name** - Av - Information Systems**Minimum Qualifications** - Graduation with a Bachelor’s degree from an accredited college or university with major coursework in Information Science or in a field...


  • Austin, United States Intellisoft Technologies Full time

    Role: Azure Data Architect Location: Austin, TX (On-Site)Requirements:Overall 10+ years of IT experience and minimum 5 years of experience as an Architect on Data & Analytics solutions. Minimum 3+ years of experience working in the Azure public cloud platform. Proven experience as a Data Architect or similar role in enterprise level data-centric...


  • Austin, United States Intellisoft Technologies Full time

    Role: Azure Data Architect Location: Austin, TX (On-Site)Requirements:Overall 10+ years of IT experience and minimum 5 years of experience as an Architect on Data & Analytics solutions. Minimum 3+ years of experience working in the Azure public cloud platform. Proven experience as a Data Architect or similar role in enterprise level data-centric...

  • Azure Data Architect

    3 weeks ago


    Austin, United States Intellisoft Technologies Full time

    Role: Azure Data ArchitectLocation: Austin TXThis position does require candidates to be able to work without sponsorship in the US.It also requires a 2nd round on-site interview in Austin, TX. This position will start as a 12-month contract, can be extended, and does require candidates to work 2 days per week on-site in Austin, TX.Description:We are looking...

  • Azure Data Architect

    3 weeks ago


    Austin, United States THEMESOFT Full time

    **Azure Data Architect** **Austin, TX - (Hybrid)** **Long term contract** **Description**: We are looking for a who is experienced with Azure data services, Databricks, and has worked with a data scientist team. This is a hybrid role that requires the ability to work with data engineering / Data science projects. The ideal applicant will have demonstrated...

  • Azure Data Architect

    3 weeks ago


    Austin, United States Themesoft Inc. Full time

    Azure Data ArchitectAustin, TX.- (Candidates to work 2 days per week on-site)It also requires a 2nd round on-site interview in Austin, TX.This position will start as a 12 month contract, can be extended and does require Description:We are looking for a hands-on Azure Data Architect who is experienced with Azure data services, Databricks, and has worked with...


  • Austin, United States Themesoft Inc. Full time

    Azure Data ArchitectAustin, TX.- (Candidates to work 2 days per week on-site)It also requires a 2nd round on-site interview in Austin, TX.This position will start as a 12 month contract, can be extended and does require Description:We are looking for a hands-on Azure Data Architect who is experienced with Azure data services, Databricks, and has worked with...


  • Austin, United States American Unit Inc Full time

    **Data Architect with Eagle pace/eagle star experience** **Location: Local to Austin, TX - hybrid** **Long-term Contract role** - **Client: State of Texas -ERS Department** **DESCRIPTION OF SERVICES: The Employees Retirement System of Texas** requests the services of 1 Data Architects, hereafter referred to as Worker, who meets the general qualifications...


  • Austin, United States Indotronix International Corporation Full time

    OTHER SPECIAL REQUIREMENTS CANDIDATE SKILLS AND QUALIFICATIONS: • Must possess strong written, verbal, and interpersonal communication skills. • Must be able to work independently in a team environment with local and remote teams. • Must possess knowledge of project management methodologies both traditional and Agile/Scrum • Must possess...


  • Austin, United States Itility US Full time

    **WHO WE ARE** We believe in merging technology and data to drive our customers one step beyond. Itility digital consultants are experts in data, cloud, software and IT infrastructure. Acting as the ‘digital twin’ of customers, we work shoulder-to-shoulder to exceed business goals and push the boundaries of what you thought was possible. We combine an...


  • Austin, United States NTT DATA Full time

    NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Technical Solutions Architect Director to join our team in Austin, Texas (US-TX), United States (US).Technical DirectorJob...

  • Data Architect

    2 weeks ago


    Austin, United States IDEA Public Schools Full time

    **Description** Data Architect Software Development Role Mission: IDEA is currently undergoing a significant digital transformation initiative to modernize our data and analytics infrastructure. As the new Data Architect, you will play a pivotal role in leading the architecture, design, and implementation of our next-generation data solutions. In this...