Microsoft Reporting and Data Analyst 1
Microsoft Reporting and Data Analyst 1
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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. Youll find an environment that inspires and empowers you to thrive both personally and professionally. Theres no one like you and thats why theres nowhere like RSM.
Role Overview:
This role will be responsible for the automation of data pipelines from multiple sources for the development and maintenance of dashboards for tracking Microsoft cloud metrics. This role merges data engineering and business intelligence to provide timely insights into partnership performance.
Key Responsibilities:
- Automate data extraction from Partner Center into RSMs repository ensuring regular refreshes and minimal manual steps.
- Design and maintain an internal Power BI dashboard visualizing key metrics with interactive features.
- Integrate data from multiple sources for comprehensive reporting.
- Analyze trends generate actionable insights and support ad-hoc queries.
- Ensure data quality by monitoring accuracy and troubleshooting issues.
- Continuously improve pipelines and reports based on feedback.
- Collaborate with US-based teams across time zones for unified reporting.
- Document processes and train users.
- Manage data security and access adhering to governance standards.
Qualifications:
- Bachelors degree in a relevant field; 5 years in data engineering/data analysis.
- Expertise in SQL ETL tools (Azure Data Factory/SSIS) Power BI (data modeling DAX report design).
- Analytical skills for metrics validation and trend identification with large datasets.
- Ability to work independently and prioritize projects.
- Strong problem-solving abilities with attention to detail.
- High-level written and verbal communication skills.
- Ability to work collaboratively with various stakeholders especially in global teams.
- Knowledge of Microsoft Partner Center is a plus.
- Preferred certifications: Microsoft Power BI Data Analyst Associate and/or Azure Data Engineer.
At RSM we offer a competitive benefits and compensation package for all our offer flexibility in your schedule empowering you to balance lifes demands while also maintaining your ability to serve more about our total rewards at
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 Indian Armed Forces; Indian Armed Forces Veterans and Indian Armed Forces Personnel status; 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/ 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 .
Required Experience:
IC
Employment Type
Full-Time
