Exadel's client, a U.S.-based education services provider, needs to design, implement, and maintain scalable data pipelines and build dimensional data models to ensure high-quality data for analytics and reporting
Requirements
- Hands-on experience with Snowflake, Coalesce.io, Airbyte, SQL Server/SSIS, and Azure Data Factory
- Strong understanding of Medallion architecture and dimensional data modeling
- Practical experience in building ETL pipelines and transforming data for analytics
- Familiarity with Jira and GitHub for collaborative work
- Strong analytical and problem-solving skills, with ability to collaborate across teams
- Exposure to Power BI (optional)
- Experience with Salesforce data integration
Responsibilities
- Design, implement, and maintain scalable data pipelines using Snowflake, Coalesce.io, Airbyte, and SQL Server/SSIS, with some use of Azure Data Factory
- Build and maintain dimensional data models to ensure high-quality, structured data for analytics and reporting
- Implement Medallion architecture in Snowflake, managing bronze, silver, and gold layers
- Collaborate with teams using Jira for task tracking and GitHub for code repository management
- Ensure reliable ETL processes, data transformations, and data integration workflows
- Help improve data modeling practices and address weaknesses in dimensional modeling
Other
- Minimum 4-hour overlap with US Eastern Time
- Intermediate/Upper-Intermediate English level
- Reasonable accommodations are available to enable individuals with disabilities to perform essential functions
- Background in higher education / ed-tech domains (nice to have)
- Equal Opportunity Employer committed to inclusion across minority, gender identity, sexual orientation, disability, age, and more
