Senior Data Engineer — BI, ETL & Data Platforms (Hybrid)

RSM US LLP; Chicago (IL); Hybrid; USD 89,000 - 168,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 business analytics. You will collaborate with our Data Analytics team to build data models, develop ETL pipelines, and deliver semantic models and dashboards.

The role requires creating data-driven solutions, working with clients across regions, and traveling up to 20%.

Qualifications

• Bachelor’s degree or equivalent in Math, Computer Science, Information Systems, Finance, Accounting, Economics, or Analytics.
• 3+ years of experience designing data models across multiple subject areas and business domains.
• 3+ years of experience in designing and developing business intelligence solutions.
• 3+ 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.
• Willing and able to travel up to 20%.

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.
• Travel up to 20%.

Skills

Data modeling

ETL design

Data analysis

Communication

Team collaboration

Problem solving

Education

Bachelor’s degree or equivalent in Math/CS/IS/Finance/Economics/Analytics

Tools

SQL

Python/Scala

Azure

AWS

GCP

Databricks

Snowflake

Power BI

Git/DevOps/CI-CD

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 business analytics. You will collaborate with our Data Analytics team to build data models, develop ETL pipelines, and deliver semantic models and dashboards.

The role requires creating data-driven solutions, working with clients across regions, and traveling up to 20%.