Position: BI Developer with SQL, Azure, Cosmos
Location: Redmond, WA
Job Description:
1. Skills required: Cosmos + SQL experience, experience on MSBI (SSIS, SSAS), Power BI, Kusto. Any knowledge on C# .Net and Azure Data Factory, data bricks, pyspark.
Role Description:
Individual with strong technical background in SQL Server, BI, Kusto, Data Analysis and strong knowledge of Data Warehousing Concepts. Should be able to Lead the onsite Team of 5 members. Customer facing, code development and review of devs, one point of contact for the customer.
2. Role and Responsibilities:
• Should be able write complex and efficient -SQL queries.
• Should be able design & Implement end-end data pipelines using cosmos and ADF.
• Problem analysis and troubleshooting complex & “large volume of dataset’s” data issues.
Skills Required:
• Proven experience in SQL Server writing complex T-SQL queries, Performance tuning
• Proven experience in Data Analysis dealing with large volume of datasets.
• Proven experience in Design & Implementation of end-end data pipelines.
• Should have strong knowledge of Data Warehousing concepts.
• Should have very good experience in BI tools (but not limited to)
a. ETL tools like SSIS
b. Reporting tools like Power BI
c. Analytical tools like SSAS – Tabular and multi-Dimensional Cubes and MDX queries.
• Cosmos and scope scripts
• Good to have knowledge of Microsoft Big Data Technologies.
• Good to have knowledge of Azure Data Factory and C#
Excellent communication skills – direct communication with Client