Remote Data Analyst

Data Analyst I Applied General Agency Location: Remote About Applied General Agency Applied General Agency was founded by Patrick Rodriguez in 1993. Headquartered in Anaheim, California, AGA has become one of the largest Medicare-focused independent marketing organizations in the nation. AGA was created with the intention of providing unparalleled value to overworked agents who had more obligations than time. With the support of a full back-office team, AGA has the vision and tools to make quality agents even more successful. AGA has grown to support close to 10,000 agents in serving the needs of half a million Americans nationwide. For more information, visit www.appliedga.com. Job Summary AGA is seeking a Data Analyst I to support the business by extracting, analyzing, and visualizing data to identify trends and inform decision-making. In this role, you will collaborate with cross-functional teams to understand their data needs and deliver actionable insights through reports and dashboards. This is a great opportunity for a detail-oriented individual with a passion for data to contribute to AGA’s success. Primary Responsibilities: - Data Extraction & Cleaning: Gather data from various internal and external sources, ensuring data accuracy and integrity through cleaning, validation, and transformation. - Reporting & Dashboard Development: Design, develop, and maintain interactive dashboards and reports using Power BI to visualize key performance indicators (KPIs). - Ad-Hoc Reporting & Analysis: Respond to ad-hoc data requests from business stakeholders, providing timely and accurate reports based on user requests. - Documentation: Document data sources, methodologies, and analytical processes to ensure transparency and reproducibility. - Collaboration with Business Stakeholders: Partner with business users to understand their data needs and translate them into analytical solutions. - Support Financial Forecasting: Assist