Reporting Analyst

2 days ago


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

  • Reporting Analyst

    1 day ago


    Chicago, Illinois, United States Collabera Full time

    Home Search Jobs Job Description Reporting Analyst Contract: Chicago, Illinois, US Salary Range: 55.00 - 60.00 | Per Hour Job Code: 359121 End Date: 2025-03-27 Days Left: 28 days, 2 hours left Apply Location: Chicago, IL/ Washington, DCPosition: Metrics and Reporting AnalystDuration: 12-18 monthsJob Description:Skills & CompetenciesProficiency in...

  • Reporting Analyst

    4 days ago


    Chicago, Illinois, United States Collabera Full time

    Home Search Jobs Job Description Reporting Analyst Contract: Chicago, Illinois, US Salary Range: 55.00 - 60.00 | Per Hour Job Code: 359121 End Date: 2025-03-22 Days Left: 26 days, 2 hours left Apply Location: Chicago, IL/ Washington, DCPosition: Metrics and Reporting AnalystDuration: 12-18 monthsJob Description:Skills & CompetenciesProficiency in...


  • Chicago, Illinois, United States Hire Life Recruiting and Consulting (MD Hearing) Full time

    Job Overview: MDHearing is seeking a highly skilled Financial Reporting Analyst to join our Finance team. This role will assist the Marketing group in financial modeling and reporting, as well as support the Finance team with various tasks.About the Role: The Financial Reporting Analyst will be responsible for analyzing advertising campaign performance data,...


  • Chicago, Illinois, United States Dunhill Professional Search Full time

    ResponsibilitiesWe are looking for a skilled Reporting Analyst Expert to join our team. Your primary responsibilities will include:Building complex SQL queries to bring together multiple data sources.Developing, operating, and maintaining reports that meet client needs.Continuously developing business knowledge to become a subject matter expert.Collaborating...


  • Chicago, Illinois, United States Cresset Full time

    About Cresset Cresset is an award-winning, independent, multi-family office, and private investment firm. Cressets goal is to reinvent the way people experience wealth by providing access to the talent, ideas, and investment opportunities available to the largest single-family offices and endowments. We offer deeply personalized wealth management, investment...


  • Chicago, Illinois, United States Cresset Full time

    About CressetCresset is an award-winning, independent, multi-family office, and private investment firm. Cresset's goal is to reinvent the way people experience wealth by providing access to the talent, ideas, and investment opportunities available to the largest single-family offices and endowments. We offer deeply personalized wealth management, investment...


  • Chicago, Illinois, United States The LaSalle Group Full time

    We are a fast-growing loan company specializing in providing personal and business loans to a diverse range of clients. Our mission is to provide accessible financing solutions with a strong focus on customer satisfaction and operational excellence. As we continue to expand, we are looking for a skilled Remote Credit Reporting Analyst to join our team and...


  • Chicago, Illinois, United States Hire Life Recruiting and Consulting (MD Hearing) Full time

    About UsMD Hearing is a leading company in the hearing aid industry, offering quality hearing aids at an affordable price. We are committed to revolutionizing the way people hear and live better.Job SummaryWe are seeking a skilled Financial Reporting Analyst to join our finance team. This role will assist the marketing group in financial modeling and...


  • Chicago, Illinois, United States C4 Technical Services Full time

    Job Summary:We are seeking a highly skilled Workday Reporting Analyst to join our team at C4 Technical Services. In this role, you will be responsible for designing, building, testing, and deploying Workday reports with review and sign-off process with Workday Functional Leads and business subject matter experts.About the Job:The ideal candidate will have...


  • Chicago, Illinois, United States U.S. Bank Full time

    At U.S. Bank, our mission is to empower customers and businesses to make informed financial decisions. Our team is dedicated to providing exceptional service and support to help them thrive.We're seeking a highly skilled Financial Reporting Analyst to join our Collateralized Loan Obligation (CLO) Group within Global Corporate Trust and Custody. As a key...


  • Chicago, Illinois, United States Addison Group Full time

    Role: Budget & Financial Reporting Analyst Hiring Type: Contract-Hire Location: Washington Office Schedule: in office 2x week Pay: $35 - $41 / Hour Salary: $85000 - $92000 / Year Internal Job ID: 10019121 Our client, a prestigious Non-Profit organization is in need of Budget & Financial Reporting Analyst to join contract to hire basis. Great...

  • Senior Analyst

    5 days ago


    Chicago, Illinois, United States Northern Trust Full time

    About Northern Trust:Northern Trust is a leading global financial institution, delivering innovative solutions to the world's most sophisticated clients. Our commitment to service, expertise, and integrity drives our success. This role will support the Enterprise Risk Management (ERM) Function, focusing on driving consistent, quality reporting of the risk...


  • Chicago, Illinois, United States Collabera Full time

    About Our Ideal CandidateWe are seeking a talented and experienced Senior Reporting and Data Analyst to join our team at Collabera. In this role, you will be responsible for leading data analysis projects, designing and implementing data visualization solutions, and communicating complex information to stakeholders. You will also work closely with...


  • Chicago, Illinois, United States Old Republic Specialty Insurance Group Full time

    Title: Sr. Data Reporting AnalystLocation: Chicago, IL (Hybrid, 3 days in-office)Department: Regulatory Compliance Services Report To: Manager, ComplianceWho We Are:Old Republic International Corporation (ORI), which traces its beginning to 1923, is a Fortune 500 company and one of the nation's 50 largest shareholder-owned insurance organizations. Our...


  • Chicago, Illinois, United States Jobleads-US Full time

    Regulatory Reporting Analyst- Sr. ConsultantRole OverviewThe Regulatory Reporting Analyst- Sr. Consultant reports to the Regulatory Affairs Manager and into the Global Head of Regulatory Program Management; and supports periodic regulatory reporting efforts for any impacted matters under the leadership of the Global Regulatory Affairs Office (GRAO). The...


  • Chicago, Illinois, United States Jobleads-US Full time

    Regulatory Reporting Analyst- Sr. ConsultantRegulatory Reporting Analyst- Sr. ConsultantApply locations Chicago, IL time type Full time posted on Posted 3 Days Ago job requisition id R137433About Northern Trust:Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since...


  • North Chicago, Illinois, United States Mindlance Full time

    About the RoleThis is an exciting opportunity to join our team at Mindlance as a Financial Analyst I. In this role, you will be responsible for supporting our payment processes for external consultant engagements. You will work closely with our team to develop and maintain necessary documentation according to departmental policies to meet quick turnarounds...


  • Chicago, Illinois, United States Hire Life Recruiting and Consulting (MD Hearing) Full time

    Are you a financial whiz with a knack for numbers and a passion for making a real impact at a fast-moving, growing company that's making a lasting impact in the world? MDHearing, the largest seller of OTC hearing aids in the US, is on the hunt for a dynamic Financial Reporting Analyst to join our Finance team. If you're a go-getter who's great to work with,...


  • Chicago, Illinois, United States Hire Life Recruiting and Consulting (MD Hearing) Full time

    Are you a financial whiz with a knack for numbers and a passion for making a real impact at a fast-moving, growing company that's making a lasting impact in the world? MDHearing, the largest seller of OTC hearing aids in the US, is on the hunt for a dynamic Financial Reporting Analyst to join our Finance team. If you're a go-getter who's great to work with,...


  • Chicago, Illinois, United States RWE Clean Energy Full time

    Responsibilities:As a Senior Analyst, Group Reporting, you will be responsible for:Overseeing internal controls, assisting in testing, monitoring, and evaluating internal control processesAssisting with the review and issuance of external unaudited and audited standalone financial statementsDesigning, testing, and monitoring internal control processes to...