Reporting Analyst

1 week ago

Chicago, IL, United States Pivotal Solutions Inc Full time
Job Description
About the Role

The Reporting Analyst will partner with key stakeholders to build data structures and processes to produce meaningful and actionable organizational reporting. This person will need to be able to extract and manipulate data from many different sources to provide a standardized and cohesive view of data to institutional leadership. This position will monitor data sources to enforce best practices and business rules to promote data integrity for all reports. The Reporting Analyst will play a critical role in defining and enabling the organizational data strategy.

Location: Chicago (Loop) with ability to work remotely part of each week

Department: Shared Services - Information Services

Reports To: Vice President of Information Services

FLSA Status: Exempt

Primary Responsibilities:

  • Design and maintain data views needed for requested reports.
  • Assist power users with utilization of data views to produce their own ad-hoc reports.
  • Build and maintain advanced reports as requested by end-users.
  • Create and monitor extract/transform/load processes used in database population and application integrations.
  • Document all data structures, relationships, and attributes in organizational data dictionaries.
  • Identify and report data integrity issues across data sources to promote ongoing data quality.
  • Assist Information Services staff with making data visualizations available on other platforms such as the organization's intranet.
  • Utilize the department ticketing system to obtain position-related end-user support requests, and work with the users to resolve their issues.
  • Perform other duties as assigned.
Required Qualifications:
  • Intermediate knowledge of MS Power BI.
  • Excellent structured query language skills.
  • Ability to create and maintain basic ETL scripts.
  • Working knowledge of MS SQL Server management studio environment.
  • Ability to create thorough documentation for maintenance and end-user training.
  • Advanced knowledge of MS Excel and various delimited text file formats for data movement.
  • Demonstrates a collaborative spirit and values team goals above personal contributions.
  • Ability to be self-motivated for constant improvement/optimization of existing processes.
  • Demonstrates passion for showcasing advanced capabilities of existing tools.
  • Ability to perform the role with the utmost integrity including maintaining the privacy and protection of institutional data.
  • Excellent verbal and written communication skills, and comfortable communicating in-person as well as through video conferencing.
Preferred Qualifications:
  • Experience using Power BI to design high impact visualizations on board-level reports.
  • Knowledge of SharePoint integrations with Power BI.
  • Advanced knowledge of MS SQL Server table/query optimization and complex ETL scripting.
  • Experience with accessing data from a variety of cloud hosted applications.
  • Knowledge of reporting tool utilization in an MS Azure environment.
  • Industry or role-related certifications.
  • Prior experience working in health care or academic settings.
Physical Requirements:
  • Prolonged periods of sitting at a desk and working on a computer.
Education/Experience:
  • Bachelor's Degree in Computer Science, Business, Management or other related fields, or equivalent work experience preferred.
  • 2 years of work experience performing similar duties.

  • Epic Reporting Analyst

    5 days ago

    Chicago, IL, United States Sinai Chicago Full time

    About Sinai Health System Located on Chicago's West and Southwest Side, Sinai Health System is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai Children's Hospital, Sinai Community Institute, Sinai Medical Group, and Sinai Urban Health Institute. The entities of Sinai Health System collectively deliver a full...

  • Epic Reporting Analyst

    1 week ago

    Chicago, IL, United States Sinai Chicago Full time

    About Sinai Health System Located on Chicago's West and Southwest Side, Sinai Health System is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai Children's Hospital, Sinai Community Institute, Sinai Medical Group, and Sinai Urban Health Institute. The entities of Sinai Health System collectively deliver a full...

  • Epic Reporting Analyst

    7 days ago

    Chicago, IL, United States Sinai Chicago Full time

    About Sinai Health System Located on Chicago's West and Southwest Side, Sinai Health System is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai Children's Hospital, Sinai Community Institute, Sinai Medical Group, and Sinai Urban Health Institute. The entities of Sinai Health System collectively deliver a full...

  • Data and Reporting Analyst

    1 week ago

    Chicago, IL, United States Talent Software Services Full time

    Data & Reporting Analyst Job Summary: Talent Software Services is in search of a Data and Reporting Analyst for a contract position in Chicago, IL. The opportunity will be for one year with a strong chance for a long-term extension. Position Summary: To deliver accurate, timely, and actionable insights through advanced Excel-based reporting and data...

  • Financial Reporting Analyst

    1 week ago

    Chicago, IL, United States Hogsalt Full time

    Hogsalt is looking for a full time Financial Reporting Analyst to join our team! We're looking for a detail-oriented Financial Reporting Analyst to prepare financial statements, support audits, and develop financial models that drive decision-making. This role requires strong analytical skills, a track record of accurate reporting under deadlines, and close...

  • CRA Compliance Reporting Analyst

    2 weeks ago

    Chicago, IL, United States Old National Bank Full time

    CRA Compliance Reporting AnalystJob Locations US-IL-Plainfield | US-IL-Chicago | US-MN-Minneapolis | US-WI-Milwaukee | US-IN-Indianapolis | US-TN-Nashville | US-MI-Grand Rapids | US-IN-EvansvilleCategory/Function Risk/SecurityPosition Type Regular Full-TimeRequisition ID 2025-18579Workplace Type On SiteOverviewOld National Bank has been serving clients...

  • CRA Compliance Reporting Analyst

    7 days ago

    Chicago, IL, United States Old National Bank Full time

    CRA Compliance Reporting AnalystJob Locations US-IL-Plainfield | US-IL-Chicago | US-MN-Minneapolis | US-WI-Milwaukee | US-IN-Indianapolis | US-TN-Nashville | US-MI-Grand Rapids | US-IN-EvansvilleCategory/Function Risk/SecurityPosition Type Regular Full-TimeRequisition ID 2025-18579Workplace Type On SiteOverviewOld National Bank has been serving clients...

  • CRA Compliance Reporting Analyst

    1 day ago

    Chicago, IL, United States Old National Bank Full time

    CRA Compliance Reporting AnalystJob Locations US-IL-Plainfield | US-IL-Chicago | US-MN-Minneapolis | US-WI-Milwaukee | US-IN-Indianapolis | US-TN-Nashville | US-MI-Grand Rapids | US-IN-EvansvilleCategory/Function Risk/SecurityPosition Type Regular Full-TimeRequisition ID 2025-18579Workplace Type On SiteOverviewOld National Bank has been serving clients...

  • Senior Financial Reporting Analyst

    1 day ago

    Chicago, IL, United States Advantage Solutions Full time

    Senior Financial Reporting AnalystJob Locations US-MO-Saint Louis | US-CA-Irvine | US-IL-ChicagoPrimary Posting Location : CitySaint LouisPrimary Posting Location : State/ProvinceMOPrimary Posting Location : Postal Code63105Primary Posting Location : CountryUSRequisition ID 2025-437219Position Type Full TimeCategory Professional: (IT, Finance, Legal, HR,...

  • Senior Financial Reporting Analyst

    1 week ago

    Chicago, IL, United States Advantage Solutions Full time

    Senior Financial Reporting AnalystJob Locations US-MO-Saint Louis | US-CA-Irvine | US-IL-ChicagoPrimary Posting Location : CitySaint LouisPrimary Posting Location : State/ProvinceMOPrimary Posting Location : Postal Code63105Primary Posting Location : CountryUSRequisition ID 2025-437219Position Type Full TimeCategory Professional: (IT, Finance, Legal, HR,...