Our major software client is seeking a Snowflake Software Developer for a 12 month freelance role offering 40 hours/week. This role is hybrid, requiring 3 days/week onsite in San Francisco. For consideration, candidates must include both a resume + portfolio with password when applying.
Summary: This job posting is specific for a "Snowflake Developer" with Snowflake experience. The prospective individual needs to have a good understanding of Data warehousing concepts and some SQL knowledge.
Responsibilities
-Strong SQL Experience, Can build Complex Cde and Procdures
- Building scalable, available, reliable data pipelines with Snowflake.
- Worked on SQL , Procedures, Strong PLSQL Handson experience
-Worked on new capabilities of Snowflake
-Worked on SnowPipe, Snowpark, Streamlit, Dynamic Tables
-Should have a product-focused mindset to understand business requirements and architect systems that will scale and extend to accommodate those needs
-Build and scale data infrastructure that powers batch and real-time data processing of millions of records
- Interface with business teams, CRM, data scientists, product managers and all data stakeholders to understand their needs and promote best practices
-Strong SQL Database hands on experience
- Develop high-level designs and implement high scalable web and cloud solutions
- Collaborate with architects, product designers, product managers, engineers to implement high-quality solutions
-Proactively and continuously evaluate and address issues related to performance, stability, scalability, and extensibility of the systems
- Research and prototype new ideas, technologies and patterns relating to the task
-Take full ownership of the initiative and deliver it end to end solution
Minimum Qualifications
- Bachelor's Degree in Computer Science, Information Systems or other equivalent experience in software development/IT
- 3+ years of experience Snowflake SQL Writing SQL queries against Snowflake Developing scripts Unix, Python, etc. to do Extract, Load, and Transform data
- 5+ years of experience Maintain/ develop the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS technologies
- Hands on experience of building Analytical pipelines using DBT
- Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
- In-depth understanding of Data Warehouse/ODS, ETL concept and modelling structure principles
- Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modelling.
- Good working knowledge of any ETL or ELT tool (Matillion or Informatica or SSIS)
- Ability to effectively function in a cross team's environment, Experience in gathering and analysing system requirements
- 3+ years experience in developing full-stack, web technology solutions utilizing: JavaScript, NODE JS, REST APIs, Amazon Web Services, microservices, serverless design/technologies
-Hands-on experience with Relational database technologies like MySQL, , etc. is highly preferred
- Should have a very strong foundation in JavaScript, and must have a clear understanding of basic web fundamentals such as prototype-based inheritance, scopes, Event Loop, Memory Management in JS, etc
- Familiarity with the software development process, including specification, quality assurance, and documentation
-Advanced interpersonal skills to effectively promote ideas, collaborate across teams and influence stakeholders to reach decisions
- Detail-oriented with respect to software development process, communication and documentation
- Capable of performing requirements gathering, analysis and documentation
- Excellent verbal and written communication skills, with the ability to communicate with stakeholders at various levels
In this position, you may have access to client or customer systems, confidential and/or proprietary information or data. This position is onsite and requires you to work closely with other individuals in a collaborative team environment.
Benefits
Creative Circle's Freelance Employee benefits package includes eligibility for Minimum Essential Coverage (MEC) medical plan, dental/vision/term life package, discount prescription program, critical illness, accident, tele-behavioral health, and 401(k) plan. Sick leave is provided to Candidates whose assignment work location is in a state or city subject to sick leave laws. A Minimum Value (MV) PPO medical plan, Employee Stock Purchase Plan, and paid holiday eligibility are based on length and dates of service.Looking forward to receiving your resume through our website and going over the position with you. Clicking apply is the best way to apply, but you may also:
Email your resume in Word to:
ashley.sella@jobalert.creativecircle.com
**Please do NOT change the email subject line in any way. You must keep the JobID: : AS30-1831030 -- in the email subject line for your application to be considered.***
Ashley Sella - Senior Recruiter, National Delivery
For this position, you must be currently authorized to work in the United States without the need for sponsorship for a non-immigrant visa.
Creative Circle will consider for Employment in the City of Los Angeles qualified Applicants with Criminal Histories in a manner consistent with the requirements of the Los Angeles Fair Chance Initiative for Hiring (Ban the Box) Ordinance.
This job was first posted by Creative Circle on 11/22/2024 and applications will be accepted on an ongoing basis until the position is filled or closed.
Creative Circle is an Equal Opportunity Employer
All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity or expression, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, or any other characteristic protected by law. Creative Circle will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable state and local law, including but not limited to the Los Angeles County Fair Chance Ordinance, the San Francisco Fair Chance Ordinance, and the California Fair Chance Act. If you need a reasonable accommodation in the application process, please contact your Recruiter (the person you'll be interviewing with) or a member of our Human Resources team to make arrangements. United Healthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Creative Circle.
Copyright 1999 - 2024. CreativeCircle, Inc. All rights reserved.