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.
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
aKube Inc Los Angeles, California, USA Office
Los Angeles, California, United States
Similar Jobs
.png){kind=logo}
AdTech • eCommerce • Information Technology • Software • Travel • Generative AI
Lead design and delivery of security platforms, embedded SDLC controls, cloud and service-mesh security, and AI/LLM protections. Build and operate AWS-native security programs (CSPM/DSPM), integrate security into CI/CD and developer workflows, and partner with engineering teams to operationalize zero-trust, detection, and automated remediation at enterprise scale.
Top Skills:
Agentic AiAspmAWSCertificate LifecycleCi/CdContainerized MicroservicesControl TowerCspmDastDspmEnvoyGdprGuarddutyIamInfrastructure-As-CodeInspectorIso 27001IstioKmsLinkerdLlmMacieMtlsNistOwaspPci-DssRagSastScaSecrets ManagementSecrets ManagerSecurity HubService MeshSoc 2VpcWorkload Identity
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Lead technical direction and architecture for Neighborhoods mobile across Cash App and Square. Drive cross-organizational integration, remain hands-on in iOS development (SwiftUI, Workflow), apply AI-native engineering practices, mentor engineers, and collaborate with backend, web, Android, product, and design partners to deliver reliable, scalable mobile experiences.
Top Skills:
BazelClaude CodeCombineCursorGooseObjective-CProtocol BuffersSwiftSwift ConcurrencySwiftuiUikitWorkflow
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Field-driven territory sales role responsible for generating and closing pipeline through in-person outreach and demos. Build local partnerships, master verticals (restaurants, retail, services), manage Salesforce pipeline, exceed quota, and ensure fast onboarding and customer referrals.
Top Skills:
AfterpayPayment ProcessingSalesforceSquare
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
