Ongoing support and maintenance of existing Power BI dashboards, ad hoc analyses and data extracts
Collate data from various source systems and databases, cleanse, transform and prepare data for Power BI reporting and ad hoc analysis
Build dashboards and ad hoc reports to synthesize and aggregate data across multiple sources for internal and external stakeholders
Interpret data, and analyze results using statistical techniques
Creation of clear written and visual artifacts to drive decision making
Reinforce a high level of governance alignment with general client's guidelines across all data deliverability
Ensure safety and accuracy of information across all data solutions delivered by the team
Prepare and maintain BI reporting and analysis documentations
Work closely with the other areas of the Business (such as IT and Data & Analytics) on design and implementation to ensure business requirements are being met accurately and in a scalable matter and communicated to the business at large
Qualifications
Extensive experience with reporting using Power BI, Sigma and similar tool sets
Design and develop database objects, tables, stored procedures, views and triggers
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
Design and develop ETL processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL Databases
In-depth knowledge of standard concepts, practices and procedures related to database management
Proven analytical problem solving and debugging skills
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
Design and develop enterprise and departmental business intelligence and data warehousing solutions
Performs ad-hoc analysis using SQL query language within the database systems using a process-oriented approach
Understands the concept of Data marts and Data lakes and experience with migrating legacy systems to data marts/lake