BI Developer

CRISIL Ltd

Pune

Not disclosed

Work from Office

Full Time

Min. 9 years

Job Details

Job Description

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

Job role

Work location

Pune, Maharashtra, India

Department

IT & Information Security

Role / Category

IT Infrastructure Services

Employment type

Full Time

Shift

Day Shift

Job requirements

Experience

Min. 9 years

About company

Name

CRISIL Ltd

Job posted by CRISIL Ltd

This job has expired