Azure Data Architect / Subject Matter Expert (SME) – ETL & Data Integration

We are looking for highly experienced Azure Data Architects and Subject Matter Experts (SMEs) with strong expertise in designing and implementing complex ETL/ELT solutions using Azure Data Factory (ADF). The ideal candidate should have deep experience in the data transformation layer of ETL processes, particularly integrating data between Microsoft Power Platform Dataverse databases and Oracle databases. The role requires hands-on experience in designing scalable data pipelines, handling multiple file formats, and ensuring secure and efficient data movement across enterprise systems. Key Responsibilities: • Design and architect end-to-end data integration solutions using Azure Data Factory (ADF). • Lead the development of complex ETL/ELT transformation workflows, including data cleansing, validation, enrichment, and mapping. • Design and optimize data pipelines to move data between Power Platform Dataverse, Oracle databases, and other enterprise data sources. • Develop solutions for processing and transforming multiple file formats including password-protected ZIP files, Excel (.xls), CSV, and other structured data sources. • Define data architecture standards, best practices, and governance frameworks. • Ensure scalability, performance optimization, security, and reliability of data integration solutions. • Work closely with business stakeholders, application teams, and technical teams to understand data requirements and deliver appropriate solutions. • Provide technical leadership, mentoring, and guidance to development teams. • Perform root cause analysis and troubleshoot complex data integration and transformation issues. • Support deployment strategies, documentation, and knowledge transfer activities. Required Skills & Experience: • 8+ years of overall experience in Data Engineering, Data Architecture, or Enterprise Data Integration. • Strong hands-on experience with Azure Data Factory (ADF), including pipeline development, mapping data flows, and orchestration. • Deep understanding of the transformation component of ETL/ELT processes. • Proven experience integrating Microsoft Power Platform Dataverse with Oracle databases. • Strong knowledge of data mapping, data modelling, data quality, and transformation techniques. • Experience handling various input data formats including ZIP (password-protected), XLS, CSV, XML, and JSON files. • Expertise in SQL and working with relational databases, especially Oracle. • Experience with Azure services related to data engineering and integration. • Knowledge of security, access controls, encryption, and secure data handling practices. Preferred Skills: • Experience with Azure Synapse Analytics, Azure Data Lake, or related Azure data services. • Knowledge of Power Platform architecture and Dataverse data model. • Experience with CI/CD pipelines and DevOps practices for data solutions. • Familiarity with Agile delivery methodologies. • Azure certifications such as Azure Data Engineer Associate (DP-203) or Azure Solutions Architect certifications. Key Competencies: • Strong architectural and solution design capability. • Ability to provide strategic guidance as an SME. • Excellent stakeholder management and communication skills. • Strong analytical and problem-solving abilities. • Ability to work independently and lead technical discussions.