Data Warehouse Architect 3

Location: Lansing, MI (MI) | Employment Type: Full Time - 40 hours per week | Job Level: T3 | Work Preference: Hybrid | Job Code: 246288

Job Description:

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 DevOps tools including GitHub, Jenkins, Terraform, YAML, DAGs, Docker, Databricks, and SageMaker 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, NoSQL 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 SageMaker.

  • Experience supporting Data, Analytics, and ML Product delivery using Agile and DevOps frameworks.

Technologies & Tools

SQL, Python, R, PySpark, Spark, Terraform, YAML, DAGs, Docker, Juniper Notebooks, NoSQL databases, Graph databases, Parquet, Lakehouse, Medallion Architecture, Kafka, Kubernetes, Glue, Databricks, Power BI, Tableau, Redshift Spectrum, SageMaker, DBT, Datahub, GitHub, and DevOps tools.

 

What Makes HTC A Great Place To Build Your Future

HTC Global Services wants you to join our team. Come build new things with us and advance your career. At HTC Global, you’ll collaborate with experts, work alongside clients, and be part of high-performing teams driving success together. You’ll have long-term opportunities to grow your career and develop skills in the latest emerging technologies.

At HTC Global Services, our employees have access to a comprehensive benefits package. Benefits can include Group Health (Medical, Dental, and Vision), Paid Time Off, Paid Holidays, 401(k) matching, Group Life and Disability insurance, Professional Development opportunities, Wellness programs, and a variety of other perks.

Our success as a company is built on inclusion and diversity. HTC Global Services is committed to providing a workplace free from discrimination and harassment, where every employee is treated with dignity and respect. We celebrate differences and believe that diverse cultures, perspectives, and skills drive innovation and success. HTC is an Equal Opportunity Employer and a proud National Minority Supplier. We seek to empower each individual, fostering an environment where everyone feels valued, included, and respected.

#LeadDataEngineer #SeniorDataEngineer #DataEngineeringLead #CloudDataEngineer #DataArchitect #DataWarehouseArchitect #Lakehouse #MedallionArchitecture #DataLake #DataProducts #PySpark #Python #Spark #SQL #AWS #Azure #GCP #DataModeling #DataPipelines #ETL #ELT #DataGovernance #DataLineage #DataSharing #StarSchema #Databricks #SageMaker #Kafka #Kubernetes #Terraform #Docker #DBT #PowerBI #Tableau #MachineLearning #CloudDataArchitecture #EnterpriseDataEngineering #DataEngineeringLeadership #DataPlatform #DataAnalytics #DataEngineering #CloudArchitecture #BigData #Parquet #NoSQL #GraphDB #DevOps #DataSecurity #DataQuality #DataEngineeringStandards #DataProductArchitecture 

SIMILAR OPENINGS

No similar jobs found.

At HTC Global Services, our culture is an embodiment of who we are – a value-led organization committed to success of our people and customers.

  • Hybrid and Workplace flexibility
  • Work-Life-Balance
  • Well-defined career development plan
  • Rewards & Recognition program
  • L&D focuses on upskilling
  • Hands-on experience on Emerging Technologies and Digital Transformation
  • Career Mobility programs

Join Our Talent Community

Tell us about yourself, and we will keep you informed about opportunities that match your interests.

Register