10+ years of experience delivering business intelligence solutions
10+ years of experience with OLTP and OLAP database models
Hands on in architecting and delivering End to End BI solutions
Exposure to creating Data Warehouse and Data Marts
Experience in Database : SQL Server
Experience in ETL : SSIS
Experience in BI Technology : SSRS, SSAS, Power BI
Hands on Multi-dimensional cubes, Tabular Models
Knowledge of DAX, MDX
Hands on in Azure PaaS DB, Azure Data Factory, Azure Data Lakes, Data Bricks
Aware of Azure Synapse Analytics, Azure Analysis Services
Good analytical and problem solving skills
Fluent in relational database concepts and flat file processing concepts
Should have good understanding of Agile development methodologies like SCRUM and Kanban.
Good understanding of Azure security components.
Responsibilities:
Will work directly with stakeholders and team members to define, design and deliver actionable insights while working with ETL developers and BI developers in an agile environment.
Deliver self-service BI solutions
Set up Code Access Security and help in code reviews.
Set up CI/CD pipeline for build and release management.
Contribute to product strategy.
Contribute to recruitment by being a part of technical interview panel.
Train junior members of the team on best in class technologies required to deliver the work.
Preferred:
Exposure to time series analysis, clustering, decision trees and neural networks
Exposure to Tableu
Understanding of SAP
Conversion of ABAP code to SQL Procedures
Exposure to AWS, Google Cloud
Understanding of SVN and TFS.
Knowledge of organizational middleware like BizTalk, Dell Boomi.