Job Purpose:

The Associate Business Unit Systems Analyst will play a key role in developing, implementing, and maintaining Power BI dashboards to support data-driven decision-making across the business unit. This position will be responsible for producing monthly and ad hoc reports for leadership, leveraging tools such as Power BI and Excel to ensure accuracy and clarity. The analyst will collaborate with cross-functional teams to gather requirements, translate business needs into actionable insights, and monitor dashboard performance. Success in this role requires strong analytical skills, attention to detail, and the ability to communicate complex data in a clear and concise manner.

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.