Lead PowerBI and Data Modelling Engineer

Lead PowerBI and Data Modelling Engineer

Department

GAC

Job Description

Lead PowerBI Engineer.

• Experience in working Primarily with Power BI & Qlik Sense and other Business Intelligence tools like Tableau, Micro Strategy, Alteryx, or similar visualization technologies to present complex data in an easily digestible format.
  • Candidate should have good experience in data analysis, writing SQL/MYSQL Workbench queries using joins, unions, analytical functions etc.
  • Experience in performing data management, mining, and manipulation - data manipulation using SQL.
• Experience in BI solutioning to design, develop, and maintain user-friendly data visualizations and dashboards using complex datasets from different sources in Business Intelligence Tools
  • Collaborate with stakeholders to understand requirements and deliver comprehensive BI Solutions.
  • Connect Power BI to various data sources like Databricks, Oracle, SharePoint, and design data models to facilitate complex data analysis.
  • Use Dax & Power Query to perform advance data analysis and create calculated columns, measures & tables.
  • Develop Power BI models for report creation and dashboards.
  • Create and execute manual or automated test cases and analyze test results.
  • Migrate dashboards from Qlik Sense to Power BI.
  • Work closely with fellow developers and project leads in coordinating tasks & deliverables.
  • Pay attention to details and work independently with minimal supervision.
• Ability to work on multi relational database structures with strong experience in Oracle Database environment – SQL, PL/SQL programming.
  • Design and troubleshoot complex queries, stored procedures, functions, views, indexes, constraints, unions, joins, and similar development tasks.
  • Design, create, modify, and test various SQL queries, stored procedures, and views for obtaining data from diverse source systems and platforms.
  • Contribute to architecture, database design and query optimization
  • Review database architecture of product to achieve required technical outcome
• Experience in Data Lake systems using AWS cloud technologies - experience in Data bricks is a plus.
• Extensive Data modelling / metadata experience; specifically designing logical models / data dictionaries from both business requirements and reverse-engineering.
• Hands-on experience contributing to data/application architecture & designs, proven software/enterprise integration design patterns and full-stack knowledge including modern distributed front end and back-end technology stacks
• Refining product based on feedback, ensuring their continuity of accuracy and functionality - Debugging applications, tracing code, and finding and fixing bugs.
• Experience in working Primarily with Power BI & Qlik Sense and other Business Intelligence tools like Tableau, Micro Strategy, Alteryx, or similar visualization technologies to present complex data in an easily digestible format.
  • Candidate should have good experience in data analysis, writing SQL/MYSQL Workbench queries using joins, unions, analytical functions etc.
  • Experience in performing data management, mining, and manipulation - data manipulation using SQL.
• Experience in BI solutioning to design, develop, and maintain user-friendly data visualizations and dashboards using complex datasets from different sources in Business Intelligence Tools
  • Collaborate with stakeholders to understand requirements and deliver comprehensive BI Solutions.
  • Connect Power BI to various data sources like Databricks, Oracle, SharePoint, and design data models to facilitate complex data analysis.
  • Use Dax & Power Query to perform advance data analysis and create calculated columns, measures & tables.
  • Develop Power BI models for report creation and dashboards.
  • Create and execute manual or automated test cases and analyze test results.
  • Migrate dashboards from Qlik Sense to Power BI.
  • Work closely with fellow developers and project leads in coordinating tasks & deliverables.
  • Pay attention to details and work independently with minimal supervision.
• Ability to work on multi relational database structures with strong experience in Oracle Database environment – SQL, PL/SQL programming.
  • Design and troubleshoot complex queries, stored procedures, functions, views, indexes, constraints, unions, joins, and similar development tasks.
  • Design, create, modify, and test various SQL queries, stored procedures, and views for obtaining data from diverse source systems and platforms.
  • Contribute to architecture, database design and query optimization
  • Review database architecture of product to achieve required technical outcome
• Experience in Data Lake systems using AWS cloud technologies - experience in Data bricks is a plus.
• Extensive Data modelling / metadata experience; specifically designing logical models / data dictionaries from both business requirements and reverse-engineering.
• Hands-on experience contributing to data/application architecture & designs, proven software/enterprise integration design patterns and full-stack knowledge including modern distributed front end and back-end technology stacks
• Refining product based on feedback, ensuring their continuity of accuracy and functionality - Debugging applications, tracing code, and finding and fixing bugs.

Open Positions

1

Mandatory Skills

PowerBI, SQL Development, Data Science

Education Qualification

Engg

Experience

9 to 12 Years