Associate Business Unit Systems Analyst
ExternalFull-timeOn-site2w ago
AuditingComplianceData AnalysisDocumentationExcelLeadership
Prepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
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.
Requirements
- 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.
Your Match
How well this role fits your profile.
Company Intel
What employees say
Worked at assurant? Share your experience