Please send your updated resume to
JOB DESCRIPTION:
Job Title: Azure Cloud DW Architect
Location: Albany, NY - Onsite
Duration: Long-term Contract
Direct Client Need
Responsibilities:
- IFS Data Warehouse implementation and ETL delivery Features:
- Establish Data Warehouse strategy and build DW Architecture with our client.
- The DW solution will have multitier architecture Viz., Bronze (RAW+Refined Data), Silver (Cleansed & Refined Data) and Gold (Fine Data). All transformations of Data will be handled between bronze and silver tier. There will be mapping required to consume data from other sources (as depicted in To-Be Diagram) at Azure Data Lake storage and Azure Data Pipeline stage.
- Replicate IFS tabular analysis model into Delta Lake into Medallion Architecture to our client s format (with or without minor translations).
- Coding to extend IFS Analysis model or replicate IFS tabular model in Delta Lake to consume data from all sources (IFS DW as it is, other sources with or without mapping).
- Use OLAP Cubes to create SSRS reports (Tabular, OnDemand and emailed)
- Develop Power BI and Excel reports ( reports). Priority is for Finance and Sales Reports.
- Implement our client To-Be Architecture as per the diagram provided.
- Consume Legacy LDW historical Data to the new DW Solution using IFS Analysis model or by building similar parallel system for one time transfer.
- Integration Layer mapping using Boomi to map the data from each individual systems into the data lake for further processing.
- Conduct workshop with business to collect reporting requirements.
- Prepare requirement specification and technical specification of reports.
- Support UAT.
- User training to core team members.
- Deployment of reports.
Qualifications/skills:
- 13 to 15 years of professional experience required.
- 7 to 10 years of experience are required for the Architect role, including the projects from Scratch.
- Last 3 years as an Azure Data Architect.
- Hands-on experience with Azure Data Factory, Azure Databricks, Azure Key Vault, Azure Data warehousing, PySpark, Blob storage, ADLS Gen2, Snowflake, SQL Server, and SharePoint.
- Data ingestion, data validation, and transformations using Azure Data Factory and Databricks notebooks.
- Excellent communication, able to articulate clearly and present clearly.
- 4 to 5 strong experiences in Power BI, OLAP Cubes, SSIS, SQL, SQL Server, and PL/SQL
- Handson experience with analytical models in SSAS using tabular data sources.
- Handson experience in ETL Data warehousing.
- Nice to have IFS ERP and Dell Bhoomi Experience (Not mandatory)
- Solid knowledge of platforms