About the role

Role: Data Engineer

Per Scholas is seeking a Data Engineer to maintain and expand its enterprise data infrastructure. The role will ensure data from multiple sources is ingested, transformed, and prepared for reporting and visualization, with a focus on the 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 maintain continuous data flow
- Write and optimize SQL transformations in Snowflake to prepare reporting-ready datasets
- (Nice to have) Exposure to OpenFlow data ingestion
Snowflake data lake maintenance
- Maintain Snowflake structure (schemas, tables, views) in collaboration with InterWorks
- Run recurring data quality checks to keep the “source of truth” accurate
- Monitor warehouse performance and help manage Snowflake credit consumption
Reporting & visualization support
- Build and maintain Published Data Sources in Tableau for departmental use
- Support development of complex Tableau dashboards by providing backend data structures
- Translate business requests into technical requirements for new pipelines
Privacy & compliance
- Apply data masking and access control policies to meet data privacy requirements
- Support documentation for data lineage and the organizational data dictionary

Required Qualifications

Strong communication skills, including explaining technical requirements to non-technical stakeholders
Solid understanding of data modeling best practices
2–4 years of professional experience in data engineering or a highly technical data analyst role
Experience with CI/CD pipelines
Hands-on Snowflake experience (querying and managing tables)
Fivetran experience setting up and managing SaaS connectors
Experience writing and implementing transformations with dbt (Data Build Tool)
Tableau experience in data modeling (calculated fields, joins, performance optimization)
SQL expertise (mandatory)
Interest in Per Scholas’ mission of closing the opportunity gap

Nice-to-haves

Basic scripting experience with Python
Familiarity with OpenFlow data ingestion

Location & Reporting

Remote
Reports to the EVP, IT
Preferred hires reside in: AZ, CA, CO, FL, GA, IL, IN, KS, MD, MA, MI, MO, NC, NJ, NY, OH, PA, TX, WA

About Per Scholas

Per Scholas is a mission-driven technology training organization focused on improving mobility and opportunity by unlocking individuals’ potential. Over 30 years, it has built inclusive tech talent pipelines with employer partners, offering no-cost training in in-demand skills such as Cloud, Cybersecurity, Data Engineering, IT Support, and Software Engineering.

Tags