RSM is looking for a Data Analyst to develop, automate, and compile data, preparing reports using various tools and compiled data from internal systems to provide insights and support business intelligence frameworks.
Requirements
- Advanced Microsoft Office skills with exposure to Visual Basic
- Solid understanding of developing data requirements.
- Knowledge of Excel, Power BI, SQL, and understanding of concepts of database structures and data querying.
- Previous experience with SQL preferred.
- Previous experience with a Business Intelligence (BI) tool preferred.
- Previous experience analyzing data and predicting future outcomes preferred.
Responsibilities
- Developing data and storage requirements, reporting, analytics, and delivery methods in data standards and metadata.
- Develop, analyze, and evaluate data to create and maintain business intelligence frameworks.
- Integrate and mine large data sets, connecting data from disparate sources to identify critical insights and pragmatic data solutions.
- Maintain/update/create technical specifications (ex. data mapping, data flows, and dashboard content).
- Develop real-time reporting for analyzing KPIs.
- Design and create analysis and reports that include summaries, graphs, diagrams, and other visual representations in BI or excel.
- Develop and maintain forecasting databases/tools and provide analysis to leaders on outcomes.
Other
- Bachelor’s degree or equivalent experience. Accounting or Finance major preferred.
- Ability to communicate effectively both verbally and written.
- Ability to work autonomously and part of a team.
- Effective organization and time management skills.
- RSM does not intend to hire entry level candidates who will require sponsorship now OR in the future (i.e. F-1 visa holders).
