Data Engineer

Per Scholas is a mission-driven organization focused on unlocking the potential of individuals through tech training. The Data Engineer role involves maintaining and expanding the enterprise data infrastructure, managing data flow into a Snowflake Data Lake, and supporting data visualization efforts in Tableau.

Responsibilities

Set up and monitor automated data ingestion connectors using Fivetran

Troubleshoot sync errors and work with API providers to ensure continuous data flow

Write and optimize SQL transformations within Snowflake to prepare data for reporting

Maintain the structure of the Snowflake Data Lake (schemas, tables, and views) as defined in partnership with InterWorks

Perform regular data quality checks to ensure the 'source of truth' remains accurate

Monitor warehouse performance and assist in managing Snowflake credit consumption

Build and maintain 'Published Data Sources' in Tableau for use by various departments

Assist team members in building complex Tableau dashboards by providing the necessary back-end data structures

Translate business requests into technical requirements for new data pipelines

Execute data masking and access control policies to ensure compliance with Data Privacy frameworks

Assist in maintaining documentation for data lineage and the organizational data dictionary

Preferred

Familiarity or experience with OpenFlow data ingestion

Experience with Python for basic scripting

OpenFlow data ingestion

Python scripting

Benefits

Over 40 days of paid time off each year through a mix of holidays, vacation, and sick/personal time

Holiday pay upon hire (a total of 22 holidays annually, including a week off for Independence day and a week before the New Year )

Full-Time Benefits Eligible employees also receive 80 Wellness Hours to use for Sick, Safe, or Personal reasons

Accrue Vacation at a rate of 8 hours at the beginning of every month, supporting rest, recharge, and work-life balance

Vacation accruals increase with tenure

Part-time employees are afforded time off on a prorated basis and in accordance with local requirements

Benefit eligible employees can choose from multiple medical plans through Cigna or Kaiser Permanente (where available), with options to fit your needs

Eligible employees also have access to a Health Reimbursement Account (HRA) that reimburses eligible out-of-pocket expenses, up to $4,000 for individuals and $8,000 for families

Eligible employees can select from two dental plan options and a vision plan

Employees who waive medical coverage receive employer paid dental and vision premiums

401(k) plan with a current 100% employer match on contributions up to 6%, eligible employees are offered entry and full vesting after 90 days with the company

Free, confidential, 24/7 access to counseling, legal support, and financial resources for employees and their household members

Eligible employees are offered up to 6 weeks of 100% paid parental leave to support employees as they welcome a new child and bond with their family

Eligible employees have access to employer-paid life and AD&D Insurance, as well as employer-paid short-term disability coverage, with the option to elect additional life coverage and long-term disability insurance

Flexible Spending accounts are available for healthcare, dependent care, and commuting expenses

Per Scholas also offers a range of voluntary benefits, including: Accident, Critical Illness, Hospital Indemnity, Legal Services, and Pet Insurance

Additional resources include healthcare concierge support, financial wellness tools, and employee discount programs

Company

Tuition-free IT and tech career training

Bronx, New York, USA

https://www.perscholas.org/

Founded in 1995

501-1000 employees

Qualifications

Excellent communication skills, able to communicate technical requirements to non technical audiences

A clear understanding of data modeling and best practices

2–4 years of professional experience in data engineering or a highly technical data analyst role

Experience with CI/CD pipelines

Snowflake: Hands-on experience querying and managing tables within a Snowflake environment

Fivetran: Proficiency in setting up and managing SaaS connectors

Experience writing and implementing data transformations with dbt (Data Build Tool)

Tableau: Experience in data modeling for Tableau (calculating fields, joining data sets, and optimizing for performance)

Technical Skills: Strong SQL skills are mandatory

Mission-Driven: A genuine interest in using technology to support Per Scholas' mission of closing the opportunity gap

Familiarity or experience with OpenFlow data ingestion

Experience with Python for basic scripting

2–4 years of professional experience in data engineering or a highly technical data analyst role.

Required skills

Snowflake, Fivetran, SQL, dbt (Data Build Tool), Tableau, Python, CI/CD pipelines, Data modeling, Data privacy frameworks

Preferred skills

Familiarity or experience with OpenFlow data ingestion, Experience with Python for basic scripting

Experience

2+ years