[Remote] Data Engineer

Note: The job is a remote job and is open to candidates in USA. 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

Skills

• 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. Experience with Python for basic scripting is preferred
• 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 is nice-to-have

Benefits

• Full-TimePer Scholas team members enjoy over 40 days of paid time off each year through a mix of holidays, vacation, and sick/personal time!
• All employees are eligible for 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 and 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 Overview