RSM - Chicago, IL
posted 4 months ago
The Database Analyst Senior is a pivotal member of the Sales and Marketing Insights team within the Marketing and Sales organization at RSM. This newly created position is primarily responsible for the development and delivery of new, ad-hoc data models and tabular reporting to support the entire Insights team, as well as fulfilling ad-hoc requests from various departments across RSM. The role is designed for a Subject Matter Expert (SME) who will be instrumental in accessing and manipulating client and prospect data. The Database Analyst Senior will collaborate closely with Insights team members, Certified Analysts throughout RSM, and will be expected to partner with members of IT, Finance, HR, and other centralized functions focused on reporting. A key aspect of this role is to create more efficient and effective methods to generate insights on business performance, which is essential for success in this position. In this role, the Database Analyst Senior will provide subject matter expertise for the design, configuration, support, and maintenance of Microsoft SQL and Power BI data models, leveraging Databricks. The analyst will partner with teams across Insights to ensure data is available and functional for Power BI reports and ad-hoc analytics and research. Additionally, the analyst will develop a deep understanding of enterprise data systems and third-party data providers used by RSM to conduct analysis, monitor performance trends, and identify new sales and marketing opportunities. In collaboration with IT, the analyst will establish and maintain up-to-date documentation of data models and Power BI models to ensure continued operability and access to data. Participation in scheduled sprint meetings to plan and coordinate on stories in partnership with the Insights team is also a critical responsibility of this role.