Data Warehouse Architect 3- (Hybrid)

GSK Solutions Inc.; Lansing (MI); Hybrid; USD 110,000 - 117,000; Full time

Job summary

GSK Solutions Inc. is seeking a Data Warehouse Architect lead in Lansing, MI. The role focuses on data modeling, Lakehouse and ML product delivery within an agile DevOps framework, leveraging Spark, Kafka, Kubernetes, SageMaker, DBT, and visualization tools like Power BI or Tableau.

You will guide a team, design robust pipelines, and partner with data scientists and business users to enable analytical and operational ML workloads.

Qualifications

• 4+ years hydrating Data Lake on a cloud provider (AWS/Azure/GCP).
• 4+ years transforming datasets to deliver data products with traceable attributes.
• 2+ years enforcing data sharing policies and access control.

Responsibilities

• Oversee design, development, and maintenance of data pipelines for analytics and operations.
• Architect and optimize data infrastructure, storage, orchestration, ETL/ELT.
• Ensure data quality, reliability, and security with governance practices.
• Lead and mentor data engineering staff and review designs.
• Collaborate with data scientists, analysts, product teams, and stakeholders to meet goals.

Skills

Data modeling

Mentoring

DevOps practices

Cross-functional collaboration

Education

Bachelor's Degree

Tools

Spark

Kafka

Kubernetes

SageMaker

DBT

Docker

Power BI/Tableau

Job description

Job Title: Data Warehouse Architect 3- (Hybrid)

Location: Lansing, MI

Duration: 12 Months+

Pay Rate: $85/hr. On 1099 and $80/hr on W2 All Inclusive.

Interview Type: Virtual and In-Person. 1st round is virtual, 2nd round is in-person.

Note:

• Please include 2 professional references attached as a SEPARATE document. Must include their name, company they worked together at, title, phone number, and email
• Please note: travel outside of the weekly commute is required for this role: Occasionally traveling to Ann Arbor for in-person meetings. Nothing you need to attach to the submission for this, just make sure your candidates are aware and ok with this before submitting.
• Hybrid Work Schedule: Wednesday and Thursday are REQUIRED in-office days. This is NON-NEGOTIABLE and there is NO remote only option.
• Local candidates vs non-local: Open to candidates local to the Lansing Michigan area and those willing to relocate. Candidates that relocate must relocate before day one and be ready to be on-site from day one at their own expense (non-negotiable)
• Clear and concise written and verbal communication is crucial to success and productivity in this role

Job Description:

Data Engineering Lead excels in data modeling, Lakehouse and Medallion Architecture concepts, and data/ML products delivery using an agile DevOps 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, SageMaker, DBT, Juniper Notebooks, Docker, SQL, and visualization tools such as Power BI/Tableau with the following track record:

Data Engineering Lead excels in data modeling, Lakehouse, and ML products delivery using an agile DevOps framework with a mastery of distributed data architectures essential for data, analytical and operational ML applications with demonstrated proficiency in frameworks including DataBricks, Sagemaker, Spark, Kafka, Kubernetes, SQL, NoSQL DBs, Graph DBs, and visualization tools such as Power BI/Tableau.

The Data Engineer Lead serves as the primary State of Michigan 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:

• 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/code, and supporting professional growth.
• 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.

Top Skills & Years of Experience

Required Education: Bachelors Degree Required Skills:

• 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.
• 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.
• 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 DevOps tools including Github/Jenkins/Terraform/YAML/DAGs/Docker/Databricks/SageMaker 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.