Senior Data Scientist

Solu is seeking a Senior Data Scientist to support a regulatory compliance risk assessment initiative for a large financial services organization. This role will focus on building data pipelines, migrating data from a legacy solution to a new platform, and implementing calculations, scoring methodologies, and business logic using Python and SQL.
The ideal candidate has strong hands-on experience with Python, SQL, ELT processes, and data mapping, along with experience working with SQL stored procedures. The role involves partnering with business and technical stakeholders to understand requirements, map legacy data models to a new solution, and perform testing and validation.
Candidates must be comfortable handling sensitive data within a highly regulated environment with strict technology controls and restrictions on development, data storage, and approved solutions. Banking or financial services experience is helpful but not required.
Responsibilities
Build data pipelines to migrate information from legacy solutions into a new platform and data model.
Use Python to implement calculations, formulas, scoring methodologies, and other business logic supporting the compliance risk assessment.
Write and execute SQL queries to retrieve, analyze, and validate data.
Develop, modify, and work with SQL stored procedures to support data processing and solution requirements.
Perform data mapping between legacy and target data models, ensuring data is accurately transformed and aligned with business requirements.
Collaborate with business and technical stakeholders to gather requirements, clarify business logic, and translate requirements into technical solutions.
Conduct solution testing and user acceptance testing (UAT), validating requirements, data transformations, calculations, and scoring results.
Document testing results, communicate findings, and explain testing processes and outcomes to stakeholders as needed.
Support the development of dashboards and visualizations to present risk assessment scoring results, as needed.
Identify and resolve data quality issues, discrepancies, and implementation challenges throughout the migration and testing process.
Work independently while remaining available to collaborate with stakeholders and support requirements discussions and testing activities.
Follow established technology, data handling, and security controls when working with sensitive information.
Required Qualifications
Python: Hands-on experience building solution logic, automating calculations, and supporting data transformation using Python.
SQL: Strong SQL querying skills, including experience developing or working with SQL stored procedures.
ELT and Data Pipelines: Experience developing or supporting ELT processes and data pipelines to move and transform data.
Data Mapping and Migration: Experience mapping data between legacy and target data models and supporting data migration to new solutions.
Regulated Environment: Experience handling sensitive data within a regulated industry or a tightly controlled technology environment, including adherence to data security, storage, development, and solution restrictions.
Requirements and Testing: Ability to translate business requirements into technical logic and validate data, calculations, and solution functionality through testing and UAT.
Stakeholder Collaboration: Ability to work independently while communicating effectively with business and technical stakeholders to clarify requirements, discuss testing, and resolve issues.
Data Visualization: Basic-to-intermediate Tableau experience is sufficient. Experience with Alteryx or Power BI may also be considered.
Preferred Qualifications
Banking or financial services experience.
Experience supporting regulatory compliance, compliance risk assessments, financial reporting, or related initiatives.
Experience working in highly controlled technology environments with strict data handling and development requirements.
Experience developing Tableau dashboards to present scoring results, analytics, or other business data.
Familiarity with Alteryx and/or Power BI.
Experience migrating legacy data solutions and data models to new platforms.

Work arrangement
Yes