Data Analyst 1

We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You’ll find an environment that inspires and empowers you to thrive both personally and professionally. There’s no one like you and that’s why there’s nowhere like RSM.

Join our Talent Analytics team within the Talent Technology Center of Excellence. Here, you will be instrumental in development, automation, and compilation of data. As a Data Analyst, you will not only handle technical analysis and data modeling but also shape the future of our analytics capabilities by contributing to the complete overhaul of our HR Data store.

What You Will Do

• Leveraging HR systems and database tools, to clean and prepare historical data for a system agnostic data store.
• Assisting with the design and implementation of efficient data models to support various applications and analytics.
• Strategic Project Management: Designing, estimating, and personally executing an analysis plan based on requirements you gather from key stakeholders. In this role you will have the opportunity to contribute to rebuilding a data store from the ground up which will facilitate analysis to achieve business outcomes.
• Collaborate to build and optimize ETL pipelines to extract, transform, and load data from various sources into our data warehouse.
• Work with the team in developing business and enterprise architecture strategy, providing insights, recommendations, and best practices to align technology solutions with business goals and objectives.

Responsibilities

• Using HR systems and database tools to develop and deliver ad hoc, recurring, and on-demand / self-service analysis and data solutions.
• Independently or with a team, exploring and implementing new ways to take on data or technical challenges.
• Designing, estimating, and personally executing an analysis plan based on a high-level functional issue description or business question.
• Describing your own analysis and the insights you draw from it to others in HR or the business.
• Develop, analyze, and evaluate data to create and maintain business intelligence frameworks
• Recommending business process or system improvements to reporting capabilities and influence system owners to incorporate changes.
• Peer reviewing SQL code/reporting and performing data validation as related to data acquisition for analytic purposes.
• Ensuring products are delivered that are audience appropriate, adhering to HR standards for data sharing and meeting the client’s need accurately.

Education

• Bachelor’s degree in Computer Science, Mathematics, Management Information Systems, Data Science, Statistics, Engineering or similar from an accredited college/university (Required)

Technical/Soft Skills

Required:

• Minimum of 3 years using data transformation tools such as Alteryx
• Minimum of 3 years in using SQL to query large datasets.
• Minimum of 3 years of solutioning/maintaining ETL pipelines

Preferred:

• Experience using RStudio or Python for automation or data processing such as statistical modeling, machine learning, or data mining.
• Strong problem-solving ability which will be leveraged to identify data issues, possible solutions, and implementing logic to apply these corrections in the transformation process.
• Experience with the Microsoft Power Platform technologies, including Power Apps, Power Automate, Power BI, Azure Functions, and other relevant technologies.
• The ability to establish and enforce governance processes, coding standards, and best practices is expected.
• Experience working with Data Modeling tools like Toad Data Modeler, Erwin, ERBuilder or similar tools.
• Excellent communication, relationship skills and a strong team player.
• An understanding of core Human Resources functions, typical workforce management processes and related data preferred.
• Experience in HR related systems: Workday, Cornerstone, Qualtrics, VNDLY, ServiceNow.
• Experience defining, structuring, and documenting data transformation processes.

At RSM, we offer a competitive benefits and compensation package for all our people. We offer flexibility in your schedule, empowering you to balance life’s demands, while also maintaining your ability to serve clients. Learn more about our total rewards at https://rsmus.com/careers/india.html.

RSM does not tolerate discrimination and/or harassment based on race; colour; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender (including gender identity and/or gender expression); sexual orientation; HIV Status; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the in the Indian Armed Forces; pre-disposing genetic characteristics or any other characteristic protected under applicable provincial employment legislation. 

Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership. RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please send us an email at [email protected].