Python Snowflake Data Engineer at Kforce Inc.
Culver City, CA 90232
About the Job
- Python Snowflake Data Engineer will be partnering with Business Users and other IT teams to design and develop Data Pipelines
- Support the production pipelines - operations and enhancements to existing pipelines
- Doing impact analysis if any changes being requested upstream to the existing pipeline and data model
- Interpret the Business Requirements and convert them to technical requirements
- Provide design considerations for scalability and reliability of data streams being ingested
- Implementing ETL pipelines within and outside of a data warehouse using Python and Snowflake Snow SQL
- Keeping the SOPs updated all the time for any changes
- Data profiling of various data sources to understand the relationships across them
- Develop optimized pipeline design to achieve acceptable performance
- Recommend Data Quality Management methodologies for various projects
- As a Python Snowflake Data Engineer, you will assist in UAT phases of any new projects
- Follow agile development framework to work any new projects
- Follow Change Control management for any code deployment
Requirements:
- 5 to 6 years of extensive hand-on experience in building data pipelines using Python and Snowflake SQL procedural language
- 2 to 3 years of experience in Airflow/MWAA service for data pipeline orchestration and schedule management
- Deep knowledge and understanding of Snowflake Database Platform including features like external tables, clustering, various data ingestion techniques, Warehouse management, etc.
- Expertise and excellent proficiency with Snowflake internals and integration of Snowflake with other technologies for data processing and reporting
- Knowledge of Tableau is a plus
- Exceptional knowledge in writing complex SQLs and Procedure Language
- Python scripting languages - knowledge of various libraries to manage data extractions and transformations
- Amazon Web Services like AWS Glue, Lambda, Secret Manager, S3, VPC, Private Link, Step Functions
- Experience with Infrastructure as Code (IaC) tool like Terraform (preferred), AWS CloudFormation
- Should have used GitHub repository for code management
- Experience with any deployment tools like Jenkins
- Knowledge of Data Modelling techniques
- JIRA for project execution
- Strong interpersonal skills are required. Ability to work effectively with team members, clients, and other areas of the IT environment
- Strong written and oral communications
- Excellent problem-solving abilities, strong decision-making skills and make sound judgment decisions
- Work effectively with team members, clients, and other areas of IT
- Handle multiple tasks and be flexible in a fast-paced environment
- Deliver on time
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking “Apply Today” you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.