Skip to content
×

Data Warehouse Architect

Job in Lansing, Ingham County, Michigan, 48933, USA
Listing for: HTC Global Services Inc
Full Time position Listed on 2026-11-17

Job Description & How to Apply Below

Position: Data Warehouse Architect 3
Job Title:

Lead Data Engineer – Cloud Data Lake & Lakehouse Architecture

Position Overview Lead the architecture and delivery of enterprise-scale data engineering solutions supporting analytics, operational systems, and machine learning applications. This role combines hands-on Cloud Data Engineering, Lakehouse and Medallion Architecture, Data Product development, and technical leadership. The Lead Data Engineer will oversee the design, development, and optimization of data pipelines and infrastructure while establishing data quality, governance, and security practices.

The position also provides technical guidance, mentoring, and collaboration across data engineering, analytics, and ML teams to support scalable and reliable Data Product delivery. What You'll Do /

Key Responsibilities Oversee the design, development, and maintenance of data pipelines that move, transform, and prepare data for analytics and operational systems. Architect and optimize data infrastructure, including storage solutions, orchestration frameworks, and ETL/ELT processes. Ensure data quality, reliability, and security by establishing standards, monitoring systems, and implementing validation and governance practices. Lead and mentor data engineering staff, providing technical guidance, reviewing designs and code, and supporting professional growth.

Collaborate with data scientists, analysts, product teams, and business stakeholders to ensure data solutions meet organizational needs and strategic goals. Support best practice adoption within the state hosting environment and provide training to data engineers. Develop and support Cloud Data Lake and Lakehouse solutions using relational, semi-structured, and unstructured data sources. Transform datasets into Data Products with traceability to Critical Data Elements in systems of record.

Support enforcement of Data Sharing Policies to ensure subscribers access only the Data Product versions authorized for their subscriptions. Design and deliver Star Schema-based operational data stores supporting visualization of program activities and outcomes.

Required Qualifications Bachelor's degree. Bachelor's degree in Computer Science, Data Science, or Information Systems, as specified in the additional desired skills. Minimum 4 years of hands-on experience building Extract and Load Data Pipelines to hydrate enterprise Data Lakes on AWS, Azure, or Google Cloud from relational, semi-structured, and unstructured data sources. Minimum 4 years of hands-on experience transforming Cloud Data Lake datasets into Data Products with traceability of attributes and features to Critical Data Elements in systems of record.

Minimum 2 years of experience enforcing Data Sharing Policies to ensure users access only the Data Product versions authorized at the time of subscription. 4+ years of experience designing and implementing enterprise data, analytics, and AI solutions using Cloud Service Provider data platform tools. Minimum 4 years of experience modeling and leveraging relational data services, with demonstrated proficiency in Python/PySpark/SQL programming and SQL query tuning.

Minimum 4 years of demonstrated experience in programming and scripting languages including Python, R, and Spark. Experience designing and delivering Star Schema-based operational data stores for visualization using tools such as Power BI. Proficiency in SQL, Python, and Spark-based data engineering.

Preferred Qualifications Proficiency in Dev Ops tools including Git Hub, Jenkins, Terraform, YAML, DAGs, Docker, Databricks, and Sage Maker for Data/ML pipeline development. Experience promoting Data Engineering standards and best practices across developer communities. Experience implementing Cloud Service Provider Data Governance and Security tools to automate Data Sharing Policy enforcement at Data Product subscription.

Experience with distributed data architectures and technologies including Kafka, Kubernetes, No

SQL databases, and Graph databases.

Experience with Lakehouse and Medallion Architecture concepts.

Experience with visualization tools such as Power BI and Tableau. Familiarity with Juniper Notebooks, Parquet, Glue, Redshift Spectrum, DBT, Datahub, and Sage Maker. Experience supporting Data, Analytics, and ML Product delivery using Agile and Dev Ops frameworks. Technologies & Tools SQL, Python, R, PySpark, Spark, Terraform, YAML, DAGs, Docker, Juniper Notebooks, No

SQL databases, Graph databases, Parquet, Lakehouse, Medallion…
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)
Education Level
Experience Level (years)
Posted in last:
Salary