Position: BA Financial Securities
Location: Carrollton TX Onsite
Type of hire: Full time
Job Description: Data Migration Business Logic Validator (Financial Securities)
Position Overview:
We are seeking a detailoriented and analytical professional to validate business logic during the migration of financial securities data from an Oracle database to a Snowflake environment. The ideal candidate will have a solid understanding of both financial data structures and business rules ensuring data integrity and accuracy throughout the migration process.
Key Responsibilities:
Business Logic Validation:
- 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.
- Understanding of financial securities including equities bonds and derivatives trade life cycle
Data Integrity Checks:
- Identify and troubleshoot discrepancies in securities data between Oracle and Snowflake.
- Validate data completeness accuracy and compliance with regulatory and business requirements.
- Testing & Reporting:
- 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.
Collaboration & Communication:
- 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.
- Documentation:
- Maintain detailed documentation of validation processes test results and data issues encountered during the migration.
Qualifications:
- Bachelors 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 problemsolving skills with high attention to detail.
- Strong communication skills and ability to collaborate effectively with crossfunctional teams.
Preferred Skills:
- 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.