Snowflake Solution Architect

The primary objective of this project is to import and set up ongoing replication from our on premises TAP data warehouse as well as Salesforce Cloud.Transaction data from the data warehouse must then be merged with customer and program account data from Salesforce and then optimized for ingestion into analytics platforms.The solutions architect will also establish best practices for account creation and sharing with our partner agencies with priority on maintaining privacy of customer data while meeting the business needs of our partners.Scope of WorkProfessional Services and Support – Data Lakehouse Solution Architect• Advise LACMTA staff on best practices for ongoing replication from both on-prem and cloud sources including Oracle, Salesforce, Microsoft Azure, AWS and other Cloud data sources used by LA County.• Update Microsoft PowerBI report source queries from Oracle to Snowflake• Work closely with the LACMTA TAP team to develop data marts tailored to TAP programs and initiatives to rapidly meet business needs.• Implement Streamlit dashboards and summary reports to visualize data• Documentation of Snowflake setup and ongoing processes (ETL processes, RBAC structure, etc) At KAYGEN, we are always looking for dynamic, talented and experienced individuals. We invite you to join our team of talented IT professionals, consulting at client locations across the globe. Our culture is team-orientated; we strive to stand by our core values of respect, honesty and integrity. Our team of experienced staffing experts will work with you to find you the best opportunity. For more information, please visit us at Benefits:Free Healthcare InsuranceVision and Dental Insurance401(k) Retirement PlanFree Life InsuranceSick Time Off Achieve your Kaizen by clicking here. A unique and exclusive talent community supported by Kaygen, that includes programs like:CertificationsMentorship ProgramReferralsFamily and Wellness benefitsContinuous Growth and Career Development