RSM US LLP

Associate, Data Analytics and AI

RSM US LLP

full-time

Posted on:

Location Type: Hybrid

Location: McLeanIllinoisIowaUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $66,100 - $117,200 per year

About the role

  • 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.

Requirements

  • Bachelor’s degree or equivalent experience in Math, Computer Science, Information Systems, Finance, Accounting, Economics, or Analytics.
  • 1+ years of experience designing data models across multiple subject areas and business domains.
  • 1+ years of experience in designing and developing business intelligence solutions.
  • 1+ 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 and Snowflake
  • Experience with GIT, DevOps, CI/CD or Version Control
  • Experience with BI visualization tools such as Power BI, Quick Sight or Tableau.
Benefits
  • flexibility in your schedule, empowering you to balance life’s demands while also maintaining your ability to serve clients
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data modelingETL pipelinesSQLPythonScaladata analysisbusiness intelligence solutionsdata transformationdata lakesdata warehouses
Soft Skills
collaborationcommunicationfacilitationanalytical thinking