Job Description

Role and Responsibilities

•       2+ years of related work experience in business intelligence, data engineering, data warehousing, or a similar field

•       Building Analysis Services reporting models

•       Developing visual reports, dashboards, and KPI scorecards using Power BI desktop

•       Connecting to data sources, importing data, and transforming data for Business Intelligence

•       Proficient in data warehousing and data modeling methodologies, tools and best practices

•       Extensive experience with database optimization, hints, indexing, and join strategies

•       Able to implement row-level security on data and have an understanding of application security layer models in Power BI

•       Experience with standard star schema design and development concepts, including fact table types, grain levels, and SCDs is preferred

•       Proficient in making DAX queries in Power BI desktop

•       Responsible for design methodology and project documentation

•       Able to develop tabular and multidimensional models that are compatible with warehouse standards

•       Should have knowledge and skills for secondary tools such as Microsoft Azure, SQL data warehouse, PolyBase, Visual Studio, etc

•       Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation

•       Having experience in Python will be an added advantage

•       Experience with Cloud technologies (AWS, Snowflake, and Matillion) is preferred

•       Excellent communication skills and ability to translate complex concepts to simple and easier terms for business leaders and users of data