About the role

Role Overview

Data Engineer (Remote) Maintain and expand Per Scholas’ enterprise data infrastructure, ensuring data is ingested, transformed, and ready for Tableau reporting. Manage the data flow into a newly established Snowflake Data Lake.

Responsibilities

Data Pipeline Management
- Set up and monitor automated ingestion connectors using Fivetran
- Troubleshoot sync errors and coordinate with API providers to keep data flowing
- Write and optimize SQL transformations in Snowflake for reporting-ready datasets
- (Nice-to-have) Familiarity with OpenFlow ingestion
Data Lake Maintenance
- Maintain Snowflake Data Lake structure (schemas, tables, views) defined with InterWorks
- Run regular data quality checks to protect the accuracy of the “source of truth”
- Monitor warehouse performance and help manage Snowflake credit consumption
Reporting & Visualization Support
- Build and maintain Published Data Sources for departments in Tableau
- Support teams creating complex Tableau dashboards by providing back-end data structures
- Translate business requests into technical requirements for new pipelines
Privacy & Compliance
- Implement data masking and access control policies for data privacy compliance
- Help maintain documentation for data lineage and the organizational data dictionary

Requirements

Strong communication skills; can communicate technical needs to non-technical audiences
Solid understanding of data modeling and best practices
2–4 years of professional experience in data engineering or highly technical data analytics
Experience with CI/CD pipelines
Snowflake hands-on experience (querying and managing tables)
Fivetran proficiency setting up/managing SaaS connectors
Experience writing and implementing transformations with dbt (Data Build Tool)
Tableau data modeling experience (calculated fields, joins, performance optimization)
Strong SQL skills (mandatory)
Python for basic scripting (preferred)

Nice-to-have

Experience with OpenFlow data ingestion

Compensation

Target salary $139,000 (range $129,000–$139,000), depending on geographic location and qualifications.

About Per Scholas

Per Scholas is a mission-driven organization focused on driving mobility and opportunity through rigorous, no-cost tech training. With remote training and campuses across the U.S., it partners with employers to build inclusive tech talent pipelines across fields like Data Engineering and Cloud.

Tags