Senior Power BI Developer

---

Job description

Position Overview:

We are looking for a Senior Power BI developer to join the global development team working on next-generation Analytics platform.

This resource will be a part of the product team responsible for the design, specification, and construction of analytics features and tools serving the financial industry. This role's primary responsibility will be to build BI data model and then implement best-in-class Power BI reports visualizing complex analytics. In this role, we expect a hands-on, detail-oriented, analytical individual who is able to quickly grasp new concepts and effectively communicate them. This role provides an excellent opportunity to learn financial analytics subject matter found in risk and portfolio management systems across a wide variety of asset classes.

The candidate will be part of a team responsible for building BI data models and implementing rich interactive Power BI dashboards on top of the data warehouse.

Responsibilities:

• Define, implement, and optimize the Data layer for Power BI Reports; Build visualizations and dashboards on top of the created data layer.
• Design and develop interactive visualizations, reports, and dashboards using Power BI desktop connecting to the data warehouse.
• Performance tuning of Power BI reports, by properly configuring the dataset modes - import mode/direct query etc.
• Knowledge of Configuring DB connections on Power BI Servers in Azure.
• Setup and manage deployment pipelines for Power BI reports to automate the release life cycle.

Desired Experience:

• 7+ years of experience in developing advanced reports and dashboards.
• 5+ years of strong hands-on Power BI experience in creating interactive reports against large datasets. Should be well versed with drill-down and drill through techniques.
• The ability to understand complex data schemas and create optimized BI data models for reporting needs is a must.
• Hands-on experience in architecting Power BI embedding portal is required (authentication/authorization/performance tuning etc.).
• Able to implement row-level security (RLS) on data and understand application security layer models in Power BI.
• Deep understanding of dimensional modeling, enterprise data warehouse and Azure Data Lake.
• Practical experience in understanding the capabilities and limitations of Direct Query vs Import Mode.
• Experience in data extraction, data modeling, data warehousing and performance optimization.
• Experience in managing Azure Power BI dedicated capacity and a good understanding of management APIs required.
• Writing efficient and performant DAX queries is required.
• Experience working with Snowflake data warehouse is a plus.

Minimum Qualification:

• Bachelor's Degree in Computer Science or related discipline.
• Analytical, detail-oriented, and problem-solving aptitude.
• Knowledge of finance/equity and financial data is a plus.

- provided by Dice