Senior Snowflake Data Engineer

Kforce - Cincinnati, OH

Full-time - Senior

Cincinnati, OH

Administrative and Support Services

About the position

A client with Kforce is seeking a Senior Snowflake Data Engineer to join their team in Cincinnati, OH. This position is responsible for providing high-level consulting services to clients, focusing on the design, planning, and supervision of the implementation of complex, large-scale system projects. The Senior Snowflake Data Engineer will review, analyze, and modify programming systems, which includes encoding, testing, debugging, and installing for a complex, large-scale computer system. This role also involves assisting in supervising the daily activities of project team members, ensuring that projects are delivered on time and meet client expectations. In addition to technical responsibilities, the Senior Snowflake Data Engineer will maintain current knowledge of industry issues and opportunities, as well as best practices for specific areas of expertise. Leveraging industry knowledge, technology, process, and organizational design expertise, the engineer will deliver results for clients with the goal of improving profitability. This position requires a strong understanding of data analytics, business intelligence, and financial services best practices, as well as the ability to communicate effectively with clients and team members.

Responsibilities

• Design, plan, and supervise implementation of complex, large-scale system projects.
• Review, analyze, and modify programming systems including encoding, testing, debugging, and installing for a complex, large-scale computer system.
• Assist in supervising the daily activities of project team members.
• Maintain current knowledge of industry issues and opportunities as well as best practices for specific areas of expertise.
• Leverage industry knowledge, technology, process, and organizational design expertise to deliver results for clients.

Requirements

• Bachelor's degree (or equivalent/above) in Computer Science, Information Technology.
• Very strong on SQL; Must have 5-7+ years of experience working with SQL on large scale datasets.
• Must have at least 5+ years of experience in Cloud based Data Engineering with design, implementation and operationalization of large-scale data and analytics solutions on AWS.
• Must have at least 4+ years of experience in Snowflake architecture, design, implementation, and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.
• At least 4 years of production grade coding experience; Experience with PySpark/Hadoop and/or AWS Glue ETL and/or Databricks with python is preferred.
• Must have 1+ years of experience in deploying IAC code via Terraform.
• Must be proficient with Python programming language.
• Must have experience on ETL development life cycle, best practices of ETL pipelines, thorough work experience on data warehouse using combination of Python, Snowflake & AWS Services.
• Expert in one or more of the following areas: data analytics, business intelligence, sales and service, business productivity improvement, revenue enhancement, technology optimization, organizational design, marketing excellence, financial service payments, financial service channel optimization or strategic planning.
• Good understanding of industry, associated business challenges and opportunities for particular area of expertise.
• Excellent communication skills, including both verbal and written.
• Demonstrated research, writing and analytical skills.
• Good problem-solving skills.
• Ability to work under pressure.

Nice-to-haves

• Experience with Astronomer and Airflow.
• Experience with Terraform.

Benefits

• Medical, dental, and vision insurance
• Health Savings Account (HSA)
• Flexible Spending Account (FSA)
• 401(k) plan
• Life insurance
• Disability insurance
• Accidental Death and Dismemberment (ADD) insurance
• Paid time off for salaried personnel
• Paid sick leave for hourly employees on Service Contract Act projects