Technical Architect – DATA/AI (ADF, Power BI)

• Experience – 10 to 15 Years
• Excellent verbal and written communication. Should be able to speak confidently throughout the conversation
• Designing Data Lake storage layer (Landing/staging, raw, trusted/curated zones), Designing DB schema, data models for Azure based data warehouse
• Creating Pipelines and integrations of multiple data sources using Azure data factory and other integration technologies
• Good to have experience with Big Data processing, using Big Data technologies on Azure platform
• Expertise in designing visualizations using with Power BI
• Hands-on with DAX (MDX optional)
• Designing Reports against cloud and on-premise data sources
• Experience working with customer Business or IT team
• Good knowledge of working with Enterprise Gateway, data refreshes scheduled through service, or through REST APIs and Power BI Dataflows

Primary Skills (Must have)

• Azure SQL, SQL Programming, ADF, ADLS, Data Bricks, Azure Synapse, Power BI, Data Modelling in Power BI or SSAS
• Must have worked on several (3+) projects building solutions for Data Pipelines, Data warehousing, Data Modelling on Azure Data Platform
• Expertise with 10+ Yrs. working with SQL Server and extensive experience with SQL programming . Programming and optimizing DB objects Views, Stored Procs, Functions
• Expertise working with ADF pipeline and/or Databricks to build data movement pipelines from relational or structured or unstructured data from data lake to data warehouse on Azure
• Extending ADF’s capability using custom C# code or Databricks
• Expertise in Data Modelling using SSAS or Azure Analysis Services