Design, build, and maintain Azure -based data pipelines using Synapse Analytics to support MSIS and
related education systems.
ï
- Develop and optimize ETL / ELT processes to ingest, transform, and validate K–12 education data from
multiple source systems.
ï
Implement and manage data models, views, and performance tuning in Azure SQL and Synapseenvironments.
ï
Monitor, troubleshoot, and resolve data pipeline and performance issues.ï
Document data flows, transformations, and technical standards.ï
Collaborate with analysts, reporting teams, and vendors to deliver timely, accurate data for federal andstate reporting
A minimum of 5 years of experience in the following :
ï
Advanced development and orchestration of data pipelines using Azure Data Factory / Synapse orsimilar cloud based platforms. (pipelines, triggers, integration runtimes, parameterization).
4. Scoring Method
Criteria Score Percentage Must equal 100%
Cost 30
Required Skills / Experience 25
Preferred Skills / Experience 10
Candidate Interview 35
ï
Data warehousing and analytics engineering using Azure Synapse Analytics or similar cloud basedplatforms (dedicated and serverless SQL pools).
ï
Strong T -SQL skills, including query optimization, indexing strategies, stored procedures, andperformance tuning.
ï
Implementation of ETL / ELT frameworks, including incremental loads, CDC patterns, and error handling.ï
Integration of structured and semi -structured data (CSV, JSON, XML) from APIs, SFTP, and vendorsystems.
ï
Source control and deployment practices using Azure DevOps, Git, and CI / CD pipelines.Experience with student information management systems and K -12 data and reporting
ï
Experience with Common Education Data Standards (CEDS)ï
Azure Data Engineer Associate certificationRequirements
Scoring Method
Criteria Score Percentage Must equal 100%
Cost 30
Required Skills / Experience 25
Preferred Skills / Experience 10
Candidate Interview 35