Senior BI & Data Engineer

RSM US LLP; Denver (CO); Hybrid; USD 95,000 - 192,000; Full time

Job summary

RSM US LLP is seeking a skilled Business Intelligence and Data Engineering professional with a strong background in design and development, data modeling, and analytics. You will collaborate with our Data Analytics team to create and maintain data models, ETL pipelines, and semantic reports aligned with business requirements.

Responsibilities include leading requirements sessions, building scalable data pipelines, and delivering dashboards.

Qualifications

• Bachelor's degree or equivalent experience in Math, CS, IS, Finance, Accounting, Economics, or Analytics.
• 5+ years designing data models across multiple subject areas and business domains.
• 5+ years designing and developing business intelligence solutions.
• 5+ years designing and developing scalable data pipelines to ingest, transform, and load data from multiple sources into data lakes and data warehouses.
• Proficient in SQL.
• Experience with Python/Scala.
• Proven experience with major cloud platforms such as Microsoft Azure, AWS or GCP.
• Experience with data platforms like Fabric, Databricks or Snowflake.
• Experience with GIT, DevOps, CI/CD and Version Control.
• Experience with BI visualization tools such as Power BI, QuickSight or Tableau.
• Strong communication skills, both written and verbal.
• Excellent critical thinking and problem-solving abilities.
• Team-oriented with the ability to work independently and in virtual teams.
• Willingness and ability to travel.

Responsibilities

• Create and maintain data models (dimensional and 3NF) aligned with business requirements.
• Design and develop ETL pipelines that consolidate data from source systems into a unified data platform.
• Develop Semantic Models and Reports / Dashboards based on business requirements.
• Facilitate business requirements sessions and conduct data analysis to identify data needs.
• Collaborate with clients and team members across regions.

Skills

SQL

Python/Scala

Data modeling

ETL pipelines

Cloud platforms

Databricks

Power BI

Tableau

Git/DevOps

CI/CD

Data lakes/warehouses

Communication

Travel readiness

Education

Bachelor's degree

Tools

Azure

AWS

GCP

Fabric

Databricks

Snowflake

Power BI

QuickSight

Tableau

Git

Job description

RSM US LLP is seeking a skilled Business Intelligence and Data Engineering professional with a strong background in design and development, data modeling, and analytics. You will collaborate with our Data Analytics team to create and maintain data models, ETL pipelines, and semantic reports aligned with business requirements.

Responsibilities include leading requirements sessions, building scalable data pipelines, and delivering dashboards.