Reporting Analyst

3 days ago

Chicago, 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.

  • Data Reporting Analyst

    3 days ago

    Chicago, Illinois, United States University of Illinois at Chicago Full time

    Responsibilities">The Billing Functional Analyst will be responsible for handling various business operations related to billing services at the University of Illinois at Chicago. This includes creating and managing data reports, processing sponsor billing, addressing AR-related issues, and troubleshooting software errors. You will work closely with...

  • HMIS Reporting Analyst

    2 days ago

    Chicago, United States All Chicago Full time

    REPORTS TO: Director of Information Services STATUS: Exempt, salaried, full-time LOCATION: Chicago, Illinois (hybrid/remote schedule) Salary range: $53,730 - $76,440 (commensurate with experience) ABOUT ALL CHICAGO MAKING HOMELESSNESS HISTORY (ALL Chicago MHH): All Chicago MHH's mission is to unite our community and resources to provide solutions that...

  • Sr. Workday Reporting Analyst

    5 days ago

    Chicago, United States RemyCorporation Full time

    Position Overview:We are seeking a highly skilled Senior Workday Reporting Analyst with a strong background in Workday HCM and advanced reporting capabilities, including Composite and Matrix reports. The ideal candidate will play a critical role in designing, developing, and optimizing Workday reports to meet business needs, providing insights that drive...

  • Regulatory Reporting Analyst Lead

    5 days ago

    Chicago, Illinois, United States Aston Carter Full time

    About the RoleWe are looking for an experienced Regulatory Reporting Analyst Lead to join our team in Chicago, IL. This role will be responsible for leading the preparation and submission of various regulatory reports.Responsibilities:Reporting Team Leadership: Lead a team responsible for preparing and submitting regulatory reports.Report Quality Assurance:...

  • Financial Reporting Analyst

    2 hours ago

    Chicago, Illinois, United States Irca Group Full time

    About Us">The Irca Group is a prominent international provider of semi-finished ingredients for the bakery, pastry, and gelato markets. We cater to independent producers as well as large food manufacturers, including consumer packaged goods (CPG) companies.Our core product offerings consist of chocolate, chocolate decorations, creams, pastry mixes, gelato...

  • Financial Analyst

    3 days ago

    Chicago, Illinois, United States Women Impact Tech Full time

    About the RoleWe are seeking a highly skilled Financial Analyst - Reporting Development to join our team at Women Impact Tech. In this role, you will be responsible for developing and maintaining financial reports, dashboards, and other visualizations to support business decision-making.You will work closely with cross-functional teams to identify areas for...

  • Accounting Reporting Analyst

    2 days ago

    Chicago, United States McDonald's Corporation Full time

    Job Description McDonald’s Corporate Controller Group’s Financial Accounting and Reporting group currently has an excellent opportunity for an Analyst to join our team. This position offers a tremendous opportunity for an individual to gain an understanding of McDonald’s Corporation, the global business, financial statements, consolidation accounting,...

  • Customer Service Reporting Analyst

    4 days ago

    Chicago, United States USG Full time

    USG is an industry-leading manufacturer of building products and innovative solutions. For over 120 years, Chicago-based USG has developed award-winning wall, ceiling, flooring, sheathing, and roofing products that enable customers to build outstanding spaces where people live, work, and play. With over 8,700 employees across North America and operations...

  • Customer Service Reporting Analyst

    3 days ago

    Chicago, United States USG Full time

    USG is an industry-leading manufacturer of building products and innovative solutions. For over 120 years, Chicago-based USG has developed award-winning wall, ceiling, flooring, sheathing, and roofing products that enable customers to build outstanding spaces where people live, work, and play. With over 8,700 employees across North America and operations...

  • Accounting & Reporting Analyst

    2 days ago

    Chicago, United States McDonald's Corporation Full time

    Company Description: McDonald’s is proud to be one of the most recognized brands in the world, with restaurants in over 100 countries that serve 70 million customers daily. We continue to operate from a position of strength. Our updated growth strategy is focused on staying ahead of what our customers want and realizing further growth potential. Our...

  • Customer Service Lead Reporting Analyst

    2 days ago

    Chicago, United States USG Full time

    USG is an industry-leading manufacturer of building products and innovative solutions. For over 120 years, Chicago-based USG has developed award-winning wall, ceiling, flooring, sheathing, and roofing products that enable customers to build outstanding spaces where people live, work, and play. With over 8,700 employees across North America and operations...

  • Customer Service Lead Reporting Analyst

    4 hours ago

    Chicago, United States USG Full time

    USG is an industry-leading manufacturer of building products and innovative solutions. For over 120 years, Chicago-based USG has developed award-winning wall, ceiling, flooring, sheathing, and roofing products that enable customers to build outstanding spaces where people live, work, and play. With over 8,700 employees across North America and operations...

  • Sr Oracle Report Analyst

    7 days ago

    Chicago, United States System Soft Technologies Full time

    Job Summary:We are looking for an energetic Sr. Oracle Reports Analyst join our team. In this role, you’ll work cross-functionally with business operations and to create and optimize workflow processes. Responsibilities:The primary responsibilities will be working with users to troubleshoot RPD and SQL issues relating to reports and dashboards. Knowledge...

  • Sr Oracle Report Analyst

    3 days ago

    Chicago, United States System Soft Technologies Full time

    Job Summary:We are looking for an energetic Sr. Oracle Reports Analyst join our team. In this role, you’ll work cross-functionally with business operations and to create and optimize workflow processes. Responsibilities:The primary responsibilities will be working with users to troubleshoot RPD and SQL issues relating to reports and dashboards. Knowledge...

  • Sr Oracle Report Analyst

    3 days ago

    Chicago, United States System Soft Technologies Full time

    Job Summary:We are looking for an energetic Sr. Oracle Reports Analyst join our team. In this role, you’ll work cross-functionally with business operations and to create and optimize workflow processes. Responsibilities:The primary responsibilities will be working with users to troubleshoot RPD and SQL issues relating to reports and dashboards. Knowledge...

  • Risk Data and Reporting Business Analyst

    4 hours ago

    Chicago, Illinois, United States CIBC Full time

    About the RoleAs a Risk Data and Reporting Senior Analyst at CIBC, you will be part of a dynamic team responsible for providing data-driven insights to inform risk management decisions. This is an excellent opportunity to leverage your analytical skills and experience in risk management to drive business growth and success.In this role, you will be working...

  • Senior Internal Reporting Financial Analyst

    3 days ago

    Chicago, United States Holcim Us Inc Full time

    Senior Internal Reporting Financial Analyst Requisition ID: 10191 Location: Chicago, IL, US, 60631 Pay Type: Salary Estimated Wage Range $67,200 - $109.400/Annually ARE YOU READY TO BUILD PROGRESS WITH US? Driven by our purpose: Building progress for people and the planet. We are transforming to become the global leader in innovative and sustainable building...

  • Reporting Specialist

    20 hours ago

    Chicago, Illinois, United States All Chicago Full time

    Job Title: HMIS Reporting Analyst">At All Chicago Making Homelessness History (ALL Chicago MHH), we are seeking a highly skilled HMIS Reporting Analyst to join our team. As a key member of our data analytics team, you will play a crucial role in reviewing, understanding, and processing data to develop reports, data requests, and data transformations.As an...

  • Workday Reporting Specialist

    4 days ago

    Chicago, Illinois, United States RemyCorporation Full time

    Job DescriptionWe are seeking a highly skilled Senior Workday Reporting Analyst with a strong background in Workday HCM and advanced reporting capabilities, including Composite and Matrix reports. The ideal candidate will play a critical role in designing, developing, and optimizing Workday reports to meet business needs, providing insights that drive...

  • Senior Internal Reporting Audit Analyst

    5 days ago

    Chicago, United States Holcim Us Inc Full time

    Senior Internal Reporting Audit Analyst Requisition ID: 10189 Location: Chicago, IL, US, 60631 Pay Type: Salary Estimated Wage Range $67,200 - $109,400/Annually Travel Requirement: 11-20% ARE YOU READY TO BUILD PROGRESS WITH US? Driven by our purpose: Building progress for people and the planet. We are transforming to become the global leader in innovative...