ETL Architect (Data Architect)

Job Title: ETL Architect (Data Architect)

Work Type: On-Site

Duration: 6+ months

Position Overview

The Department is seeking an experienced ETL Architect (Data Architect) to lead the design, development, and optimization of enterprise-scale data integration solutions within the Correction Information Management System (CIMS) Data Warehouse/Data Lake hosted on Microsoft Azure.

This role serves as the primary technical liaison for the project team and plays a critical role in enabling secure, reliable, and high-performance access to mission-critical data. The ETL Architect will leverage Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Power BI, and Azure Purview to transform complex datasets into actionable insights while ensuring data integrity, governance, and compliance.

General Experience Requirements

• Minimum 7 years of experience working with large, complex database management systems

• Minimum 7 years of experience in ETL development and data engineering

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related field

• Equivalent professional experience (year-for-year substitution) may be accepted, including experience with Service-Oriented Architecture (SOA) and Microsoft Azure Cloud solutions

Required Technical Skills & Experience

• 7+ years of hands-on experience in ETL development and data engineering

• 3+ years of experience with:

  • Azure Data Factory (ADF)

  • Azure Databricks

  • Azure Synapse Analytics

  • Azure Purview

  • Microsoft Azure Cloud

• Proven success designing and optimizing large-scale, high-availability ETL pipelines

• Strong expertise in Apache Spark using Python and/or Scala

• Advanced SQL proficiency and experience working with complex data structures

• Deep knowledge of data governance, security frameworks, and RBAC within Azure

• Ability to design resilient, efficient, and compliant ETL architectures aligned with regulatory requirements

Preferred Qualifications

• Microsoft certifications such as:

• Azure Data Engineer Associate

• Azure Solutions Architect Expert

• Azure Fundamentals

• Azure Databricks Data Engineer Associate Certification