Temporary Senior Associate – Reporting Dashboard Engineer (Power BI / Tableau)

RSM; Chicago, New York (IL, NY); On-site; USD 90,000 - 120,000; Full time

Job summary

RSM is seeking a Temporary Senior Associate - Reporting Dashboard Engineer to join our Risk Consulting practice and support complex Financial Services and Global Banking engagements. The role focuses on designing enterprise dashboards and transforming data into actionable insights using Power BI and Tableau.

You will build and optimize data models, write SQL, and collaborate with stakeholders to deliver scalable reporting solutions that enable executive-level reporting and regulatory compliance

Qualifications

• Bachelor's degree in Information Systems, Computer Science, Data Analytics, Engineering, Finance, or 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.

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.

Skills

Power BI

Tableau

SQL

Data modeling

ETL/ELT

Stakeholder communication

Analytics

Education

Bachelor's degree in Information Systems, Computer Science, Data Analytics, Engineering, Finance, or related field

Tools

Azure

Databricks

Snowflake

Synapse Analytics

Microsoft Fabric

Job description

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.

Temporary Senior Associate - Reporting Dashboard Engineer (Power BI / Tableau)

Position Summary

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.

Required Qualifications

• 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.

Preferred Qualifications

• 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 based on race; color; creed; sincerely held religious beliefs, practices or