Key Responsibilities:
Business Performance Review and Reporting ā 50%
ā¢Ā Ā Ā Lead the creation, approval, and timely delivery of all reporting.
ā¢Ā Ā Ā Collaborate with relevant departments to automate manual reporting processes and optimize delivery strategies.
ā¢Ā Ā Ā Ensure optimized SQL queries are used when creating, editing and/or maintaining all dashboards.
ā¢Ā Ā Ā Assist in the development and troubleshooting of Excel macros to support reporting needs.
ā¢Ā Ā Ā Fulfill ad hoc data requests and maintain recurring reports aligned with SLA commitments.
ā¢Ā Ā Ā Develop and maintain business review presentation decks, including drafting, updating, and coordinating input from cross-functional teams.
ā¢Ā Ā Ā Manage and update assigned ServiceNow tickets to ensure timely resolution and tracking.
ā¢Ā Ā Ā Apply auditing principles to guide decisions on data presentation and ensure reporting accuracy.
ā¢Ā Ā Ā Monitor and evaluate dashboard performance to ensure data accuracy, usability, and alignment with business objectives, making enhancements as needed to support continuous improvement.
Communication and Partnership ā 25%
ā¢Ā Ā Ā Serve as the primary point of contact for reporting-related inquiries, providing technical support and guidance to internal stakeholders.
ā¢Ā Ā Ā Document stakeholder requirements and ensure all deliverables meet agreed-upon specifications.
ā¢Ā Ā Ā Plan, conduct, and track training sessions for team members on Power BI, Excel, and reporting best practices.
ā¢Ā Ā Ā Communicate updates, trends, and issues impacting reporting and analytics to relevant teams and leadership.
ā¢Ā Ā Ā Collaborate with cross-functional teams (e.g., Operations, Compliance, IT) to translate business needs into actionable insights.
ā¢Ā Ā Ā Research and propose alternative reporting solutions when standard approaches are not feasible, documenting rationale and implementation steps.
Quality Assurance and Process Review ā 25%
ā¢Ā Ā Ā Review and validate reports and dashboards to ensure adherence to quality standards.
ā¢Ā Ā Ā Conduct periodic process/quality reviews to identify opportunities for improvement in reporting workflows.
ā¢Ā Ā Ā Maintain documentation of reporting processes, data definitions, and change logs for audit and training purposes.
ā¢Ā Ā Ā Support compliance initiatives by ensuring all reporting activities align with regulatory requirements and company policies.
Basic Qualifications:
ā¢Ā Ā Ā 2+ years of experience in data analysis, reporting, or dashboard development, including SQL.
ā¢Ā Ā Ā Proficient in PowerPoint, Word & Excel (including macros).
ā¢Ā Ā Ā Strong communication and collaboration skills.
Preferred Experience:
ā¢Ā Ā Ā Bachelorās degree in Business Analytics, Information Systems, or related field.
ā¢Ā Ā Ā Experience with ServiceNow or similar ticketing systems is a plus.
assurant