Experience: 15+ Years

The candidate is expected to be a very senior consultant who can interact with the customer, manage teams (local or remote), and lead the technical or business discussions in critical meetings. An ideal candidate must have been in leadership and consulting roles where he/she has led the setup of several complex data-oriented solutions    on Azure Data Platform   with multiple integrations and reporting needs, especially with SAP.

 The role is a combination of consulting and hands-on experience. The ideal candidate will need to envision, design, and implement the technical solution working with the customer and internal WinWire technical team from offshore. The candidate is expected to have the following expertise (must have)

Azure-based Data Platform

• Must have worked on several (3+) projects involving SQL Azure Data warehouse
• Designing DB schema, data models for Azure-based data warehouse
• Programming and optimizing DB objects Views, Stored Procs, Functions
• Experience in data warehousing concepts including Snowflake
• Creating Pipelines and integrations of multiple data sources using Azure data factory and other integration technologies
• Extending its capability using custom C# code

Hands-on with minimum 12+ Yrs. experience with

• SQL Server must have 4+ Yrs, experience with SQL 2012+
• Designing complex and large database schema, data models
• Programming and optimizing DB objects Views, Stored Procs, Functions

Hands-on with minimum 7+ Yrs. experience 

• Have worked on at least two projects with Multi-dimensional Data Model
• Have worked on at least two projects with tabular Data Model
• SSAS cube design with both Multidimensional and Tabular
• Hands-on with MDX and DAX

Reporting

• Must have knowledge of Power BI or other Data visualization tools including Excel for reporting
• Designing Reports against cloud and on-prem data sources
• Good knowledge of working with Enterprise Gateway, data refreshes scheduled through service or REST APIs
• Experience with C# development web and services

Others

• Experience in hi-tech Domain and SAP Systems integration is a huge add-on

Location: Long Island, NY & Chicago, IL & Santa Clara, CA