Senior BI & Data Engineering Leader

RSM US LLP

Des Moines (IA)

Hybrid

USD 95,000 - 192,000

Full time

3 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

RSM US LLP is seeking a skilled Business Intelligence and Data Engineering professional to design data models, build ETL pipelines, and develop semantic models and dashboards for data-driven decision making. The role involves collaborating with the Data Analytics team across regions to translate business requirements into scalable data solutions.

The ideal candidate has 5+ years in data modeling, BI solutions, and scalable data pipelines, with strong SQL, Python/Scala, and cloud platform

Qualifications

Bachelor's degree or equivalent experience in Math, Computer Science, Information Systems, Finance, Accounting, Economics, or Analytics.
5+ years of experience designing data models across multiple subject areas and business domains.
5+ years of experience in designing and developing business intelligence solutions.
5+ years of designing and developing scalable, efficient 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, Quick Sight 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.
Passion for solving complex business problems through data-driven solutions.
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 various source systems into a unified data platform, including defining source-to-target mappings, business rules, and any necessary data transformations.
Develop Semantic Models and Reports / Dashboards based on business requirements.
Facilitate business requirements sessions and conduct data analysis to accurately identify and specify the data needed to support impactful business objectives.
Collaborate effectively with clients and team members across regions.