Oracle Snowflake Data Analyst
New
100% remote work opportunity within the United States.Full-TimeMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Required Skills
- SQLOracleSnowflakeData modeling
Requirements
- Proven experience as a Data Analyst or similar role supporting data migration, analytics, or database modernization projects.
- Strong hands-on expertise in SQL, with extensive experience working in both Oracle and Snowflake environments.
- Ability to interpret and translate complex business logic embedded within SQL queries, stored procedures, and database structures.
- Strong understanding of relational database concepts, data modeling, and dependency mapping.
- Experience conducting data validation, reconciliation, testing, and troubleshooting activities during migration projects.
- Familiarity with Snowflake-specific features, SQL functions, performance optimization techniques, and development best practices.
- Experience with data blending and transformation tools such as Alteryx is considered an advantage.
- Excellent analytical, problem-solving, and critical-thinking skills with exceptional attention to detail.
- Strong communication and collaboration abilities, with experience working across cross-functional and geographically distributed teams.
- Ability to quickly learn new systems, adapt to changing priorities, and manage multiple tasks effectively.
Responsibilities
- Analyze existing Oracle SQL queries, stored procedures, and data models to understand business requirements and support migration activities.
- Quickly develop a deep understanding of database relationships, data dependencies, and business logic embedded within existing systems.
- Rewrite, optimize, and validate SQL queries for Snowflake while ensuring data accuracy, consistency, and performance.
- Design and execute comprehensive testing strategies to verify that migrated data and query outputs align with expected Oracle results.
- Collaborate with business users, analysts, and development teams to clarify requirements, resolve discrepancies, and improve data quality.
- Apply Snowflake best practices related to query optimization, performance tuning, and data validation.
- Support data transformation and reconciliation activities using data blending tools when applicable.
- Coordinate effectively with distributed and offshore teams to ensure timely delivery of project milestones and high-quality outcomes.
- Maintain clear documentation of migration processes, testing procedures, query transformations, and validation results.
View Full Description & ApplyYou'll be redirected to the employer's site
