Firm Technology Representative

The Primary objective of the Firm Technology Representative, Program Reporting & Analytics is to take responsibility for maintaining, enhancing and developing applications, reports & GOL publications for Distribution Sales Compensation (DSC) management, Guardian firms, and Guardian advisors to monitor results in the context of key production/performance thresholds and awards & recognition programs. Specifically, this role will work on the ACS Clubs application, Agency Paid-For system, various reporting platforms and data sources, and other functions as required, including specialized recurring/ad-hoc reports.

This position involves design and development of automated/streamlined reporting and tracking of results, requiring analytical skills and technical problem-solving skills.

An additional objective is to act as liaison between DSC, other user teams and IT. The role will focus on ensuring that reporting & technology needs of DSC and its customers within the Guardian Home Office and the Field are met. This role will assist with monitoring the effectiveness of reports being developed and distributed, automating and streamlining a broad array of functions and ensuring that the appropriate technology is utilized to optimally realize benefits from the incentives & rewards we offer.

• Implement scheduled/ad hoc reports using Excel, Tableau, Quick Suite, Access, SQL, Business Objects, Adobe Professional and other software as required. Learning new software tools to stay up to date on latest technology.
• In coordination with technology and data partners, coordinate efforts to automate production of critical labor‑intensive management reports & develop automated solutions for business needs.
• Provide supplemental business and technical support and assistance to users of Guardian’s firm‑related systems, including Guardian Firms and Home Office staff.
• Support successful execution of reporting processes, maintain accurate datasets/warehouses, and supply ad‑hoc/scheduled reports & prepare field performance reports.
• Work on the design/maintenance of datasets, reports, and dashboards in accordance with established business requirements.

• Responsible for preparing, testing & maintenance of performance reporting infrastructure and data analysis, including extraction and publication of reports/dashboards, documentation and workflows.
• Collaborate with team members in the development, documentation, distribution, and testing of new/existing reports, debugging/troubleshooting reports, and providing support to users.
• Provide data to identify trends impacting performance by various defined segments, products, distribution channel, which supports recommendations to leadership. Collaborating with various teams and providing meaningful feedback on reporting capabilities and data availability. Collaborate with process owners to define, scope and complete projects that statistically prove hypothesis and correlation between producer/firm data/production reasons and process modifications.
• Maintenance of the ACS Clubs, Agency Paid‑For & Recruitment and Retention Monthly/Daily systems. Review, analyze, and monitor qualification rules & criteria for field benefits, awards, and recognition.

• Demonstrate business knowledge and initiative.
• Possess an understanding of relational database design and concepts.
• Excellent verbal and written communication skills. Ability to engage directly with Firms & Advisors to clearly discuss requirements, conduct research, and effectively explain findings and results back to stakeholders.
• Demonstrate a problem‑solving approach to business challenges, as shown by the ability to quickly understand business needs and creatively conceptualize, design, and implement efficient technical solutions.
• Proven ability to handle multiple competing priorities against capacity constraints/deadlines.
• Ability to interact effectively with and assist home office staff and Firm Heads/Advisors as required to accomplish varied technical and business‑related tasks.
• Attention to detail and a passion for precision and accuracy.
• Strong analytical,…