BA - Financial Securities

Resourcesys - Carrollton, TX

Full-time

Carrollton, TX

Professional, Scientific, and Technical Services

About the position

The BA - Financial Securities position involves validating business logic during the migration of financial securities data from an Oracle database to a Snowflake environment. The role requires a detail-oriented and analytical professional who ensures data integrity and accuracy throughout the migration process, focusing on financial data structures and business rules.

Responsibilities

• Verify that all business rules, calculations, and data transformations are correctly applied in the Snowflake environment.
• Ensure consistency between Oracle and Snowflake databases, including matching data formats, precision, and financial metrics.
• Identify and troubleshoot discrepancies in securities data between Oracle and Snowflake.
• Validate data completeness, accuracy, and compliance with regulatory and business requirements.
• Validate test cases to confirm the migration aligns with business logic requirements.
• Develop SQL scripts to validate data correctness and transformations.
• Analyze & validate test results, including issues identified and recommendations for resolution.
• Collaborate with data engineers, analysts, and business stakeholders to understand business logic requirements.
• Work closely with IT teams to align expectations and resolve issues promptly.
• Maintain detailed documentation of validation processes, test results, and data issues encountered during the migration.

Requirements

• Bachelor's degree in finance, Computer Science, Data Analytics, or a related field.
• Understanding of financial securities, including equities, bonds, and derivatives.
• 3+ years of experience with financial data, data migrations, or database management.
• Strong knowledge of Oracle and Snowflake databases.
• Proficiency in SQL and experience with query optimization.
• Excellent analytical and problem-solving skills with high attention to detail.
• Strong communication skills and ability to collaborate effectively with cross-functional teams.

Nice-to-haves

• Experience with Oracle, Snowflake, ETL tools and processes, Oracle to Snowflake Migration.
• Knowledge of data governance, compliance, and regulatory frameworks in financial markets.
• Familiarity with Python or other scripting languages for data validation.