Senior BI Dashboard Engineer (Power BI / Tableau)

RSM US LLP

City of Rochester (NY)

On-site

USD 52,000 - 80,000

Full time

5 days ago

Be an early applicant

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Benefits offered by this job

Flexible schedule

Competitive benefits

Compensation range: $38–$58/hour

Job summary

RSM US LLP is seeking a Temporary Senior Associate - Reporting Dashboard Engineer to design and deliver enterprise dashboards with Power BI/Tableau for risk, regulatory, and executive reporting. You will translate stakeholder needs into scalable analytics, optimize data models, and support data integration across multiple systems.

The role requires strong SQL, BI tool proficiency, and experience with data warehousing and dimensional modeling.

Qualifications

Bachelor's degree in Information Systems, Computer Science, Data Analytics, Engineering, Finance, Accounting or related field.
6+ years of experience in business intelligence, reporting, analytics, dashboard development, or data engineering.
Advanced SQL development experience 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.