• Thoucentric - Power BI/M/DAX Functions Architect Jobs in Bangalore,India

  • Thoucentric Technology Private Limited

Job Description:

Description

Technical Competencies

- Extensive experience with Power BI, M and DAX functions

- Perform detailed analysis of source systems and source system data and model that data in Power BI

- Design, develop, and test Power BI scripts to import data from source systems and test Power BI dashboards to meet customer/client requirements

- Extracting, transforming and loading data from multiple sources into Power BI applications

- Design, create and tune physical database objects (tables, views, indexes) to support logical and dimensional models; Maintain the referential integrity of the database

- Expertise and proven experience in development of reports, dashboards, KPI scorecards, aggregating data from multiple sources

- Background in data warehouse design (eg dimensional modeling) and SQL databases and SQL statements

- In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework

- Analyse Data Model and Report Build with Other BI tools and Migrate to Power BI

- Experience on writing SQL queries

- Good understanding in Datawarehouse Concepts like Star Schema, Snowflake Schema, Fact, Dimensions etc

- Good Knowledge on Writing Complex DAX function, Power Query

- Hands on experience in Building Power BI Data Model, Dashboard & Reports using various Chart, Slicer, Pivot and Custom Visuals

- Knowledge on Power BI Desktop and Power BI Service

- Experience creating real-time dashboards is a plus

Functional Competencies

- Converting data to stories using advanced visualization techniques to help with data-driven decision making and management reporting

- Assisting business users in coming up with the right data and visualization solutions for their requirements which will involve rapidly transforming raw data into actionable information using ETL, analytics and visualization tools and techniques

- Work in an extremely Agile environment with continuous user interaction

- Empower business users for self-serve reporting by building robust domain and logical models

- Digesting and understanding Business Requirements and designing new modules/functionality to meet those needs

- Proactively look to develop, implement and further develop best practices across the group The areas of focus should include, but not be limited to quality improvement, code reviews, code/architecture standards, code reuse, and reduction of support calls, technical documentation and technical design specifications

- Work directly with business units to define and prototype Power BI Dashboards

- Analytical mind with a problem-solving aptitude

- Handle all applications support across ADLS, ADF v20, Azure SQL DB, AZAS, SQL MSD, Power BI application components

- Provide L2/L3 support across the applications

- Monitor ADF pipeline/ ETL Load Monitoring, cube refresh schedule and manual run of loads where needed

- Fixing of issues in production environment and performing Root Cause Analysis across full technology stack

- Minor Enhancement and small projects (less than 2 weeks effort)

- Housekeeping activities (Cleaning up logs, error files, bad files etc )

- Monitoring performance of the reports

- Reporting Usage metrics on the reports deployed

- Providing technical support to users and resolving technical user issues

- Coordinating with Microsoft for facilitating resolution of Product bugs Product outage etc

Specification

Education Bachelors / masters in engineering, MCA

Years of experience 6 years of relevant experience

Experience is following technology / tools mandatory

- Azure SQL Data Base (ASQLDB)

- Power BI

- MS SSIS

Skills ADLS, ADF v20, Azure SQL DB, AZAS, SQL MSD,

Job Type - Permanent

Profile Summary:

Employment Type : Full Time
Salary : Not Mentioned
Deadline : 20th Feb 2020

Key Skills:

Company Profile:

Not Mentioned

Why not try out our free online tutorials and gain an edge?

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status