Data Engineer

Posted 2ds ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Data Engineer building secure Snowflake data architecture and pipelines for Blood Cancer United. Enabling enterprise analytics and business intelligence to improve blood cancer patient outcomes.

Responsibilities:

  • Design, build, and maintain scalable and secure data architecture in Snowflake
  • Develop and optimize Snowflake objects, including tables, dynamic tables, views, and warehouses
  • Manage Snowflake security and access
  • Partner with the Integration team on ETL pipelines in and out of the data warehouse using Snowflake-native tools, Informatica, and MuleSoft
  • Build and manage deployment of Snowflake changes across environments, including production, using GitHub
  • Ensure data quality, integrity, and lineage across pipelines
  • Write and optimize query performance and warehouse usage
  • Monitor Snowflake compute costs
  • Develop scripts for moving data and ETL/ELT between AWS and Snowflake
  • Work with AWS, S3, Azure, GCP, and blob storage
  • Support the production Enterprise Data Warehouse environment, including ingestion and transformation issues
  • Perform unit testing and clearly document builds
  • Partner with data analysts, governance, and Business Intelligence teams to enable analytics
  • Support the Data Architect and Business Intelligence teams with optimized data models
  • Translate business requirements into scalable data solutions
  • Maintain working knowledge of the organization’s mission and programs
  • Perform other related duties as assigned

Requirements:

  • Bachelor’s degree in Computer Science, Information Systems, or related field
  • 5+ years of designing and implementing a fully operational production-grade large-scale data solution
  • Hands-on experience with Snowflake Data Cloud
  • Understanding of enterprise data management concepts, including governance, engineering, science, lake, warehouse, sharing, and applications
  • Experience using GitHub for deployments
  • Strong SQL skills
  • Experience with cloud platforms such as AWS, Azure, or GCP
  • Knowledge of data modeling techniques, including Kimball and Data Vault
  • Excellent written and verbal presentation and communication skills
  • Ability to problem solve in an environment with unclear requirements
  • Weekend and evening work may be required

Benefits:

  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Life insurance
  • Flexible spending accounts
  • 403b retirement plan
  • Generous paid time off
  • Federal paid holidays
  • Wellness program
  • Employee assistance program
  • Annual incentive plan
  • Competitive benefits package
  • Reasonable accommodations for individuals with disabilities