Data Warehouse Architect - Solutions Architect

Zenfreed, LLC; Town of Lansing (NY); Hybrid; USD 130,000 - 180,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Job summary

Zenfreed, LLC is seeking a Data Warehouse Architect / Solutions Architect in Lansing, United States to lead enterprise data platform modernization. You will design target state architecture and architect Data, Analytics, and ML products aligned with enterprise strategy, data security, and governance.

Collaborate with engineering, analytics, security, and business teams to translate strategic needs into technical roadmaps, select technologies, and ensure scalable data platforms across on-prem and

Qualifications

• 5+ years leading Data Architects and working with Enterprise Architects to align data landscape with business and technology landscapes.
• Experience developing Reference Architectures and Architecture Reviews to ensure architectural integrity.

Responsibilities

• Track emerging industry capabilities for modern Data Platforms.
• Develop target state Data Platform Architecture aligning with data strategy and security.
• Designs, implements, and supports data warehouse and analytics platform modernization initiatives.
• Lead adoption of cloud-based data services and other modern technologies.
• Oversee sustainability of data warehouse and analytics processes and governance.
• Design and maintain architecture for enterprise data platforms ensuring scalability and reliability.
• Oversee implementation of data platform components (storage, streaming, orchestration).
• Establish governance for data quality, metadata, security, and regulatory compliance.
• Collaborate with engineering, analytics, security, and business teams to translate needs into technical roadmaps.
• Select hardware, software, tools and lifecycle techniques for data warehouse components.

Skills

SQL

Python

R

Java

Data Lake

Delta Lake

Databricks

Power BI

TOGAF

NoSQL DB

GraphDB

ETL

Education

Bachelor's Degree

Tools

Databricks

Power BI

Job description

Data Warehouse Architect - Solutions Architect

Lansing, United States | Posted on 09/04/2026

• Minimum Education Requirement Bachelor's Degree
• City Lansing
• Country United States

Job Description

Data Platform Architect / Datawarehouse Architect (Level 5) excels in tracking emergingindustry capabilities for modern Enterprise Data Platform (EDP), developing target state Data Platform Architecture, and architecting Data, Analytics, and ML Products that are aligned with the enterprise data strategy, data landscape, data skills, data security, and data sharing needs to support the realization of enterprise Business Strategy outcomes.

Job Duties

• Excels in tracking emerging industry capabilities for modern Data Platforms,
  
• Developing target state Data Platform Architecture, and architecting Data, Analytics, and ML Products that are aligned with the
  
• enterprise data strategy, data landscape, data skills, data security, and data sharing needs to support the realization of enterprise Business Strategy outcomes
  
• Designs, implements, and supports MDHHS data warehouse and analytics platform modernization initiatives
  
• Recommends and leads State of Michigan teams in adopting emerging cloud-based data services, analytical tools, and other modern technologies.
  
• Oversees the organizational sustainability of data warehouse and data analytics process improvement. The Data Platform Architect’s responsibilities include:
  
• Design and maintain the overall architecture for enterprise data platforms, ensuring scalability, reliability, and alignment with business objectives.
  
• Oversee the implementation of modern data platform components, such as storage, streaming, and orchestration services, and ensure they function cohesively.
  
• Establish governance frameworks for data quality, security, metadata management, and compliance with organizational and regulatory requirements.
  
• Collaborate with engineering, analytics, security, and business teams to translate strategic needs into technical solutions and roadmap initiatives.
  
• Responsible for selection of appropriate hardware, software, tools and system lifecycle techniques for different components of data warehouse architecture including ETL, Metadata, data profiling software, performance monitoring, reporting and analytic tools
  

Requirements

5 years:

• Experience in leading Data Architects and working with Enterprise Architects to develop Data Landscape, Data Strategy, Data Architectural approaches using any industry standard Architecture framework such as TOGAF 9, FEAF, DODAF etc. to align data landscape with business, application and technology landscapes of an enterprise to support the implementation of data-driven business strategy.
  
• Experience in developing Reference Architectures, Architecture Patterns Library, conducting Architectural Reviews to identify exceptions, and managing the architectural exceptions to ensure architectural integrity of Enterprise Data Platform in a large enterprise.
  
• Experience in developing Enterprise Data Technology Strategies, articulating the use of the Data Engineering Delivery Methodologies, building the Data Engineering Standards & Best Practices to ensure alignment of Data/Analytics/ML Products with the Target State Architecture, and promoting the use of the Data Engineering products in the community of Users using industry standard Enterprise Architecture frameworks such as TOGAF, FEAF, DODAF etc.
  

3 years:

• Experience in driving RFP process of selecting Data PlatformTechnologies, partnering with vendors to co-develop innovative EDP capabilities, drivingEDP innovation, and promoting data-driven decision-making culture in the enterprise through Communities of Practice etc.
  

Expertise in driving innovation related to modern data technology platforms through conducting Proofs of Concepts, Codathon, and Co- development with technology vendors, to fully comprehend the business capabilities feasible from emerging technologies to design effective Proofs of Concepts and lead the execution of POCs in Must have a BS in Computer Science / Data Science / Information Systems or a related CS degree

Experience in the full technology stack within an Enterprise Data Platform offering of any CSP to help an enterprise set up the initial fully functioning instance of an EDP containing all the required tools to enable the Data Engineering team in conducting Proofs of Concepts and operationalizing the Product Environment for the delivery of Data Engineering products including Data/Analytics/ML pipelines.

Experience in driving the procurement process (RFI/RFP etc.) in a large enterprise to select the Cloud Service Provider vendor for building and hosting the EDP.

Experience in architecting Data Services Portfolio and Data Products that are aligned with the industry best practices and internal data

engineering capabilities.

Expertise in baking in the Data Governance standards and best practices into the development and usage of the Data Engineering Products including the Data/Analytics/ML pipelines and Data/Analytics/ML Products.

Experience in enforcing the adherence to the implementation of Data Security Standards and Best Practices into the Data

Engineering Products including Data/Analytics/ML Products and Data Pipelines to minimize data security vulnerabilities.

Desired Skills

• Experience with Data Lake, Delta Lake, EDP, Data Warehousing, and Databricks
  
• Demonstrated experience in Supporting the enterprise in ensuring that all the Data Engineering efforts such as POCs, early implementations, and technology refresh of legacy systems etc. are aligned to help the Data Engineering team stay focused on systematically building and maturing the required technical and delivery capabilities
  
• Experience in tracking the Architectural adherence of Data Engineering Products and Pipelines to the Enterprise Architecture Standards and Best Practices and supporting the Data Engineering team to systematically enhance their capability maturity in delivering high-quality Data Engineering Products.
  
• Key Programming Languages: SQL, Python, R, Java
  
• Other Technologies, Concepts and Frameworks: TOGAF, Data Lake, Delta Lake, NoSQL DB, GraphDB, EDP, Data Warehousing, Data Marts, Databricks, Operational Data Stores, Power BI,
  
• Bachelor's Degree
  

Location

• Open to local candidates or those willing to relocate BUT they must relocate from day one AND they must come on-site for 2nd round interview. Candidates not willing to do this will not be considered.
  
• Positionis a hybrid schedule withNO remote-only option. Wednesdays and Thursdays are required on-site days (non-negotiable)
  
• Working hoursMonday-Friday, approximately 8:00 a.m. to5:00 p.m.
  

AdditionalRequirements

• Must be authorized towork in the United States; We are unable to offersponsorships at this time
  
• Must undergo a background checkand drug screening for employment.
  

EmploymentTerms

• This is a W2 position
  
• HYBRID schedule -NO remote-only option. Wednesdays and Thursdays are required on-site days (non-negotiable)
  

AtZenfreed, we are more than an IT company. We bridge thegap between people wanting to do the work they were meant to doand organizations needing the right talent.

We are dedicated to building a diverse,inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description,

We understand a comprehensive benefits package is crucial to employment satisfaction. We offer medical, dental and vision coverageoptions for all employees.