
Associate, Data Analytics and AI
RSM US LLP
full-time
Posted on:
Location Type: Hybrid
Location: McLean • Illinois • Iowa • United States
Visit company websiteExplore more
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