data warehouse architect

Techwaresoft

<p><b>Principal Teradata Architect</b><br/>Remote<br/><b>Role Description</b></p><p>We are seeking a <b>Principal Teradata Architect</b> to lead the design, architecture, and optimization of a large-scale <b>Enterprise Data Warehouse (EDW)</b> for a strategic <b>KSA digital transformation project</b>. The role focuses on building high-performance <b>MPP-based data warehouse architectures</b> that support regulatory reporting, cross-platform analytics, and scalable data processing.</p><p><b>Contract:</b> 4 Months (Extendable)</p><p><b>Shift:</b> Sunday&ndash;Thursday | 10/11 AM onwards PKT</p><p><b>Responsibilities</b></p><ul><li>Design and implement <b>enterprise data warehouse architecture</b> using relational and dimensional data models (Star/Snowflake).</li><li>Optimize Teradata performance through <b>TASM configuration and Explain plan analysis</b> to eliminate bottlenecks.</li><li>Architect <b>cross-platform analytics integration</b> between Teradata and Hadoop using <b>QueryGrid</b>.</li><li>Manage <b>high-speed data movement</b> between Teradata and Hadoop using <b>TDCH</b>.</li><li>Lead development of <b>high-performance ETL pipelines</b> using TPT, FastLoad, and MultiLoad.</li><li>Ensure warehouse architecture supports <b>RegTech reporting, data accuracy, and auditability</b>.</li><li>Oversee system performance, data governance, and reliability for enterprise-scale deployments.</li></ul><p><b>Qualification</b></p><ul><li>8+ years of experience in <b>Data Warehousing and Data Architecture</b></li><li>5+ years of hands-on experience with <b>Teradata Vantage or Teradata 16.x / 17.x environments.</b></li><li>Strong experience designing large-scale EDW solutions and dimensional models</li><li>Experience working in <b>enterprise or government-level data environments</b>.</li><li>Hands-on experience with <b>Teradata Studio, Viewpoint, and BAR (Backup, Archive, Restore)</b></li><li>Strong <b>English communication skills</b></li></ul><p><b>Must Have</b></p><ul><li>Deep expertise in <b>Teradata architecture and MPP systems</b></li><li>Advanced knowledge of Teradata SQL extensions, BTEQ scripting, and stored procedures</li><li>Hands-on experience with <b>TASM performance tuning and Explain plan analysis</b></li><li>Experience integrating <b>Teradata with Hadoop (Hive/HDFS) using QueryGrid</b></li><li>Strong experience with <b>TDCH for data transfer between Teradata and Hadoop</b></li><li>Expertise in <b>ETL development using TPT, FastLoad, and MultiLoad</b></li></ul><p><b>Nice to have</b></p><ul><li>Experience building <b>RegTech or regulatory reporting platforms</b></li><li>Knowledge of data governance, classification, and residency requirements for government environments</li><li>Experience supporting <b>large-scale digital transformation or public sector data platforms</b></li></ul><p>Job Type: Full-time</p><p>Work Location: Remote</p>

Principal Teradata Architect

Starlink Qatar

<div>
 <p>
  📌 𝗗𝗲𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻:
 </p>
 <p>
  We are seeking an experienced Data Architect to join our team in Doha, Qatar. The ideal candidate will be responsible for designing and implementing the foundational data architecture, pipelines, and models that power our central platform and its various solutions. This role is pivotal in ensuring all data assets are reliable, scalable, secure, and cost-efficient. You will develop and maintain robust ETL/ELT pipelines, map data sources for seamless integration, and design optimal data models. Collaborating closely with business and technical stakeholders, you will translate requirements into scalable data solutions that meet stringent performance, governance, and quality standards. Your expertise will drive the continuous improvement of our data platforms through best practices in data engineering, metadata management, and pipeline automation.
 </p>
 <p>
  ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
 </p>
 <p>
  <br/>
 </p>
 <p>
  🎯 𝗥𝗲𝗾𝘂𝗶𝗿𝗲𝗺𝗲𝗻𝘁𝘀:
 </p>
 <p>
  &rtrif; 7&ndash;10 years of progressive experience in the data architecture domain, designing and governing large-scale data platforms.
 </p>
 <p>
  &rtrif; Proficiency in the Microsoft Azure Ecosystem, including Azure Data Factory (ADF), Azure Fabric, Databricks, and Azure Data Lake Storage (ADLS).
 </p>
 <p>
  &rtrif; Proven expertise in designing conceptual, logical, and physical data models.
 </p>
 <p>
  &rtrif; Strong experience developing ETL/ELT pipelines for both structured and unstructured data.
 </p>
 <p>
  &rtrif; Solid understanding of cloud-based data architectures such as Lakehouse, Data Warehouse, and Data Lake paradigms.
 </p>
 <p>
  &rtrif; Deep knowledge of data performance optimization techniques and security controls (e.g., row-level security, data masking, encryption).
 </p>
 <p>
  &rtrif; Experience with real-time data processing using technologies like Azure Streaming.
 </p>
 <p>
  &rtrif; Demonstrated ability to implement data reliability measures, including SLAs, retry mechanisms, and automated monitoring.
 </p>
 <p>
  <br/>
 </p>
 <p>
  ✨ 𝗗𝗲𝘀𝗶𝗿𝗮𝗯𝗹𝗲𝘀:
 </p>
 <p>
  &rtrif; Microsoft Certified: Azure Data Engineer, Azure Solutions Architect Expert, or equivalent certifications.
 </p>
 <p>
  &rtrif; Experience collaborating with Enterprise Architecture, Data Governance, and Data Science teams.
 </p>
 <p>
  &rtrif; Strong leadership and mentoring skills with experience guiding cross-functional teams.
 </p>
 <p>
  &rtrif; Bachelor&rsquo;s or Master&rsquo;s degree in Computer Science, Software Engineering, or a related field.
 </p>
 <p>
  &rtrif; Ability to align data architecture with business strategy and measurable outcomes.
 </p>
</div>


Data Architect

Pemo

<div>
 <strong>
  <strong>
   Become a part of Pemo's incredible team!
  </strong>
 </strong>
 We're bold, collaborative, and ego-free. We challenge each other positively, encourage courageous decisions, and always aim high. Excited to be part of something big? We're hiring a Data Architect &ndash; Platform &amp; Data Management.
 <br/>
 <br/>
 <strong>
  <strong>
   What you'll be doing
   <br/>
   <br/>
  </strong>
 </strong>
 <ul>
  <li>
   Own Pemo&rsquo;s core data infrastructure across transactional databases and the data warehouse, ensuring it is scalable, reliable, and ready for rapid product growth.
  </li>
  <li>
   Design and optimize data models in PostgreSQL for our core platform, working closely with backend engineers to support high-throughput, low-latency product features.
  </li>
  <li>
   Define and implement data warehouse models (fact/dimension tables, star/snowflake schemas) in solutions such as BigQuery, ClickHouse, Snowflake, Redshift, etc., optimized for analytics and AI use cases.
  </li>
  <li>
   Design and maintain ingestion flows from operational systems (e.g. PostgreSQL) and external tools (e.g. Segment, Mixpanel, Elastic) into the warehouse, balancing freshness, cost, and complexity.
  </li>
  <li>
   Tune transactional and analytical performance through indexing strategies, partitioning, clustering, materialized views, and schema refactoring where needed.
  </li>
  <li>
   Implement and maintain observability for data infrastructure, including query performance, data freshness, job failures, and schema changes across both transactional and analytical systems.
  </li>
  <li>
   Work closely with data analysts to provide clean, well-modeled datasets that power BI dashboards and self-serve analytics for teams across Pemo.
  </li>
  <li>
   Collaborate with business stakeholders (finance, operations, compliance, leadership) to understand reporting, control, and audit requirements and reflect them in data models and tooling.
  </li>
  <li>
   Partner with AI engineers to design schemas, tables, and views that are optimized for AI agents, retrieval, and downstream ML/LLM workloads.
  </li>
  <li>
   Work with backend engineers to align on domain boundaries, event models, and data contracts so that product features and data infrastructure evolve together.
  </li>
  <li>
   Implement practical data compliance controls such as masking, column-level permissions, row-level filters, and PII separation in coordination with our security and compliance efforts.
  </li>
  <li>
   Act as the go-to person for data infrastructure questions, helping teams diagnose data issues, performance bottlenecks, and modeling gaps.
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Who we are looking for
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   A strong software engineer with 3-5 years of experience working on data-intensive backend systems, databases, or data platforms.
  </li>
  <li>
   Deep experience with relational databases, especially PostgreSQL, including schema design, indexing, query optimization, and understanding of query planners.
  </li>
  <li>
   Proficient in data warehouse solutions such as BigQuery, ClickHouse, Snowflake, Redshift, etc., including partitioning, clustering, and designing analytics-friendly schemas.
  </li>
  <li>
   Solid understanding of data ingestion patterns (CDC, batch loads, streaming), and experience building or maintaining reliable ingestion pipelines from operational databases into a warehouse.
  </li>
  <li>
   Comfortable working with SQL at an advanced level, including complex joins, window functions, aggregations, and performance tuning on large datasets.
  </li>
  <li>
   Experience supporting BI and analytics teams, providing well-modeled data, documenting datasets, and collaborating on metrics definitions and dashboards.
  </li>
  <li>
   Familiar with data observability concepts (freshness, completeness, schema changes, data drift) and monitoring/alerting for data pipelines and warehouses.
  </li>
  <li>
   Able to implement data compliance requirements in practice, such as masking sensitive columns, enforcing column- and row-level access, and separating PII from non-PII datasets using the tools available in the data stack.
  </li>
  <li>
   Familiar with data governance concepts and tooling (data catalogs, lineage, ownership, documentation) and able to apply them pragmatically in a growing startup.
  </li>
  <li>
   Comfortable collaborating with backend, AI, analytics, and business stakeholders, translating their requirements into concrete data models, tables, and flows.
  </li>
  <li>
   Strong communicator who can explain trade-offs in schema design, performance, and data architecture in simple language to non-technical stakeholders.
  </li>
  <li>
   Self-motivated, hands-on, and comfortable taking ownership in a fast-moving, high-responsibility environment.
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Bonus points for:
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Experience in fintech or high-growth B2B SaaS.
  </li>
  <li>
   Exposure to regional data requirements (e.g. data residency, localization) and how they influence data architecture.
  </li>
  <li>
   Experience with Infrastructure-as-Code (e.g. Terraform) to manage data infrastructure on AWS or similar clouds.
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  <strong>
   Why Pemo?
  </strong>
 </strong>
 Work your way with flexible hours, and freedom to take time off when you need it. Join a global team of fintech experts, backed by $18M+ from top investors and named in Forbes ME Top 50. At Pemo, you'll innovate, grow, and help shape the future of spend management in MENA.
 <br/>
 <br/>
 <strong>
  <strong>
   A little more about our company
  </strong>
 </strong>
 At Pemo, we believe that all business owners deserve to be successful. Business owners deserve to spend their time and money doing what they do best &mdash; running their businesses. They deserve to stay in control of their finances, at any point in time, effortlessly! That's why we have built the all-in-one spend management platform that empowers MENA business owners and their teams.
</div>


C&G Consulting Services, Inc

<div>
 <p>
  This role is 3 days onsite. NO REMOTE or Relocation. Must be a US Citizen or Green Card Holder. Please do not apply if you are a EAD or H1-VIsa.
 </p>
 <p>
  <br/>
 </p>
 <p>
  <strong>
   Job Description:
  </strong>
 </p>
 <p>
  We are looking for a
  <strong>
   Data Architect
  </strong>
  to take ownership of designing and evolving a modern enterprise data ecosystem that supports analytics, reporting, and business decision-making. This role will focus on building and maintaining a secure, scalable data warehouse leveraging Microsoft cloud technologies such as Azure, Synapse, and Microsoft Fabric, while ensuring strong data quality, accessibility, and consistency across the organization.
 </p>
 <p>
  This position will play a key role in establishing data standards, driving best practices in data modeling and governance, and partnering with both technical and business stakeholders. The ideal candidate is comfortable working independently and translating complex data concepts into actionable insights for non-technical audiences.
 </p>
 <p>
  Key Responsibilities
 </p>
 <p>
  <strong>
   Data Architecture &amp; Modeling
  </strong>
 </p>
 <ul>
  <li>
   Design, implement, and maintain enterprise data warehouse solutions within Azure and Microsoft Fabric
  </li>
  <li>
   Develop and manage semantic data models to support reporting through Power BI and Azure Analysis Services
  </li>
  <li>
   Establish and document standards for data modeling, naming conventions, and dataset design
  </li>
 </ul>
 <p>
  <strong>
   Data Governance &amp; Quality
  </strong>
 </p>
 <ul>
  <li>
   Define and enforce data governance frameworks, including data definitions, access controls, and data policies
  </li>
  <li>
   Implement automated processes to monitor and improve data quality and integrity
  </li>
  <li>
   Partner with business users to understand requirements and resolve data inconsistencies
  </li>
 </ul>
 <p>
  <strong>
   Technical Leadership
  </strong>
 </p>
 <ul>
  <li>
   Act as a subject matter expert for data architecture and enterprise data strategy
  </li>
  <li>
   Translate business requirements into scalable and efficient data solutions
  </li>
  <li>
   Provide guidance to stakeholders on data architecture decisions and trade-offs
  </li>
 </ul>
 <p>
  <strong>
   Enablement &amp; Collaboration
  </strong>
 </p>
 <ul>
  <li>
   Create documentation, data dictionaries, and standards to support self-service analytics
  </li>
  <li>
   Work closely with BI developers and business teams to ensure data solutions align with reporting needs
  </li>
 </ul>
 <p>
  Required Qualifications
 </p>
 <ul>
  <li>
   6+ years of experience in data architecture, data engineering, or BI-related roles
  </li>
  <li>
   Strong expertise with Microsoft Azure Data Services, including SQL, Synapse, Data Factory, and Fabric
  </li>
  <li>
   Advanced SQL skills with experience in query optimization
  </li>
  <li>
   Experience with Python or R for data processing and automation
  </li>
  <li>
   Deep understanding of semantic modeling in Power BI or Azure Analysis Services
  </li>
  <li>
   Hands-on experience with Power BI (Desktop, Service, DAX, Power Query)
  </li>
  <li>
   Experience integrating ERP (Epicor preferred) and CRM data for reporting and analytics
  </li>
  <li>
   Strong understanding of end-to-end ERP business processes (Quote-to-Cash, AR, AP, GL)
  </li>
  <li>
   Knowledge of enterprise data architecture principles and data lifecycle management
  </li>
  <li>
   Proven experience establishing and maintaining data governance and quality standards
  </li>
  <li>
   Strong communication skills with the ability to work with non-technical stakeholders
  </li>
 </ul>
 <p>
  Preferred Qualifications
 </p>
 <ul>
  <li>
   Bachelor&rsquo;s or Master&rsquo;s degree in Computer Science, Information Systems, or a related field
  </li>
  <li>
   Experience with modern data architecture patterns such as lakehouse, star schema, or medallion architecture
  </li>
  <li>
   Background in operational or supply chain environments
  </li>
  <li>
   Exposure to planning tools such as Anaplan or similar platforms
  </li>
 </ul>
 <p>
 </p>
</div>


Data Engineer

HR POD Careers

<div>
 <strong>
  Requirements:
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   8+ years in Data Warehousing, with 5+ years specifically in Teradata Vantage or 16.x/17.x environments.
  </li>
  <li>
   Mastery of Teradata-specific SQL extensions, BTEQ scripting, and stored procedures
  </li>
  <li>
   Hands-on experience with Teradata Studio, Viewpoint, and BAR (Backup, Archive, and Restore) solutions.
  </li>
  <li>
   Understanding of data classification and residency requirements relevant to the KSA public sector.
   <br/>
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Responsibilities:
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Lead the design of complex relational and dimensional data models (Star/Snowflake) tailored for government-level KPIs and statistics.
  </li>
  <li>
   Perform advanced performance tuning using TASM (Teradata Active System Management) and analyze "Explain" plans to eliminate processing bottlenecks.
  </li>
  <li>
   Design and implement Teradata QueryGrid fabrics to enable cross-platform analytics between Teradata and Hadoop (Hive/HDFS).
  </li>
  <li>
   Expertise in TDCH (Teradata Connector for Hadoop) for high-speed, bi-directional data movement.
  </li>
  <li>
   Ability to architect "Federated Queries" that minimize data egress from the Hadoop environment.
  </li>
  <li>
   Direct the development of high-speed data loading scripts using TPT (Teradata Parallel Transporter), FastLoad, and MultiLoad.
  </li>
  <li>
   Ensure the warehouse architecture supports Regulatory Technology (RegTech) indicators, focusing on data accuracy and auditability.
   <br/>
  </li>
 </ul>
</div>


Principal Teradata Architect (Remote, Anywhere in Pakistan, USD Salary)

Taylor Corporation

<div></div><div><div><div>Taylor Corporation is a dynamic, diversified company with big plans for the future ― and your career. We power our employees&rsquo; potential and strive to create opportunity and security for every member of the team. If you&rsquo;re ready for something bigger ― more challenge, more variety, more pathways for professional growth ― we should talk. We&rsquo;re passionate about our work, we believe there is always a better way, and we&rsquo;re looking for people like you.</div></div><div></div><div><div>
Ready to reach your potential? It&rsquo;s time to look at Taylor.</div></div><div></div><div><div>
Your Opportunity: Taylor Corporation is looking for a Data Architect to help design and build a unified reporting and analytics foundation across our Direct and Digital businesses. This role will play a critical part in transforming disparate data sources into a scalable, consistent data model that supports reporting, insights, and decision-making across the division.</div></div><div></div><div><div>
Work Authorization:<br>
To be considered for Taylor opportunities, candidates must be authorized to work in the United States without the need for employer sponsorship.</div></div><div></div><div><div>
Your Responsibilities:</div></div><div><ul><li><div>
Design and architect end-to-end analytics and reporting solutions across multiple businesses with different ERP systems and data models</div></li></ul></div><div><ul><li><div>
Partner with sales, product, finance, and executive stakeholders to understand reporting needs and guide them toward meaningful, actionable insights</div></li></ul></div><div><ul><li><div>
Evaluate incoming reporting requests, clarify requirements, and help stakeholders understand what constitutes effective versus ineffective reporting</div></li></ul></div><div><ul><li><div>
Collaborate closely with centralized Taylor data teams and individual business units to integrate data into a shared Microsoft Fabric environment</div></li></ul></div><div><ul><li><div>
Lead data modeling efforts to transform and structure data into a unified, scalable architecture that supports Power BI reporting</div></li></ul></div><div><ul><li><div>
Serve as a bridge between technical teams and non-technical leaders by clearly explaining data concepts, limitations, and opportunities</div></li></ul></div><div><ul><li><div>
Support the long-term vision of building an enterprise-level reporting structure that can scale across the division</div></li></ul></div><div></div><div><div>
You Must Have:</div></div><div><ul><li><div>
3+ years of hands-on experience working with Microsoft Fabric, including data ingestion, transformation, and data warehousing concepts</div></li></ul></div><div><ul><li><div>
5+ years of experience in data modeling, including designing and maintaining scalable data architectures</div></li></ul></div><div><ul><li><div>
3+ years of experience building and supporting reports and dashboards in Power BI</div></li></ul></div><div><ul><li><div>
Experience working with multiple, disparate data sources and transforming them into a single, consolidated data model</div></li></ul></div><div><ul><li><div>
Strong ability to explain complex data concepts to non-technical stakeholders and business leaders</div></li></ul></div><div><ul><li><div>
Proven experience leading cross-functional initiatives involving IT, data, and business teams</div></li></ul></div><div></div><div><div>
We Would Also Prefer:</div></div><div><ul><li><div>
Experience leveraging AI capabilities within reporting, including AI features in Power BI or related analytics tools</div></li></ul></div><div><ul><li><div>
Prior experience building reporting or analytics foundations in a multi-business or shared-services environment</div></li></ul></div><div><ul><li><div>
Exposure to data lake and modern data warehouse architectures</div></li></ul></div><div></div><div><div><br>
About Taylor Corporation</div></div><div><div>
One of the largest print and communications firms in North America, Taylor&rsquo;s family of companies provides a diverse set of products, services and technologies that address the toughest business challenges. We work diligently each day to create printed and digital marketing communication solutions that help power many of the world&rsquo;s most recognizable brands.</div></div><div></div><div><div><br>
With more than 50 years of category expertise and 10,000 employees spanning dozens of U.S. states and multiple countries, Taylor serves businesses and distributors both large and small. Our employees enjoy a comprehensive benefit package including a choice of several health plans, dental, vision, wellness programs, life and disability coverage, flexible spending accounts, health savings accounts, a 401(k) plan with company match, paid time off (PTO) and 64 hours of annual holiday pay.</div></div><div></div><div><div><i>
The Employer </i><i>retains</i><i> the right to change or assign other duties to this position.</i></div></div><div></div><div><div><i>
Taylor Corporation is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, </i><i>veteran</i><i> or disability status.</i></div></div><div></div><div><br>
Taylor Corporation including all partners and affiliates is an Equal Opportunity Employer/Veterans/Disabled.</div></div>

Data Architect/Analyst

Muller's Solutions

<div><p>M&uuml;ller's Solutions is on the lookout for a talented Data Architect to join our team. In this role, you will be responsible for designing and implementing comprehensive data architectures that align with the organization&rsquo;s strategic goals. Your expertise will contribute to managing data effectively, ensuring high data quality, and supporting data analytics efforts across various departments. You will collaborate with cross-functional teams to drive the development of innovative data solutions that enhance business processes.</p><p></p><p><b><br>
Responsibilities:</b></p><br>
<p></p><ul>
<li>Design, implement, and manage complex data architectures that support business objectives.</li>
<li>Develop and maintain data models, database schemas, and data flow diagrams.</li>
<li>Collaborate with business analysts and stakeholders to gather data requirements and translate them into architectural specifications.</li>
<li>Establish and enforce data governance policies and best practices.</li>
<li>Conduct data quality assessments and implement solutions for data cleansing and accuracy.</li>
<li>Oversee data integration efforts with various systems, ensuring seamless data flow.</li>
<li>Work with IT teams to optimize database performance and storage solutions.</li>
<li>Continuously evaluate and adopt new technologies to enhance data architecture.</li>
<li>Provide mentorship and guidance to junior data professionals.</li>
<li>Stay updated on industry trends and advancements in data architecture and management.</li><br>
</ul><br>
<br>
<b>Requirements</b><p></p><p><b><br>
Requirements:</b></p><br>
<p></p><ul>
<li>Bachelor's degree in Computer Science, Information Technology, or related field.</li>
<li>Proven experience as a Data Architect or a similar role.</li>
<li>Strong expertise in data modeling and database design.</li>
<li>Experience with data integration tools and ETL processes.</li>
<li>Familiarity with data governance frameworks and best practices.</li>
<li>Proficient in SQL, as well as experience with database management systems (e.g., Oracle, SQL Server, MySQL).</li>
<li>Solid understanding of data security principles and practices.</li>
<li>Analytical mindset with excellent problem-solving skills.</li>
<li>Strong communication and interpersonal skills.</li>
<li>Ability to work collaboratively in a team-oriented environment.</li><br>
</ul><br>
<br>
<b>Benefits</b><p><br>
Why Join Us:</p><p></p><p>
Opportunity to work with a talented and passionate team.</p><p>
Competitive salary and benefits package.</p><p>
Exciting projects and innovative work environment.</p></div>

Search 10000+ Data warehouse architect jobs near you this March. New roles added regularly across leading industries. Apply today.

10000 data warehouse architect jobs Near Me

Principal Teradata Architect

Data Architect

Data Architect

Data Engineer

Principal Teradata Architect (Remote, Anywhere in Pakistan, USD Salary)

Data Architect/Analyst

Data Architect