Solution Architect

Solution ArchitectLocation: New York City, NY (Hybrid: 3 Days in Office and 2 Days Remote) Full-timeExpert in building data warehouses and analytics solutions using Snowflake.Mastery in building Azure cloud solutions, especially using ADF.Expert in GIT and branching strategies for Azure ADF.Expert in administering Azure DevOps, including release management.Knowledgeable in optimizing cloud operational costs.Expert in Snowflake platform.Expert in modern data warehousing and data lake concepts.Expert in data protection, privacy, access control, and masking.Embrace infrastructure-as-code and make sure all deployment and release activities are automated.Accountable for the solution's architecture, design, non-functional, and quality requirements.Expert data modeler responsible for conceptual, logical models that meet business needs today and can withstand the test of time.Design a data platform to enable citizen analysts to perform self-service analytics.Ensure metadata like data catalog, data lineage, and labels are captured.Review and approve work in Snowflake and data lakes like DDL, metadata, and other scripts.Review and approve pull requests for all the development activities.Assist with troubleshooting end-to-end solutions and help developers and testers.Should be able and willing to participate in development activities throughout the solution's technology stack.Proposal RecommendationsProvide a written description of the knowledge areas and relevant experience of the individuals your firm is proposing to. Specifically, please cite any experience or knowledge of the following:Data Engineering experience using Azure and Snowflake or similar platforms.Data Architecture, Data warehouses and Data Lake.Agile development methodologies.Automated Testing and Testing methodologies and techniques.Business analysis in data analytics.Data stewardship and governance.Public transportation planning and operations