Fast Facts
Per Scholas is looking for a Data Engineer to maintain and enhance their data infrastructure, focusing on managing data flow into a Snowflake Data Lake and ensuring accurate data ingestion and visualization in Tableau.
Responsibilities: Key responsibilities include managing data pipelines, maintaining Snowflake Data Lake structure, supporting reporting and visualization in Tableau, and ensuring privacy and compliance.
Skills: Required skills include strong SQL proficiency, experience with Snowflake, Fivetran, Tableau, and CI/CD pipelines, along with excellent communication skills and a mission-driven attitude.
Qualifications: 2-4 years of professional experience in data engineering or a technical data analyst role, knowledge of data modeling, and familiarity with Python for light scripting are preferred.
Location: Remote position in the United States
Compensation: $129000 - $139000 / Annually
Position Title: Data Engineer
Location: Remote
Reports To: EVP, IT
Position Summary
Per Scholas is seeking a Data Engineer to maintain and expand our enterprise data infrastructure. This role focuses on the technical execution of our data strategy, specifically managing the flow of data into our newly established Snowflake Data Lake. You will be the "bridge" that ensures data from various sources is accurately ingested, transformed, and ready for visualization in Tableau.
Core Responsibilities
1. Data Pipeline Management
- 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.
- Familiarity or experience with OpenFlow data ingestion is nice-to-have
2. Data Lake Maintenance
- 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.
3. Reporting & Visualization Support
- 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.
4. Privacy & Compliance
- 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.
Required 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. 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.
LI#- Remote
For this position, our target salary is $139,000, with a range of $129,000 to $139,000. The variation in compensation typically hinges on factors such as the candidate's geographic location and their qualifications and experience that align with the role.
