RSM US LLP
RSM US LLP
RSM US LLP is the U.S. member firm of RSM International, serving primarily middle market businesses through assurance, tax, and consulting services. Its work combines sector knowledge with practical business advice, helping clients address complex operational and strategic challenges, strengthen performance, and pursue sustainable growth.

Senior Analytics Engineer – Financial Services (Onsite, New York)

Build regulatory reporting, risk data, and analytics solutions for RSM’s financial-services clients. Create governed data models, reconciliations, lineage documentation, and Power BI-ready datasets.

Description

  • Develop and maintain data acquisition, ingestion, and staging workflows for large-scale regulatory reporting and analytics initiatives.
  • Maintain an immutable historical data repository to reproduce earlier reporting periods and regulatory submissions.
  • Create and refine canonical data models, reference data structures, and business classification frameworks.
  • Develop exception management repositories that support issue tracking, remediation, and transparent regulatory reporting.
  • Establish data quality controls, validation procedures, reconciliations, and documentation prepared for audit review.
  • Investigate complex data problems, identify root causes, and implement remediation across multiple source systems.
  • Maintain data lineage records and control evidence for audit and regulatory examinations.
  • Work with business, risk, compliance, audit, and technology stakeholders across the project lifecycle.
  • Assist with integration testing, user acceptance testing, implementation work, and production support.
  • Collaborate with reporting and visualization teams to create datasets for Power BI and management reporting.

Requirements

  • At least six years of experience in analytics engineering, data engineering, data warehousing, or a related field.
  • Advanced SQL expertise, including complex transformations, reconciliations, optimization, and performance tuning.
  • Professional experience designing and developing ETL or ELT solutions across multiple source systems.
  • Experience with dimensional modeling, canonical data models, and historical snapshot architectures.
  • Background in financial services, banking, risk management, regulatory reporting, compliance, or audit.
  • Strong knowledge of data quality controls, reconciliations, and regulatory reporting requirements.
  • Ability to investigate complex data issues and deliver durable technical solutions.
  • Strong communication and stakeholder management capabilities.
  • Experience with BCBS 239, enterprise risk programs, risk data aggregation, or regulatory reporting initiatives.
  • Experience creating 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 such as Azure, Databricks, Snowflake, Synapse, Fabric, Informatica, Talend, Alteryx, or Teradata.

Benefits

  • Competitive compensation and benefits package.
  • Flexible working schedule.

Related Jobs