Azure ETL Architect – Data Modernization
About The Position
Cyberlocke is seeking an experienced Azure ETL Architect to design and lead enterprise data integration, migration, and transformation solutions using Microsoft Azure and Microsoft Fabric. This role is responsible for defining the architecture, standards, patterns, and technical direction for extracting data from source systems, transforming it into trusted and governed information, and loading it into modern cloud-based data platforms. The Azure ETL Architect will lead the design of scalable pipelines supporting data lakes, lakehouses, warehouses, analytics platforms, artificial intelligence solutions, and operational integrations. The successful candidate will work closely with enterprise architects, data engineers, business analysts, data governance teams, application owners, security professionals, and customer stakeholders. This position requires deep experience with Microsoft Fabric, Azure Data Factory, SQL, data modeling, cloud architecture, and large-scale data migration.
Requirements
- Bachelor’s degree in computer science, information systems, engineering, data architecture, or a related discipline, or equivalent professional experience.
- Seven or more years of experience in ETL, ELT, data integration, data engineering, or data warehouse development.
- Three or more years of experience designing data solutions on Microsoft Azure.
- Demonstrated experience architecting enterprise data pipelines and migration solutions.
- Strong experience with Azure Data Factory, including pipelines, activities, datasets, linked services, triggers, parameters, and integration runtimes.
- Experience with Microsoft Fabric or comparable cloud lakehouse and analytics platforms.
- Advanced SQL and data-transformation skills.
- Experience with Python, PySpark, or another data-processing language.
- Experience designing data lake, lakehouse, data warehouse, and Medallion architectures.
- Strong understanding of relational, dimensional, and analytical data modeling.
- Experience integrating cloud, on-premises, SaaS, database, API, file, and legacy data sources.
- Experience with full, incremental, and change-data-capture loading patterns.
- Experience developing source-to-target mappings and transformation specifications.
- Experience with data-quality validation, reconciliation, metadata, lineage, and auditing.
- Understanding of Azure security, identity, networking, and secrets-management principles.
- Experience with Azure DevOps, Git, CI/CD, and automated deployment practices.
- Strong architecture documentation, communication, presentation, and stakeholder-management skills.
Nice To Haves
- Deep experience with Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Factory, notebooks, shortcuts, dataflows, and deployment pipelines.
- Experience with Delta Lake, Delta tables, Spark, and distributed data processing.
- Experience with Microsoft Purview and enterprise data-governance programs.
- Experience integrating Microsoft Fabric with Power BI, Azure Machine Learning, Azure AI Foundry, or other artificial intelligence platforms.
- Experience with Microsoft SQL Server, Azure SQL Database, Azure Synapse Analytics, Oracle, SAP HANA, SAP ECC, Snowflake, Databricks, or comparable platforms.
- Experience with enterprise resource planning, student information systems, financial systems, human resources systems, customer relationship management platforms, or electronic health record systems.
- Experience designing API-led, message-based, event-driven, or streaming integrations.
- Familiarity with Azure Functions, Logic Apps, Event Hubs, Service Bus, Kafka, or comparable technologies.
- Experience with infrastructure as code using Bicep, ARM templates, Terraform, PowerShell, or Azure CLI.
- Experience leading data modernization programs in education, healthcare, government, financial services, manufacturing, or other regulated industries.
- Experience estimating enterprise data engineering projects and developing statements of work.
- Experience working in consulting, professional services, or customer-facing architecture roles.
- Microsoft Certified: Fabric Data Engineer Associate
- Microsoft Certified: Azure Solutions Architect Expert
- Microsoft Certified: Azure Data Engineer Associate
- Microsoft Certified: Azure Developer Associate
- Microsoft Certified: DevOps Engineer Expert
- Microsoft Certified: Power BI Data Analyst Associate
- Microsoft Certified: Azure Fundamentals
- TOGAF certification or another recognized enterprise architecture credential
Responsibilities
- ETL and Data Integration Architecture
- Microsoft Fabric and Azure Architecture
- Data Migration Architecture
- Data Transformation and Processing
- Data Modeling and Analytical Enablement
- Governance, Security, and Compliance
- Performance, Scalability, and Reliability
- Monitoring and Operational Architecture
- DevOps and Automation
- Technical Leadership and Governance
- Stakeholder and Customer Engagement
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
