The Role
Migrate Azure Data Factory pipelines to native Snowflake solutions using Snowpark, Python, Tasks, Streams, and SQL. Build and optimize scalable Bronze, Silver, and Gold data layers, transform data from multiple systems, and support enterprise data warehouse reporting and analytics. The role includes Snowflake warehouse performance and cost optimization, scheduled job development, secure implementation, REST API integration, and Agile/Scrum delivery.
Summary Generated by Built In
City: Burbank, CA
Onsite/ Hybrid/ Remote: Hybrid (4 days onsite per week, no flexibility)
Duration: 12 Months
Rate Range: Upto $96/hr on W2
Work Authorization: GC, USC, All valid EADs except OPT, CPT, H1B
Must Have:
- Snowflake
- Snowpark
- Python
- Advanced SQL
- Azure Data Factory
- ETL / ELT pipeline migration
- Snowflake Tasks and Streams
- Medallion Architecture (Bronze / Silver / Gold)
- REST API integration
- Agile / Scrum
Responsibilities:
- Migrate existing Azure Data Factory pipelines into native Snowflake solutions
- Analyze existing ADF pipeline logic and replicate workflows using Snowpark and Python
- Build native Snowflake pipelines using Snowpark libraries, Tasks, Streams, and SQL transformations
- Develop Python scripts and scheduled jobs directly inside Snowflake
- Optimize Snowflake warehouse sizing, compute usage, and job performance
- Support the transition from analytics-focused workflows into a scalable enterprise data warehouse platform
- Build and support Bronze, Silver, and Gold medallion data layers
- Join and transform data from multiple systems for reporting, KPIs, and analytics
- Work from clearly defined technical requirements and task assignments from engineering leadership
- Ensure secure, scalable, and performant Snowflake implementations
- Use AI-assisted development tools such as Cursor or Copilot to accelerate engineering delivery
Qualifications:
- 5+ years of hands-on Data Engineering experience
- Strong hands-on Snowflake experience in production environments
- Deep Snowpark experience including Snowpark libraries and native Snowflake processing
- Strong Python coding skills for data engineering and automation
- Advanced SQL experience including complex transformations and performance tuning
- Experience reviewing and translating Azure Data Factory pipeline logic into Snowflake-native solutions
- Experience with Snowflake warehouse optimization and cost management
- Experience building scheduled jobs, Tasks, and orchestration workflows inside Snowflake
- Experience with Medallion Architecture and enterprise data warehousing concepts
- Experience in Agile/Scrum delivery environments
- Ability to work independently in a task-oriented engineering role without ramp-up time
Nice to Have:
- Snowflake Cortex
- Cursor, Claude, or Microsoft Copilot experience
- AWS experience
- CI/CD pipelines for data engineering
- Snowflake Private Data Sharing
- Real-time or streaming data pipeline experience
Skills Required
- 5+ years of hands-on Data Engineering experience
- Strong hands-on Snowflake experience in production environments
- Deep Snowpark experience, including Snowpark libraries and native Snowflake processing
- Strong Python coding skills for data engineering and automation
- Advanced SQL experience, including complex transformations and performance tuning
- Experience reviewing and translating Azure Data Factory pipeline logic into Snowflake-native solutions
- Experience with Snowflake warehouse optimization and cost management
- Experience building scheduled jobs, Tasks, and orchestration workflows inside Snowflake
- Experience with Medallion Architecture and enterprise data warehousing concepts
- Experience in Agile/Scrum delivery environments
- Ability to work independently in a task-oriented engineering role without ramp-up time
- Snowflake Cortex experience
- Experience with Cursor, Claude, or Microsoft Copilot
- AWS experience
- CI/CD pipelines for data engineering
- Snowflake Private Data Sharing experience
- Real-time or streaming data pipeline experience
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Often, the biggest barrier between setting business objectives and achieving them is talent. Finding technically qualified people when you need them is hard enough. Finding technically qualified people who are the best fit for your organization is tougher. You need a staffing partner with the right expertise who can find the right talent in the right time frame, because your project can’t wait. That’s where we come in. aKube Inc is committed to leveraging its corporate values and operating model to achieve the highest level of performance and respect within the industry. We have developed a highly efficient delivery model for supporting a wide array of clients with expertise in supporting high-volume contingent worker programs.
