The Criminal Justice Coordinating Council (CJCC) is seeking a skilled ETL Programmer with hands-on experience in Azure Data Factory (ADF)to design develop and maintain robust data pipelines and integration solutions.
Local Candidates Only - Onsite visits to the office will be required 1-2 times per month. Key Responsibilities - Design and implement ETL processes using Azure Data FactoryData Flows and Mapping Data Flows.
- Integrate data from various sources including SQL Server Blob Storage APIs and third-party systems.
- Develop and maintain data pipelines and data ware houses in Azure.
- Monitor and troubleshoot ETL jobs to ensure data quality and performance.
- Collaborate with analysts and business stakeholders to understand data requirements.
- Implement data governance security and compliance best practices.
- Automate data workflows and optimize performance for large-scale data processing.
Required/Desired Skills
| Skill | Required /Desired | Amount | of Experience |
|---|
| Bachelor s degree in Computer Science Information Systems or related field. | Required | 0 | |
| 3 years of experience in ETL development with at least 1 year using Azure Data Factory. | Required | 3 | Years |
| Proficiency in SQL Azure Synapse Azure Data Lake and Azure Functions (minimum of 5 years experience). | Required | 5 | Years |
| Experience with CI/CD pipelines Git and DevOps practices (minimum of 5 years experience). | Required | 5 | Years |
| Strong understanding of data modeling data warehousing and cloud architecture (minimum of 5 years experience). | Required | 5 | Years |
| Microsoft Azure certifications (e.g. DP-203 AZ-900). | Required | 0 | |
| Experience with Power BI Databricks or Python for data transformation. | Required | 5 | Years |
| Familiarity with Agile methodologies and tools like JIRA or Azure Boards (minimum of 5 years experience). | Required | 4 | Years |
Questions
| No. | Question |
|---|
| Question1 | Absences greater than two weeks MUST be approved by CAI management in advance and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement |
| Question2 | What is your candidates email address |
| Question3 | If selected for engagement your candidates hourly Pay Rate must be at least -. Your candidate can be paid more; however the hourly SRP Rate cannot exceed -. Do you agree to these requirements |
| Question4 | The maximum mark-up for this engagement s SRP rate is 35%. To be competitive on pricing a mark-up below the 35% threshold is suggested. Do you agree to propose a mark-up at or below 35% |
| Question5 | This assignment is contingent upon customer renewal and availability of adequate funding. Do you agree to this requirement |
| Question6 | If selected for engagement your candidate will be expected to start no later than 2 weeks (10 business days) after the clients selection date Do you agree to this requirement |
The Criminal Justice Coordinating Council (CJCC) is seeking a skilled ETL Programmer with hands-on experience in Azure Data Factory (ADF)to design develop and maintain robust data pipelines and integration solutions.Local Candidates Only - Onsite visits to the office will be required 1-2 times per ...
The Criminal Justice Coordinating Council (CJCC) is seeking a skilled ETL Programmer with hands-on experience in Azure Data Factory (ADF)to design develop and maintain robust data pipelines and integration solutions.
Local Candidates Only - Onsite visits to the office will be required 1-2 times per month. Key Responsibilities - Design and implement ETL processes using Azure Data FactoryData Flows and Mapping Data Flows.
- Integrate data from various sources including SQL Server Blob Storage APIs and third-party systems.
- Develop and maintain data pipelines and data ware houses in Azure.
- Monitor and troubleshoot ETL jobs to ensure data quality and performance.
- Collaborate with analysts and business stakeholders to understand data requirements.
- Implement data governance security and compliance best practices.
- Automate data workflows and optimize performance for large-scale data processing.
Required/Desired Skills
| Skill | Required /Desired | Amount | of Experience |
|---|
| Bachelor s degree in Computer Science Information Systems or related field. | Required | 0 | |
| 3 years of experience in ETL development with at least 1 year using Azure Data Factory. | Required | 3 | Years |
| Proficiency in SQL Azure Synapse Azure Data Lake and Azure Functions (minimum of 5 years experience). | Required | 5 | Years |
| Experience with CI/CD pipelines Git and DevOps practices (minimum of 5 years experience). | Required | 5 | Years |
| Strong understanding of data modeling data warehousing and cloud architecture (minimum of 5 years experience). | Required | 5 | Years |
| Microsoft Azure certifications (e.g. DP-203 AZ-900). | Required | 0 | |
| Experience with Power BI Databricks or Python for data transformation. | Required | 5 | Years |
| Familiarity with Agile methodologies and tools like JIRA or Azure Boards (minimum of 5 years experience). | Required | 4 | Years |
Questions
| No. | Question |
|---|
| Question1 | Absences greater than two weeks MUST be approved by CAI management in advance and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement |
| Question2 | What is your candidates email address |
| Question3 | If selected for engagement your candidates hourly Pay Rate must be at least -. Your candidate can be paid more; however the hourly SRP Rate cannot exceed -. Do you agree to these requirements |
| Question4 | The maximum mark-up for this engagement s SRP rate is 35%. To be competitive on pricing a mark-up below the 35% threshold is suggested. Do you agree to propose a mark-up at or below 35% |
| Question5 | This assignment is contingent upon customer renewal and availability of adequate funding. Do you agree to this requirement |
| Question6 | If selected for engagement your candidate will be expected to start no later than 2 weeks (10 business days) after the clients selection date Do you agree to this requirement |
View more
View less