We believe the world is changing faster than ever

Join a Two Sigma Ventures portfolio company to help shape the future of technology.
65
companies
524
Jobs
Leverage our network to build your career.
Tell us about your professional DNA to get discovered by any company in our network with opportunities relevant to your career goals.

Snowflake ETL Developer

Kickboard

Kickboard

Software Engineering
United States · Remote
Posted on Wednesday, February 21, 2024

Snowflake ETL Developer

Job Locations US-US-Remote
ID 2024-7322
Category
Professional Services
Type
Full Time

Overview

This is a Customer-facing project implementation role. Candidate must have required skills and experience for defining and performing complex integration development work, in addition to strong communication and organizational leadership skills to act as the overall Tech Lead for assigned projects.

Responsibilities

  • Implement ETL processes that populate star schemas using a variety of source data on data warehouse implementations supporting a product
  • Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process
  • Design and develop Snowflake processes to extract, load data
  • Participates in the requirements gathering process and assist with designing the business process dimensional models
  • Work with data providers to fill data gaps and/or to adjust source-system data structures to facilitate analysis and integration with other company data
  • Perform data profiling and source to target mappings
  • Perform analysis on source data to determine the feasibility of using this data to solve business needs
  • Write scripts for automated testing of data in the target facts and dimensions
  • Capture audit information during all phases of the ETL process
  • Write and maintain documentation of the ETL processes via process flow diagrams
  • Act as the customer-facing technical lead for assigned projects. Provide technical solution expertise and guidance for assigned projects and customers, and lead and coordinate the delivery of technical integrations, customizations, data validation, and system QA together with other assigned team members.

Qualifications

  • Bachelor’s Degree in Computer Science or STEM majors, or 7+ years of equivalent work experience
  • Excellent verbal and written communication skills
  • Experience with relational database design/modeling
  • Experience interfacing with business users and gathering and understanding their requirements
  • SQL coding/querying skills in SQL Server and/or MySQL, Oracle, Postgres, and Snowflake
  • Experience in an Agile environment

Compensation & Benefits

PowerSchool offers the following benefits:

  • Comprehensive Insurance Coverage (including Medical, Dental, Vision, Pharmacy benefits, Life Insurance and AD&D)
  • Flexible Spending Accounts and Health Savings Accounts
  • Short-Term Disability and Long-Term Disability
  • Comprehensive 401(k) plan
  • Generous Parental Leave
  • Unrestricted paid time off (known as Discretionary Time Off - DTO)
  • Paid Community and Volunteer Time Off (VTO)
  • Wellness Program, including ClassPass & Employee Assistance Program
  • Tuition Reimbursement
  • Optional Benefits: Pet Insurance, Identity Theft Protection, Student Debt Repayment Program and Prepaid Legal coverage

A reasonable estimate of the base compensation range for this position is $78,000-140,000. The compensation range is specific to the United States and incorporates many factors including but not limited to an applicant’s skills and prior relevant experience and training; licensures, degrees, and certifications; internal equity; internal pay ranges; and market data/range parameters.

EEO Commitment

PowerSchool is committed to a diverse and inclusive workplace. PowerSchool is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. Our inclusive culture empowers PowerSchoolers to deliver the best results for our customers. We not only celebrate the diversity of our workforce, we celebrate the diverse ways we work. If you have a disability and need an accommodation regarding our recruiting process, please let us know by emailing accommodations@powerschool.com.

#LI-SM1 #LI-REMOTE

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with us for general consideration.
Application FAQs

Software Powered by iCIMS
www.icims.com