RSM US LLP
Temporary Senior Associate – Reporting Dashboard Engineer (Power BI / Tableau)
We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, culture and talent experience and our ability to be compelling to our clients. You’ll find an environment that inspires and empowers you to thrive both personally and professionally. There’s no one like you and that’s why there’s nowhere like RSM.
RSM is looking for a Temporary Senior Associate – Reporting Dashboard Engineer to join our Risk Consulting practice and support complex Financial Services and Global Banking engagements. This role is ideal for a data and analytics professional with extensive experience designing enterprise reporting solutions, building dashboards, and transforming data into actionable business insights.
The successful candidate will possess strong Power BI and/or Tableau expertise, advanced SQL capabilities, and experience working with data warehouses, dimensional data models, and modern data platforms. This individual will collaborate with business and technology stakeholders to develop scalable reporting and analytics solutions that support operational, risk, regulatory, and executive reporting needs.
Responsibilities- Design, develop, and maintain interactive dashboards, reports, and visualizations using Power BI, Tableau, or similar BI tools.
- Partner with business stakeholders to gather reporting requirements and translate business needs into scalable analytics solutions.
- Develop and optimize data models, semantic layers, and reporting datasets to support enterprise reporting initiatives.
- Write complex SQL queries to analyze, validate, reconcile, and transform large datasets.
- Build and support ETL/ELT processes and data integration workflows across multiple source systems.
- Create executive dashboards, scorecards, KPIs, and management reporting packages.
- Implement data quality controls and reporting governance standards to ensure reporting accuracy and consistency.
- Investigate reporting issues, perform root cause analysis, and resolve data discrepancies.
- Support user acceptance testing, deployment activities, and ongoing production support.
- Document reporting solutions, processes, and technical specifications.
- Bachelor's degree in Information Systems, Computer Science, Data Analytics, Engineering, Finance, Accounting, or a related field.
- 6+ years of experience in business intelligence, reporting, analytics, dashboard development, or data engineering.
- Advanced SQL development experience working with large and complex datasets.
- Strong hands-on experience with Power BI and/or Tableau.
- Experience designing dimensional data models, including star and snowflake schemas.
- Experience supporting data warehousing and reporting environments.
- Experience with ETL/ELT processes and data integration tools.
- Strong analytical, problem-solving, and communication skills.
- Ability to work effectively with both technical and non-technical stakeholders.
- Experience within Financial Services, Banking, Capital Markets, Risk Management, or Regulatory Compliance environments.
- Experience supporting regulatory reporting, risk reporting, audit analytics, or data governance initiatives.
- Experience with cloud-based data and analytics platforms such as Azure, Microsoft Fabric, Databricks, Synapse Analytics, Snowflake, or similar technologies.
- Knowledge of data quality management, reporting controls, and governance best practices.
- Experience supporting large-scale data transformation, modernization, or reporting enhancement programs.
At RSM, we offer a competitive benefits and compensation package for all our people. We offer flexibility in your schedule, empowering you to balance life’s demands, while also maintaining your ability to serve clients. Learn more about our total rewards at https://rsmus.com/careers/working-at-rsm/benefits.
All applicants will receive consideration for employment as RSM does not tolerate discrimination and/or harassment based on race; color; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender; sexual orientation; HIV Status; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the US uniformed service; US Military/Veteran status; pre-disposing genetic characteristics or any other characteristic protected under applicable federal, state or local law.
Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership. RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please call us at 800-274-3978 or send us an email at [email protected].
RSM does not intend to hire entry level candidates who will require sponsorship now OR in the future (i.e. F-1 visa holders). If you are a recent U.S. college / university graduate possessing 1-2 years of progressive and relevant work experience in a same or similar role to the one for which you are applying, excluding internships, you may be eligible for hire as an experienced associate.
RSM will consider for employment qualified applicants with arrest or conviction records. For those living in California or applying to a position in California, please click here for additional information.
At RSM, an employee’s pay at any point in their career is intended to reflect their experiences, performance, and skills for their current role. The salary range (or starting rate for interns and associates) for this role represents numerous factors considered in the hiring decisions including, but not limited to, education, skills, work experience, certifications, location, etc. As such, pay for the successful candidate(s) could fall anywhere within the stated range.
Compensation Range: $38 - $58 per hourRSM US LLP Chicago, Illinois, USA Office
30 S Wacker Dr, Chicago, IL, United States, 60606
RSM US LLP Schaumburg, Illinois, USA Office
Schaumburg, United States
Similar Jobs
.png)
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
