Data Warehouse Architect - Solutions Architect

Job Description Data Platform Architect / Datawarehouse Architect (Level 5) excels in tracking emergingindustry capabilities for modern Enterprise Data Platform (EDP), developing target state Data Platform Architecture, and architecting Data, Analytics, and ML Products that are aligned with the enterprise data strategy, data landscape, data skills, data security, and data sharing needs to support the realization of enterprise Business Strategy outcomes. Job Duties Excels in tracking emerging industry capabilities for modern Data Platforms, Developing target state Data Platform Architecture, and architecting Data, Analytics, and ML Products that are aligned with the enterprise data strategy, data landscape, data skills, data security, and data sharing needs to support the realization of enterprise Business Strategy outcomes Designs, implements, and supports MDHHS data warehouse and analytics platform modernization initiatives Recommends and leads State of Michigan teams in adopting emerging cloud-based data services, analytical tools, and other modern technologies. Oversees the organizational sustainability of data warehouse and data analytics process improvement. The Data Platform Architect’s responsibilities include: Design and maintain the overall architecture for enterprise data platforms, ensuring scalability, reliability, and alignment with business objectives. Oversee the implementation of modern data platform components, such as storage, streaming, and orchestration services, and ensure they function cohesively. Establish governance frameworks for data quality, security, metadata management, and compliance with organizational and regulatory requirements. Collaborate with engineering, analytics, security, and business teams to translate strategic needs into technical solutions and roadmap initiatives. Responsible for selection of appropriate hardware, software, tools and system lifecycle techniques for different components of data warehouse architecture including ETL, Metadata, data profiling software, performance monitoring, reporting and analytic tools Requirements 5 years: Experience in leading Data Architects and working with Enterprise Architects to develop Data Landscape, Data Strategy, Data Architectural approaches using any industry standard Architecture framework such as TOGAF 9, FEAF, DODAF etc. to align data landscape with business, application and technology landscapes of an enterprise to support the implementation of data-driven business strategy. Experience in developing Reference Architectures, Architecture Patterns Library, conducting Architectural Reviews to identify exceptions, and managing the architectural exceptions to ensure architectural integrity of Enterprise Data Platform in a large enterprise. Experience in developing Enterprise Data Technology Strategies, articulating the use of the Data Engineering Delivery Methodologies, building the Data Engineering Standards & Best Practices to ensure alignment of Data/Analytics/ML Products with the Target State Architecture, and promoting the use of the Data Engineering products in the community of Users using industry standard Enterprise Architecture frameworks such as TOGAF, FEAF, DODAF etc. 3 years: Experience in driving RFP process of selecting Data PlatformTechnologies, partnering with vendors to co-develop innovative EDP capabilities, drivingEDP innovation, and promoting data-driven decision-making culture in the enterprise through Communities of Practice etc. Expertise in driving innovation related to modern data technology platforms through conducting Proofs of Concepts, Codathon, and Co- development with technology vendors, to fully comprehend the business capabilities feasible from emerging technologies to design effective Proofs of Concepts and lead the execution of POCs in Must have a BS in Computer Science / Data Science / Information Systems or a related CS degree Experience in the full technology stack within an Enterprise Data Platform offering of any CSP to help an enterprise set up the initial fully functioning instance of an EDP containing all the required tools to enable the Data Engineering team in conducting Proofs of Concepts and operationalizing the Product Environment for the delivery of Data Engineering products including Data/Analytics/ML pipelines. Experience in driving the procurement process (RFI/RFP etc.) in a large enterprise to select the Cloud Service Provider vendor for building and hosting the EDP. Experience in architecting Data Services Portfolio and Data Products that are aligned with the industry best practices and internal data engineering capabilities. Expertise in baking in the Data Governance standards and best practices into the development and usage of the Data Engineering Products including the Data/Analytics/ML pipelines and Data/Analytics/ML Products. Experience in enforcing the adherence to the implementation of Data Security Standards and Best Practices into the Data Engineering Products including Data/Analytics/ML Products and Data Pipelines to minimize data security vulnerabilities. Desired Skills Experience with Data Lake, Delta Lake, EDP, Data Warehousing, and Databricks Demonstrated experience in Supporting the enterprise in ensuring that all the Data Engineering efforts such as POCs, early implementations, and technology refresh of legacy systems etc. are aligned to help the Data Engineering team stay focused on systematically building and maturing the required technical and delivery capabilities Experience in tracking the Architectural adherence of Data Engineering Products and Pipelines to the Enterprise Architecture Standards and Best Practices and supporting the Data Engineering team to systematically enhance their capability maturity in delivering high-quality Data Engineering Products. Key Programming Languages: SQL, Python, R, Java Other Technologies, Concepts and Frameworks: TOGAF, Data Lake, Delta Lake, NoSQL DB, GraphDB, EDP, Data Warehousing, Data Marts, Databricks, Operational Data Stores, Power BI, Minimum Education Bachelor's Degree Location Open to local candidates or those willing to relocate BUT they must relocate from day one AND they must come on-site for 2nd round interview. Candidates not willing to do this will not be considered. Position is a hybrid schedule with NO remote-only option. Wednesdays and Thursdays are required on-site days (non-negotiable) Working hours Monday-Friday, approximately 8:00 a.m. to 5:00 p.m. Additional Requirements Must be authorized to work in the United States; We are unable to offer sponsorships at this time Must undergo a background check and drug screening for employment. Employment Terms This is a W2 position 40 hrs per week HYBRID schedule - NO remote-only option. Wednesdays and Thursdays are required on-site days (non-negotiable) About Zenfreed At Zenfreed, we are more than an IT company. We bridge the gap between people wanting to do the work they were meant to do and organizations needing the right talent. We are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles. Benefits We understand a comprehensive benefits package is crucial to employment satisfaction. We offer medical, dental and vision coverage options for all employees.