Understand the business requirements thoroughly to design and develop the BI architecture.
Determine business intelligence and data warehousing solutions that meet business needs.
Perform data warehouse design and modelling according to established standards.
Work closely with the business teams to arrive at methodologies to develop KPIs and Metrics.
Work with Project Manager in developing and executing project plans within assigned schedule and timeline.
Develop standard reports and functional dashboards based on business requirements.
Ensure to develop and deliver high quality reports in timely and accurate manner.
Conduct training programs and knowledge transfer sessions to junior developers when needed. Recommend improvements to provide optimum reporting solutions.
Ideally, you have:
Undergraduate degree (B.E/B.Tech.) from tier-1/tier-2 colleges are preferred.
2 - 5 years of experience in related field.
Proven expertise in SSIS, SSAS and SSRS (MSBI Suite).
In-depth knowledge of databases (SQL Server, MySQL, Oracle etc.) and data warehouse (Azure Synapse, AWS Redshift, Google BigQuery, Snowflake etc.).
In-depth knowledge of business intelligence tools (any one of Power BI, Tableau, Qlik, DOMO, Looker etc.).
Good understanding of Azure (Data Factory Pipelines, SQL Database Managed Instances, DevOps, Logic Apps, Analysis Services), AWS (Glue, Aurora Database, Dynamo Database, Redshift, QuickSight).
Proven abilities to take on initiative and be innovative.
