BI Architect

Key Skills

Agile methodologies, Analytical and Problem solving, AWS, Azure, Business Intelligence, Data Architecture, Data Lake, Google Cloud Platform (GCP), IBM Cognos, Looker, MySQL, Oracle, Perl Programming, PowerBI, Python Programming, QlikView, SAP, Spark-SQL, Tableau

Job Description

As a BI Architect, you will be the core functionary to BI Practice at Impetus. You will enable our clients to get the real value out of their peta bytes of data.

You will work closely with client business stakeholders to create BI strategy, architect, design and lead the implementation of end-to-end BI solutions. You will help business teams quantum jump in accessing key business metrics and improve customer experience across multiple client engagements.

Skills / Requirements

• Experience in architecting, designing and implementing complex BI solutions in large scale data management environments
• Expertise in at least two of the following BI Tools – Power BI, Tableau, Qlik, Spotfire, QuickSight, Looker, MicroStrategy, SAP BO, Cognos, along with overall knowhow of multiple BI tools
• Deep knowledge of BI architecture and data warehousing
• Experience working with high volume databases and MPPs
• Experience with the preparation of data (e.g., data profiling, data cleansing, volume assessment and partitioning etc.)
• Strong knowledge of one of the cloud providers – AWS / Azure / GCP
• Strong skills in databases (Oracle / MySQL / DB2) and expertise in writing SQL queries
• Very well versed in HiveQL / Spark SQL / Impala SQL
• Working knowledge of scripting languages like Perl, Shell, Python is desirable
• Working knowledge of data lake and data lake house architecture
• Hands on knowledge of ETL tool
• Hands on knowledge of enterprise repository tools, data modelling tools, data mapping tools, and data profiling tools
• Experience of working in BI platform migration project(s)
• Good understanding of business to build the formulae and calculations to recreate or migrate existing reports and dashboards
• Skills in administering Power BI, Tableau or MicroStrategy servers for maximum efficiency and performance
• Skills in setting up infrastructure including BI servers, sizing / capacity planning, clustered deployment architecture and ability to provide deployment solutions