Skip to content
×

Data Warehouse Architect

Job in Lansing, Ingham County, Michigan, 48900, USA
Listing for: Digital Technology Solutions
Full Time position Listed on 2026-11-22

Job Description & How to Apply Below

DTS is looking for Data Warehouse Architect for a direct client position in Lansing, MI

Job Description:

Required Skills:

1. Minimum 4 years of hand-on experience is required in hydrating the enterprise Data Lake on a Cloud Service Provider (AWS, Azure, or Google) from relational, semi-structured and unstructured data sources by building Extract and Load Data Pipelines.
2. Minimum of 4 years hands-on experience is required in Transforming the datasets in a Data Lake on a Cloud Service Provider to deliver Data Products with traceability of their attributes / features to the Critical Data Elements in the systems of record.
3. Minimum of 2 years experience is required in enforcing Data Sharing Policies to Data Products to ensure that User get to see only the version of the Data Product the User is entitled to get access to at the time of subscription. Preferred

Skills:

· Proficiency desirable in Dev Ops tools including Github/Jenkins/Terraform/YAML/DAGs/Docker/Databricks/Sage Maker etc. for building Data/ML pipelines to extract/store data from multiple sources to parquet destinations.
· Experience desirable in promoting Data Engineering Standards and Best Practices among the community of developers to influence the enterprise towards building scalable and supportable Data/ML Products delivery and their usage by the community of data, analytics, and ML product users.
· Experience desirable in implementing Data Governance and Data Security tools available on a CSP to automate the enforcement of Data Sharing Policies at the point of subscription of a Data Product by a subscriber.

Job Description:

Data Engineer Lead/Data Warehouse Architect (Level
3) Data Engineering Lead excels in data modeling, Lakehouse and Medallion Architecture concepts, and data/ML products delivery using an agile Dev Ops framework with a mastery of distributed data architectures essential for data, analytical and operational ML applications with demonstrated proficiency in frameworks including Spark, Kafka, Kubernetes, Sage Maker, DBT, Juniper Notebooks, Docker, SQL, and visualization tools such as Power BI/Tableau with the following track record:

Roles and Responsibilities:

Data Engineering Lead excels in data modeling, Lakehouse, and ML products delivery using an agile Dev Ops framework with a mastery of distributed data architectures essential for data, analytical and operational ML applications with demonstrated proficiency in frameworks including Data Bricks, Sagemaker, Spark, Kafka, Kubernetes, SQL, No

SQL DBs, Graph DBs, and visualization tools such as Power BI/Tableau. The Data Engineer Lead serves as the primary client technology lead engaging with the UoM proof of concept team to support best practice adoption within the state hosting environment and provides training to DAV data engineers. This role’s responsibilities include:
4. Oversee the design, development, and maintenance of data pipelines that move, transform, and prepare data for analytics and operational systems.
5. Architect and optimize data infrastructure, including storage solutions, orchestration frameworks, and ETL/ELT processes.
6. Ensure data quality, reliability, and security by establishing standards, monitoring systems, and implementing validation and governance practices.
7. Lead and mentor data engineering staff, providing technical guidance, reviewing designs/code, and supporting professional growth.
8. Collaborate with cross functional partners, such as data scientists, analysts, product teams, and business stakeholders, to ensure data solutions meet organizational needs and strategic goals. Other Desired

Skills:

· Must have a BS in Computer Science / Data Science / Information Systems with an overall 4+ years of experience in designing and…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction

Search for further Jobs Here:

SEARCH JOBS: 10+ Million Listings
(Try combinations for better Results! Or enter less keywords for broader Results)
Job language:
Education Level
Experience Level (years)
Posted in last:
Salary