Job Overview: We are seeking an experienced and technically proficient Data Engineering Lead to lead the design, development, and implementation of enterprise-scale data engineering solutions. The ideal candidate will have strong expertise in data modeling, Cloud Data Platforms, Lakehouse and Medallion Architecture, distributed data processing, and Data/ML product delivery. The candidate will lead data engineering initiatives, establish technical standards and best practices, and collaborate with cross-functional teams to build scalable, secure, reliable, and high-performing data products. This role will serve as the primary State of Michigan technology lead, working closely with the University of Michigan (U-M) proof-of-concept team to promote best practices within the state's hosting environment and provide technical guidance and training to DAV data engineers. Key Responsibilities: Lead the architecture, design, development, and maintenance of enterprise data pipelines for extracting, loading, transforming, and delivering data products. Design and implement scalable Cloud Data Lake and Lakehouse solutions using AWS, Microsoft Azure, or Google Cloud Platform. Build and optimize ETL/ELT pipelines integrating relational, semi-structured, and unstructured data sources. Implement Lakehouse and Medallion Architecture (Bronze, Silver, and Gold layers) using Parquet-based data storage. Develop data models, including relational models, dimensional models, and Star Schema-based Operational Data Stores (ODS). Ensure end-to-end data lineage and traceability of data product attributes and features to Critical Data Elements (CDEs) in systems of record. Implement data governance, security, and data-sharing policies to ensure subscribers can access only the appropriate versions of authorized data products. Establish data quality, validation, monitoring, and performance optimization standards. Architect and optimize distributed data processing, storage, and orchestration frameworks. Collaborate with data scientists, business analysts, product owners, and stakeholders to deliver data, analytics, and operational ML solutions. Lead and mentor data engineering teams through technical guidance, code reviews, design reviews, and knowledge-sharing sessions. Promote enterprise data engineering standards and DevOps best practices. Support the State of Michigan's technology initiatives and provide technical training and mentorship to DAV data engineers. Required Qualifications & Technical Skills: Bachelor's degree in Computer Science, Data Science, Information Systems, or a related technical discipline. Minimum 4+ years of hands-on experience designing and implementing enterprise-scale data engineering, analytics, and AI solutions. Minimum 4 years of hands-on experience building Extract and Load data pipelines to hydrate enterprise Data Lakes from relational, semi-structured, and unstructured data sources. Minimum 4 years of experience transforming and modeling datasets within cloud-based Data Lakes to deliver enterprise Data Products. Experience implementing data lineage, metadata management, and traceability of data product attributes to Critical Data Elements (CDEs). Minimum 2 years of experience implementing and enforcing data-sharing policies to ensure users receive only the authorized version of a Data Product based on their subscription and access privileges. Strong hands-on programming experience with Python, PySpark, SQL, and Spark. Experience with relational databases, NoSQL databases, and Graph databases. Strong understanding of Lakehouse, Medallion Architecture, distributed data processing, and Parquet data formats. Experience designing and implementing Star Schema-based data models and Operational Data Stores (ODS). Proficiency in SQL