Typical Day in Role:
• Design, develop and deploy Power BI/data visualization solutions (simple to sophisticated) to designed user requirements/specifications.
• Conduct requirements analysis and translate data into informative reports, dashboards and KPI’s.
• Connect to data sources, import data, and transform data for Business Intelligence.
• Support data model enhancements with analysis and solution recommendations.
• Research, analyze, recommend & implement new methods for developing Power BI solutions.
• Support steady-state Power BI reports.
• Develop queries and data visualizations for ad-hoc, recurring, troubleshooting requests and projects. Create exploratory data analysis, reports, dashboards to surface data for different stakeholders.
• Collaborate with IT team to develop/maintain/manage SQL Server database Global Operational Risk entities.
• Provide data to business users from SQL Server on ad-hoc basis.
• Perform data integrity checks for data completeness.
• Act as a bridge between IT team and GOR for any database needs.
• Support project delivery with database analytics, mapping, profile comparison, PowerBI reporting enhancements.
• Escalate to Senior Manager for assistance and/or escalation purposes, to quickly analyze problems and resolve escalated issues, and provide recommendations to management regarding resolution
• Database work and visualization for creating dashboards
• Extract and design data, and build dashboards accordingly
Candidate Requirements/Must Have Skills:
1. 8+ years of expert experience in designing, developing, and deploying Power BI/data visualization solutions i.e., reports and dashboards (simple to sophisticated) by translating business requirements to design data models and develop visualizations
2. 8+ years’ experience as a Developer using SQL and Power BI
3. 8+ years’ of demonstrated experience with data analysis
4. 8+ years’ experience with data visualization, data modeling & UX standard methodologies
5. Expert proficiency in Excel
Nice-To-Have Skills:
1. Experience with Operational Risk – Understanding of Operational Risk processes and metrics will be a plus
2. Business analysis & consulting ability – Experience at writing business & user requirements
3. Experience in data extraction, transformation and loading process (ETL)
Education:
Undergraduate Degree or higher and /or 8+ years of relevant functional and/or technical experience