Overview
Remote
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
No Travel Required
Unable to Provide Sponsorship
Skills
Warehouse
Snow Flake Schema
Workflow
Risk Management
SQL Tuning
ELT
Data Warehouse
Amazon Web Services
Extract, Transform, Load
Generative Artificial Intelligence (AI)
Microsoft Power BI
Project Management
Oracle Exadata
Acceptance Testing
Amazon S3
Apache Velocity
CA Workload Automation AE
Communication
DMS
Dashboard
Data Validation
Database Design
Development Testing
IBM Cognos Analytics
IT Management
Informatica
Management
Migration
Optimization
Performance Analysis
Performance Tuning
Project Scoping
RBAC
Reverse Engineering
Sprint
Streaming
UPS
Job Details
Job Description:
The requirement is for a Technical Lead with strong expertise in Snowflake and ETL, along with project management experience.
Lead end-to-end migration of 6 Enterprise Data Warehouses from Oracle Exadata to Snowflake on AWS. Manage project scope, timeline, risk mitigation, and stakeholder communication across business units and leadership
- 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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.