Data Warehouse Architect Job at Myticas Consulting (Lansing)

Enterprise Data Warehouse Architect

We are seeking an experienced Enterprise Data Warehouse (EDW) Architect to lead ...

Location

United States , San Diego

Salary:

Not provided

Robert Half

Expiration Date

Until further notice

Requirements

10+ years of experience in enterprise data warehousing and analytics architecture
Proven experience implementing modern data platforms such as Snowflake, Databricks, or Azure Synapse
Deep expertise in dimensional modeling methodologies (Kimball and/or Inmon)
Strong background designing and orchestrating ETL/ELT pipelines using tools such as dbt, Airflow, or Azure Data Factory
Hands-on experience with BI semantic layers and enterprise reporting frameworks (Power BI, Tableau, Looker)
Experience designing data governance, data quality, and lineage solutions
Excellent communication skills with the ability to translate business requirements into technical architecture

Job Responsibility

Evaluate and recommend data warehousing platforms (e.g., Snowflake, Databricks, BigQuery, Redshift, Azure Synapse)
Select and design ETL/ELT solutions and orchestration frameworks (e.g., dbt, Fivetran, ADF, Informatica, Talend)
Design dimensional data models, including star and snowflake schemas, aligned to business use cases
Lead subject area modeling and architecture across Supply Chain, Sales, Finance, HR, and Procurement
Define BI-layer architecture and reporting standards using tools such as Power BI, Tableau, or Looker
Establish data governance, lineage, metadata, and data quality frameworks
Produce architecture documentation, implementation roadmaps, and conduct knowledge transfer and handover to delivery teams

What we offer

Medical, vision, dental, and life and disability insurance
401(k) plan

Fulltime

Microsoft Fabric Data Warehouse Architect

We are seeking a highly experienced and pragmatic Microsoft Fabric Data Warehous...

Location

United States

Salary:

Not provided

Tier4 Group

Expiration Date

Until further notice

Requirements

Bachelor’s degree in Computer Science, Engineering, or related field
5+ years of experience in data architecture or cloud analytics with 2+ years hands-on with Microsoft Fabric
Experience designing and operating enterprise-scale Fabric environments
Strong expertise in Lakehouse, Data Warehouse, Data Integration, and Semantic Layer design
Experience with governance, security, DevOps, and cost optimization in Fabric
Strong understanding of medallion architecture and dimensional modeling
Proficiency in SQL, Python, and/or PySpark
Experience with Direct Lake semantic model optimization
Experience with data migration and modernization into Fabric
Strong understanding of data observability and reliability patterns

Job Responsibility

Own and evolve the enterprise data architecture strategy on Microsoft Fabric, including standards, patterns, and platform roadmap
Design and develop end-to-end analytics solutions including ingestion, transformation, storage, modeling, and reporting
Architect Lakehouse and Data Warehouse solutions leveraging OneLake, Delta Lake, and Fabric compute
Design robust ingestion patterns for Oracle Fusion Cloud BI Publisher extracts (CSV-based pipelines, automation, validation, and error handling)
Design solutions that scale across large, multi-domain environments with high data volumes and enterprise SLAs
Evaluate and make architectural tradeoffs across performance, cost, usability, and maintainability
Define and enforce governance standards including workspace design, naming conventions, data ownership, access patterns, and lifecycle management
Design and implement observability frameworks including monitoring, alerting, data quality validation, and SLA enforcement
Establish delivery frameworks including CI/CD pipelines, deployment pipelines, guardrails, and reusable accelerators
Lead implementation of medallion architecture patterns (Bronze/Silver/Gold)

Data Warehouse Architect - Senior ETL/BI Developer

The Senior Data Warehouse ETL/BI Developer is responsible for designing, develop...

Location

United States , Lansing, Michigan

Salary:

Not provided

The Stafford Gray Group

Expiration Date

Until further notice

Requirements

Bachelor’s degree or equivalent technical training
6+ years of experience building data‑warehouse BI solutions, including ETL, data‑mart development, reporting, and dashboards
2+ years of experience in child‑welfare, juvenile‑justice, or related human‑services domains
Strong SQL proficiency, including experience working with Teradata tools such as SQL Assistant or Teradata Studio
Proven experience developing ETL processes, data marts, and physical data‑warehouse models
Understanding of DW concepts, relational modeling, reconciliation techniques, and performance optimization
Experience collaborating with architects and DBAs on secure and scalable database designs
Ability to work independently with minimal supervision
Excellent written and verbal communication skills
Strong analytical skills, including problem identification, fact‑gathering, and solution design

Job Responsibility

Design, develop, and maintain ETL processes, data marts, and BI applications on a Teradata data‑warehouse platform
Write advanced SQL queries, transformations, and scripts supporting reporting, dashboards, and analytical workflows
Collaborate with data modelers to optimize physical data models for reporting, reconciliation, and performance
Ensure all solutions consider data accuracy, query performance, security requirements, and business value
Support BI/reporting development through data modeling, dataset preparation, and optimized ETL feeds
Meet with end users to gather requirements, clarify needs, and refine analytics and reporting deliverables
Provide documentation updates, end‑user support, and training as needed
Represent the data‑warehouse team on multi‑team initiatives and coordinate work across parallel DW projects
Present technical findings, solutions, and design proposals to review boards and project leadership
Offer expert guidance to other developers and contribute to process improvements and coding standards

Data Architect with Data Modelling

Role: Data Architect with Data Modelling. Location: Remote. FULL TIME ONLY.

Location

United States

Salary:

Not provided

Realign

Expiration Date

Until further notice

Requirements

Excellent data modelling skills (Dimensional and 3NF)
Data modelling must have conceptual model showing core entities from CRM, e commerce, and finance systems, include relationships and grain for each table
Catalog federation or query federation
Must have implemented streaming (autoloader, CloudFiles, Spark Streaming, Event Hubs/Kafka)
Strong in Delta tables in Databricks
Extensive experience translating business requirements to data design requirements
Extensive data flow documentation experience
Azure experience - ADLS, Azure SQL
Snowflake or Databricks design experience
Excellent Communication skills for both technical and business communications

Job Responsibility

Excellent data modelling skills (Dimensional and 3NF)
Data modelling - must have created conceptual model showing core entities from CRM, e commerce, and finance systems, include relationships and grain for each table
Catalog federation or query federation
Must have implemented implement streaming (autoloader, CloudFiles, Spark Streaming, Event Hubs/Kafka)
Strong in Delta tables in Databricks
Extensive experience translating business requirements to data design requirements
Extensive data flow documentation experience
Azure experience - ADLS, Azure SQL
Snowflake or Databricks design experience
Excellent Communication skills for both technical and business communications

Fulltime

Senior Medicaid Data Architect

We are seeking an experienced Senior Medicaid Data Architect to lead the design,...

Location

United States , Austin

Salary:

Not provided

Dutech Systems

Expiration Date

Until further notice

Requirements

12+ years of experience in Data Architecture, Data Management, or Enterprise Information Management
Extensive knowledge of data architecture principles, frameworks, standards, and best practices
Strong experience with business processes, data flows, data relationships, data governance, and data quality management
10+ years of experience working with Medicaid data, including provider claims, encounters, member movements, and clinical assessment data
8+ years of experience designing, building, and maintaining Medicaid Data Warehouses
8+ years of experience with: Reference Data Management, Data Quality Management, Metadata Management, Enterprise Data Governance
Experience leading enterprise data transformation initiatives and promoting a data-driven culture
Excellent communication, presentation, analytical, and interpersonal skills

Job Responsibility

Develop and maintain enterprise data architecture strategies, standards, frameworks, and best practices
Design and oversee large-scale Medicaid data warehouse solutions supporting claims, encounters, provider, member, and clinical assessment data
Lead data architecture initiatives focused on data integration, data quality, metadata management, reference data management, and master data management (MDM)
Define and document enterprise data models, data flows, business rules, data relationships, and governance processes
Collaborate with business stakeholders, program leaders, analysts, and technical teams to align data solutions with organizational objectives
Establish and monitor data quality standards, controls, and metrics to ensure data accuracy, consistency, and reliability
Lead efforts to transform the organization into a data-driven culture by promoting data governance and data literacy practices
Design and implement data acquisition strategies supporting data warehouse, MDM, and performance management systems
Support reporting, analytics, business intelligence, and performance measurement initiatives
Evaluate emerging data technologies and recommend solutions that improve scalability, efficiency, and governance

Data Architect

Whitehall Resources are currently looking for a Data Architect in the West Midla...

Location

United Kingdom , West Midlands

Salary:

Not provided

Whitehall Resources Ltd

Expiration Date

Until further notice

Requirements

Strong experience as a SAS Architect or Senior SAS Technical Lead
Hands-on architectural experience with Legacy SAS (Base SAS, SAS Grid, SAS 9.x)
Proven experience integrating SAS with enterprise data warehouses
Experience working in regulated or large-scale enterprise environments

Job Responsibility

Own the architecture and technical design of SAS-based solutions across legacy SAS and SAS Viya environments
Provide design assurance and governance for SAS services, ensuring alignment with data platform and enterprise architecture standards
Support and guide teams consuming data warehouse sources (on prem and/or cloud) from SAS
Define and document integration patterns between data warehouses and SAS platforms
Advise on migration, coexistence and modernisation strategies between legacy SAS and Viya
Act as the technical authority for SAS-related decisions, risks and trade-offs
Collaborate with data engineers, platform teams and vendors to resolve complex issues
Ensure solutions consider security, performance, scalability and data quality

Fulltime

Data Architect

Carex is partnering with a financial services industry partner to hire a Data Ar...

Location

United States , Madison

Salary:

Not provided

Carex Consulting Group

Expiration Date

Until further notice

Requirements

Bachelor's degree in Computer Science, Information Systems, or related field, or equivalent professional experience
Strong experience in data architecture, data modeling, data warehousing, and enterprise data platform design
Deep domain expertise within insurance and financial services environments
Expertise with Microsoft data technologies including Fabric, Azure, Data Factory, Power BI, and Copilot
Strong hands-on experience with Databricks, Snowflake, and modern cloud-based data platforms
Experience building scalable enterprise data products and modern data ecosystems
Practical experience building MVPs leveraging Agentic AI and GenAI technologies for data management and operational efficiencies
Strong understanding of modern data architecture concepts including cloud-native solutions, real-time data distribution, metadata management, and enterprise governance
Advanced proficiency with SQL, NoSQL, and enterprise data modeling tools
Experience developing and implementing enterprise data governance and data quality frameworks

Job Responsibility

Design and implement modern enterprise data architectures that support scalable, secure, and cost-effective data platforms and solutions
Establish future-state data architecture blueprints aligned to enterprise business goals and strategic data initiatives
Lead architecture efforts for data products, data lakes, data warehouses, and cloud-native environments
Develop conceptual and logical data models that promote consistency, standardization, and reusability across the organization
Drive enterprise data integration strategies across multiple systems and platforms
Partner with engineering and DevOps teams to implement scalable data storage and management solutions
Build and maintain architecture documentation including data models, lineage, standards, and data flow diagrams
Establish and enforce data governance, lineage, security, and quality management standards
Ensure architectural alignment with enterprise compliance, governance, and security requirements
Evaluate and recommend modern technologies and tools that improve data engineering and analytics capabilities

Data Architect

Ventois is always looking for talented people to become its team members. Projec...

Location

United States , Shrewsbury

Salary:

Not provided

Ventois

Expiration Date

Until further notice

Requirements

bachelor’s degree in Computer Science, Computer Information Systems, Information Technology, or a closely related field, or a combination of education and experience equating to the US equivalent if a bachelor’s degree in one of the aforementioned subjects

Job Responsibility

Provide knowledge transfer of business processes and reporting workflows to stakeholders and end users
Assess, design, and optimize data workflows to support efficient data processing and analytics
Configure and maintain Qlik data connections to various source systems ensuring secure and reliable access
Prepare analytic-ready datasets, including data modeling and transformation for reporting and analytics
Develop and optimize Qlik scripts and data models to support scalable and high-performance applications
Design, develop, test, and deploy Qlik dashboards and analytical applications aligned with business requirements
Create wireframes and visualization layouts to support intuitive and user-friendly reporting solutions
Configure dashboard functionality, perform validation testing, and ensure accuracy of outputs
Develop UI/UX enhancements and customizations to improve user experience and usability
Implement robust security models, including role-based access and data-level security controls

Fulltime

Select Country

Data Warehouse Architect

Job Description

Requirements

Nice to have

Looking for more opportunities?