Senior Data Engineer
About The Position
RSM is seeking a Business Intelligence and Data Engineering professional to work closely with its Data Analytics team. The role focuses on designing and developing data models, data pipelines, semantic models, reports, and dashboards to support business requirements and data-driven objectives. The position collaborates with clients and team members across regions and may require travel up to 20%. Most roles at RSM follow a hybrid workstyle, with team members aligned to an RSM office and meeting in person when it supports client work, teams, development, or relationship-building; some roles may be virtual or primarily on-site depending on requirements and priorities.
Requirements
- Bachelor’s degree or equivalent experience in Math, Computer Science, Information Systems, Finance, Accounting, Economics, or Analytics.
- At least 3 years of experience designing data models across multiple subject areas and business domains.
- At least 3 years of experience designing and developing business intelligence solutions.
- At least 3 years of experience designing and developing scalable, efficient data pipelines to ingest, transform, and load data from multiple sources into data lakes and data warehouses.
- Proficiency in SQL.
- Experience with Python or Scala.
- Experience with major cloud platforms such as Microsoft Azure, AWS, or GCP.
- Experience with data platforms such as 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 written and verbal communication skills.
- 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 up to 20%.
Nice To Haves
- Experience conducting solution or technical assessments.
- Experience with DBT, Spark, and Big Data technologies.
- Knowledge of Databricks.
- Working knowledge of modernized information management tools such as Collibra, Informatica, Talend, Alation, or Purview.
Responsibilities
- Create and maintain dimensional and 3NF data models aligned with business requirements.
- Design and develop ETL pipelines that consolidate data from multiple source systems into a unified data platform, including defining source-to-target mappings, business rules, and data transformations.
- Develop semantic models, reports, and dashboards based on business requirements.
- Facilitate business requirements sessions and conduct data analysis to identify and specify data needed to support business objectives.
- Collaborate with clients and team members across regions.
Benefits
- Competitive benefits and compensation package.
- Eligibility for a discretionary bonus based on firm and individual performance.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
