RandomTrees ยท 1 day ago
Technical Manager
United States
Contract
Remote
Senior LevelRandomTrees is seeking a Technical Lead with strong expertise in Snowflake and ETL. The role involves leading the migration of Enterprise Data Warehouses to Snowflake and managing project scope, timelines, and stakeholder communication.
Artificial Intelligence (AI)Information Technology
Hiring Manager
Sanchana Murali
Responsibilities
Manage conversion of 6000+ Informatica ETL workflows to Snowflake ELT patterns, coordinating with development teams on complexity analysis, GenAI-assisted reverse engineering, SQL optimization, Autosys scheduler integration, and data validation/reconciliation
Oversee retrofitting of 120 Cognos Framework Managers, 4500+ Cognos reports, and 150 Power BI dashboards to Snowflake, ensuring functional equivalency, performance SLAs, and business user acceptance
Provide technical oversight on Snowflake architecture including database design, warehouse optimization, RBAC implementation, performance tuning, and integration with AWS DMS, S3, Collibra
Monitor Snowflake cost optimization through credit consumption tracking, query performance analysis, resource monitors, and implement best practices for streams, tasks, Time Travel, and data sharing
Coordinate with cross-functional teams in different geographies (Snowflake architects, ETL developers, data engineers, Cognos/Power BI developers, QA testers) with sprint planning, daily stand-ups, and velocity tracking
Deliver Project artifacts; facilitate smooth cutover; transition to support and stakeholder sign-off
Qualification
Required
Strong expertise in Snowflake and ETL
Project management experience
Experience in leading end-to-end migration of Enterprise Data Warehouses from Oracle Exadata to Snowflake on AWS
Ability to manage project scope, timeline, risk mitigation, and stakeholder communication
Experience in managing conversion of Informatica ETL workflows to Snowflake ELT patterns
Coordination with development teams on complexity analysis, GenAI-assisted reverse engineering, SQL optimization, Autosys scheduler integration, and data validation/reconciliation
Oversight of retrofitting Cognos Framework Managers, Cognos reports, and Power BI dashboards to Snowflake
Technical oversight on Snowflake architecture including database design, warehouse optimization, RBAC implementation, performance tuning, and integration with AWS DMS, S3, Collibra
Monitoring Snowflake cost optimization through credit consumption tracking, query performance analysis, resource monitors
Implementation of best practices for streams, tasks, Time Travel, and data sharing
Coordination with cross-functional teams in different geographies
Experience in sprint planning, daily stand-ups, and velocity tracking
Delivery of project artifacts and facilitation of smooth cutover
Transition to support and stakeholder sign-off
Company
RandomTrees
RandomTrees provide enterprise artificial intelligence solutions.
Founded in 2017
201-500 employees
H1B Sponsorship
RandomTrees has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (9)
2024 (14)
2023 (3)
2022 (2)
2021 (2)
Funding
Current Stage
Growth StageCompany data provided by crunchbase