Senior Analytics Engineer (Financial Services)
Job Summary
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 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.
RSM is seeking a Temporary Supervisor - Analytics Engineer to support large-scale Risk Consulting engagements within the Financial Services and Global Banking sectors. This role is ideal for a hands-on data engineering professional with experience building data acquisition regulatory reporting and analytics solutions in highly regulated environments.
Working alongside senior analytics and technology leaders you will help design and build foundational data structures that support regulatory reporting risk analytics reconciliation and executive reporting. The successful candidate will bring strong technical expertise a passion for solving complex data challenges and experience working within banking risk compliance or regulatory reporting environments.
- Build and maintain data acquisition ingestion and staging processes for large-scale regulatory reporting and analytics programs.
- Develop and support an immutable historical data repository that enables accurate recreation of prior reporting periods and regulatory submissions.
- Design and enhance canonical data models reference data structures and business classification frameworks.
- Build and maintain exception management repositories to support issue tracking remediation and regulatory reporting transparency.
- Implement data quality controls validation routines reconciliations and audit-ready documentation.
- Perform complex data analysis root cause investigations and issue remediation across multiple source systems.
- Design and maintain data lineage documentation and control evidence to support audit and regulatory reviews.
- Collaborate with business risk compliance audit and technology stakeholders throughout the project lifecycle.
- Support system integration testing (SIT) user acceptance testing (UAT) implementation activities and production support.
- Partner with reporting and visualization teams to develop datasets supporting Power BI and management reporting.
- 6 years of experience in Analytics Engineering Data Engineering Data Warehousing or a related discipline.
- Advanced SQL skills including complex transformations reconciliations optimization and performance tuning.
- Experience designing and developing ETL/ELT solutions across multiple source systems.
- Experience with dimensional data modeling canonical data models and historical snapshot architectures.
- Experience working within Financial Services Banking Risk Management Regulatory Reporting Compliance or Audit environments.
- Strong understanding of data quality controls reconciliations and regulatory reporting requirements.
- Proven ability to analyze complex data issues and develop sustainable technical solutions.
- Excellent communication and stakeholder management skills.
- Experience supporting BCBS 239 enterprise risk programs risk data aggregation or regulatory reporting initiatives.
- Experience building historical immutable or append-only data repositories.
- Familiarity with data lineage metadata management and governance platforms such as Collibra.
- Experience supporting Power BI reporting and analytics solutions.
- Experience with cloud and modern data platforms including Azure Databricks Snowflake Synapse Fabric Informatica Talend Alteryx or Teradata.
Candidates may come from a variety of technical backgrounds. Experience with modern data and analytics platforms is valued; however strong fundamentals in SQL data modeling reconciliation and regulated data environments are the most critical qualifications.
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 applicants will receive consideration for employment as RSM does not tolerate discrimination and/or harassment based on race; color; creed; sincerely held religious beliefs practices or observances; sex (including pregnancy or disabilities related to nursing); gender; 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 US uniformed service; US Military/Veteran status; pre-disposing genetic characteristics or any other characteristic protected under applicable federal state or local law.
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 call us at or send us an email at .
RSM does not intend to hire entry level candidates who will require sponsorship now OR in the future (i.e. F-1 visa holders). If you are a recent U.S. college / university graduate possessing 1-2 years of progressive and relevant work experience in a same or similar role to the one for which you are applying excluding internships you may be eligible for hire as an experienced associate.
RSM will consider for employment qualified applicants with arrest or conviction records. For those living in California or applying to a position in California please click here for additional information.
At RSM an employees pay at any point in their career is intended to reflect their experiences performance and skills for their current role. The salary range (or starting rate for interns and associates) for this role represents numerous factors considered in the hiring decisions including but not limited to education skills work experience certifications location etc. As such pay for the successful candidate(s) could fall anywhere within the stated range.
Compensation Range: $54 - $80 per hourRequired Experience:
Senior IC
About Company
RSM US LLP is the leading U.S. provider of assurance, tax and consulting services focused on the middle market.