Develop dashboards from a wireframe in Microsoft Power BI
Understand the data and build complex data models in the visualization tool sufficing reporting needs
Develop SQL Scripts as needed to pull the data from various sources (SQL Server, Azure SQL Server, Snowflake) and transform as needed for reporting
Develop pixel perfect reports where appropriate
Build & support applications in Power Apps and integrate it with Power BI
Automation of various manual tasks
Research marketplace visuals and R/Python visuals to create new dashboard enhancements
Microsoft Power BI regression testing
User Maintenance - adding new users and removing ones from the system. Keeping track and re-assigning licenses as needed
PowerBI log analysis
Ability to troubleshoot and maintain existing VBA scripts
Monitor email outputs from existing scripts and escalate as needed
Qualification
The ideal candidate would have experience in developing and supporting visualization applications, and be aware on how to do build the data model in Power BI and have a very good understanding of Power query and DAX. Candidate should be able to do basic trouble-shooting and log analysis, root cause analysis, and coordination with multiple IT teams for support
Power BI is the main application that the candidate will be developing and supporting, and the ability to work with the users to make change requests and potentially design dashboards is ideal
Candidate with experience in building geomapping visualizations would be preferred
Candidate should have intermediate experience building Paginated reports using Power BI Report Builder or prior experience in SSRS would be preferred
Intermediate experience in building dashboards in Power BI embedded capacity or building BI solutions leveraging web technologies (JavaScript, Angular JS) would be plus
Intermediate experience in Power Automate Platform
Continue to maintain the existing PowerBI dashboards and to add new features and functionality as requested by the SA team and the business users
Ability to clearly communicate across multiple teams, and the ability to communicate and escalate major issues when appropriate
Ability to perform the tasks in Power BI with minimal assistance
Candidate should be willing to explore & research new tools and technologies based on the guidance from SA team
About The Specialty Insurance Company
The company is a global leader in providing specialty insurance, reinsurance, and mortgage insurance solutions.