Power BI & Data Modelling Role

Responsibilities:

- Develop visual reports, dashboards and KPI scorecards using Power BI desktop

- Connect Power BI to different data sources, import data and transform data per project requirements

- Should be able to create data flows

- Should be able to write SQL queries and understand database fundamentals such as multidimensional database design, relational database design, and more

- Proficient in creating complex DAX queries, Power Query, bookmarks and SQL

- Implement row level security on data and understand application security layer models in Power BI, develop tabular/multidimensional models that are compatible with warehouse standards using M-Query

- Adept in developing, publishing, and scheduling Power BI reports and to visualize various trends as per the business requirements

- Be able to troubleshoot, do enhancements on existing reports and create new dashboards

Skills- Mandatory - Power BI + SAS / SQL

Additional skills Required - CISCO / Salesforce / NICE

Good to have - Snowflake, Toad for Oracle / Database, Python, Mainframe, Rally

Candidate Profile:

- Bachelor's/Master's degree in computer science/engineering, operations research, or related

analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic

institutions are also welcomed to apply

- 3+ years' relevant experience preferably in analytics

- Expertise in model development for reports, data transformations and Modelling using Power BI Query Editor

- Develop and integrate with various data sources. Experience in use of varied data connectors to in house or cloud data stores with ability to quickly stage & shape data from sources into reporting and analytics solutions

- Create relationships between data and develop tabular and other multidimensional data models.

- Should be able to handle complex data queries/client requirements with hands on experienced on tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Power BI, Power Query, Power Pivot and DAX for successfully designing, modelling, and implementing end to end power bi solutions

- Experience in data gateway for data refres