Data And Reporting Analyst

Aston Carter•Philadelphia, PA

2d•$60,000 - $95,000•Remote

About The Position

The Data & Reporting Analyst is responsible for supporting regulatory, financial, and business reporting initiatives by developing, maintaining, and enhancing reporting solutions that drive informed decision-making across the organization. This role partners with internal stakeholders to gather and document reporting requirements, manage report enhancements and updates, and ensure reporting accuracy and consistency. The analyst will perform data profiling and validation activities to identify anomalies, uncover potential data quality issues, and improve overall data integrity. Additionally, the role requires developing and maintaining SQL queries and scripts for reporting purposes, creating process documentation and data flow diagrams, and leveraging business intelligence tools such as Power BI, Cognos, or similar platforms to deliver meaningful dashboards, analytics, and insights.

Requirements

Proficiency in SQL for data extraction and scripting.
Experience with BI platforms like Power BI or Cognos.
Strong data analysis skills.
Ability to work with end users and understand data structures.
Capability to create VBA in Excel.
Bachelor's degree.
2+ years of experience using SQL to extract data and create scripts for reporting.
2+ years of experience using BI platforms to create dashboards.
2+ years of experience working with stakeholders to develop reports.

Nice To Haves

Financial reporting or accounting experience.
Experience in the insurance industry.

Responsibilities

Support regulatory, financial, and business reporting initiatives.
Develop, maintain, and enhance reporting solutions for informed decision-making.
Partner with internal stakeholders to gather and document reporting requirements.
Manage report enhancements and updates, ensuring reporting accuracy and consistency.
Perform data profiling and validation to identify anomalies and improve data integrity.
Develop and maintain SQL queries and scripts for reporting purposes.
Create process documentation and data flow diagrams.
Leverage business intelligence tools such as Power BI or Cognos to deliver dashboards, analytics, and insights.

Benefits

Medical (PPO/HDHP), vision, disability, and life insurance.
Enhanced dental plan with orthodontia coverage in addition to a standard plan.
Generous PTO plan for all benefit-time eligible employees.
Paid company holidays and 4 floating holidays.
Paid parental leave.
Employee Retirement Savings Plan/401(k) with company match and immediate vesting.
Education Assistance Program that offers 100% upfront tuition reimbursement after 6 months of service for approved degree programs.
Service Recognition Program that provides a monetary award to be used toward a vacation every 5 years of employment.
Wellness Initiatives that include Fitness Center and Weight Watchers Reimbursement programs.
Voluntary benefits that include accident, critical illness, and hospital indemnity.
Employee discount and rewards program on travel, tickets, electronics, home, and more.