Senior Analytics Engineer, Financial Services

RSM US LLP

. Build and maintain data acquisition, ingestion, and staging processes for large-scale regulatory reporting and analytics programs .

Posted 9/18/2026full-timeNew York City • Florida • United StatesSenior💰 $54 - $80 per hourWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Data Engineering and Analytics, with a strong focus on building and maintaining data acquisition processes, data quality controls, and regulatory reporting frameworks. Proficient in SQL, ETL/ELT solutions, and cloud data platforms, ensuring compliance and effective stakeholder collaboration.

Highest-signal resume keywords

Advanced SQL SkillsETL/ELT Solution DevelopmentData Quality ControlsFinancial Services ExperiencePower BI Reporting Support

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data EngineeringData WarehousingDimensional Data ModelingCanonical Data ModelsData AnalysisData Lineage DocumentationComplex TransformationsReconciliationsIssue RemediationImmutable Data Repositories

Soft Skills

Excellent CommunicationStakeholder Management

Tools & Technologies

Power BIAzureDatabricksSnowflakeSynapseFabricInformaticaTalendAlteryxTeradata

Industry Keywords

Financial ServicesBankingRisk ManagementRegulatory ReportingComplianceAuditBCBS 239Risk Data Aggregation

Tech Stack

Tools & technologies

AzureCloudETLInformaticaSQL

About the role

Key responsibilities & impact

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 for recreating 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 for 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 for audit and regulatory reviews
Collaborate with business, risk, compliance, audit, and technology stakeholders throughout the project lifecycle
Support system integration testing, user acceptance testing, implementation activities, and production support
Partner with reporting and visualization teams to develop datasets supporting Power BI and management reporting

Requirements

What you’ll need

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
RSM does not intend to hire entry level candidates who will require sponsorship now or in the future

Benefits

Comp & perks

Competitive benefits and compensation package
Flexibility in your schedule
Reasonable accommodation for people with disabilities