"Alerted.org

Description

We are seeking a highly skilled and motivated Power BI Expert / MI Analyst to join our team to support our Broking platform capabilities and enhancements. The ideal candidate will need to have a strong analytical mindset, excellent communication skills, and a proven track record in data analysis and visualization to support the product leadership with insightful reports

_The role:_

+ **Data Management and Reporting** : Consolidate and report data from multiple sources into Power BI dashboards, providing comprehensive insights into key performance indicators (KPIs) and business metrics.

+ **Management Information (MI) Packs** : Prepare and deliver MI packs for senior management, client meetings, and conferences, offering essential insights into business performance and trends.

+ **System Testing and Maintenance** : Conduct testing of new Power BI reports and dashboards, ensuring accurate results and maintaining a detailed audit trail of test outcomes.

+ **Adhoc Reporting** : Generate and deliver adhoc reports and analyses, ensuring timely delivery within specified deadlines to meet business needs.

+ **Collaboration and Communication** : Participate in conference calls, video conferencing, and weekly team meetings to ensure alignment and progress on data projects and reporting initiatives.

+ **Cross-Department Coordination** : Work closely with various departments to gather requirements, reconcile data sources, and ensure the accuracy and consistency of data presented in Power BI.

+ **Stakeholder Management** : Provide regular updates to stakeholders on reporting activities, dashboard enhancements, and data quality improvements.

+ **Project Management** : Deliver critical data projects with high accuracy and strict adherence to Standard Operating Procedures (SOPs), ensuring successful project completion.

Qualifications

_The Requirements:_

+ **Educational Background:** Graduate, preferably with a strong foundation in Data analytics. Strong analytical skills with the ability to interpret complex data sets and provide actionable insights.

+ **Communication Skills** : Excellent verbal and written communication abilities, essential for effective interaction with stakeholders.

+ **Attention to Detail** : Attention to detail to ensure accuracy and consistency in all deliverables.

+ **MS Excel** : Demonstrated advanced proficiency in MS Excel, including the use of complex formulas, pivot tables, and VBA for automation and data analysis.

+ **SQL** : Extensive experience with SQL for data extraction, manipulation, and analysis.

+ **Power BI:** Develop, test, and deploy quarterly Power BI reports, ensuring they are uploaded to the designated workspace for broader organizational access. Familiarity with DAX and M Query is essential for creating insightful reports.

_Desirable Experience_

+ **Industry Experience:** Previous experience in the insurance industry and data analytics is a strong plus.

Note: Employment-based non-immigrant visa sponsorship and/or assistance is not offered for this specific job opportunity.

This position will remain posted for a minimum of three business days from the date posted or until a sufficient/appropriate candidate slate has been identified.

Compensation and Benefits

Base salary range and benefits information for this position are being included in accordance with requirements of various state/local pay transparency legislation. Please note that salaries may vary for different individuals in the same role based on several factors, including but not limited to location of the role, individual competencies, education/professional certifications, qualifications/experience, performance in the role and potential for revenue generation (Producer roles only).

Compensation

The base salary compensation range being offered for this role is $55,000 - $75,000 USD per year. This role is also eligible for an annual short-term incentive bonus.

Company Benefits

WTW provides a competitive benefit package which includes the following (eligibility requirements apply):

+ **Health and Welfare Benefits:** Medical (including prescription coverage), Dental, Vision, Health Savings Account, Commuter Account, Health Care and Dependent Care Flexible Spending Accounts, Group Accident, Group Critical Illness, Life Insurance, AD&D, Group Legal, Identify Theft Protection, Wellbeing Program and Work/Life Resources (including Employee Assistance Program)

+ **Leave Benefits:** Paid Holidays, Annual Paid Time Off (includes paid state/local paid leave where required), Short-Term Disability, Long-Term Disability, Other Leaves (e.g., Bereavement, FMLA, ADA, Jury Duty, Military Leave, and Parental and Adoption Leave), Paid Time Off (https://cdn-static.findly.com/wp-content/uploads/sites/1862/2023/01/31091722/Washington-State-Time-Off.pdf)

+ **Retirement Benefits:** Contributory Pension Plan and Savings Plan (401k). All Level 38 and more senior roles may also be eligible for non-qualified Deferred Compensation and Deferred Savings Plans.

At WTW, we trust you to know your work and the people, tools and environment you need to be successful. The majority of our colleagues work in a ”hybrid” style, with a mix of remote, in-person and in-office interactions dependent on the needs of the team, role and clients. Our flexibility is rooted in trust and “hybrid” is not a one-size-fits-all solution.

We understand flexibility is key to supporting an inclusive and diverse workforce and so we encourage requests for all types of flexible working as well as location-based arrangements. Please speak to your recruiter to discuss more.

EOE, including disability/vets