About the role
- Designing interactive reports and dashboards using PowerBI or leverage SSRS or Report Builder
- Writing complex DAX expressions for custom measures and calculations
- Configuring scheduled data refresh and Power BI Gateways, Implementing Row Level Security
- Publishing and sharing content through Power BI Service
- Connecting to various data sources (SQL Server, Excel, APIs, etc.)
- Data extraction from relational databases and external sources
- Create, modify and test various SQL queries, stored procedures and views for obtaining data from diverse source systems and platforms
- Design and develop new SQL/SSIS code as part of an ETL process to support report development on PowerBI
- Support multi-dimensional cube development using MDX in SSAS for select use cases or run existing assets
- Develop stored procedures functions using T-SQL/SQL to automate report refresh or data views
- Excellent verbal and written communication skills including demonstrated ability to effectively and professionally communicate with others, including situations where you may disagree with people