Job Title: Data Analyst
Location: Remote
Join our team as a Data Analyst! We’re looking for a detail-oriented individual with a strong analytical mindset to assist in our transition from Oracle to Snowflake. You’ll need a solid understanding of SQL and data structures, and the ability to quickly comprehend complex business logic and database relationships.
Key Responsibilities:
- Understand and analyze existing Oracle SQL queries, stored procedures, and data models.
- Learn and comprehend database relationships and dependencies for accurate query translation.
- Rewrite and optimize queries for Snowflake, ensuring data accuracy and performance.
- Conduct thorough testing and validation to ensure query results in Snowflake match expected outputs from Oracle.
- Collaborate with business users and developers to clarify requirements and resolve data discrepancies.
- Utilize data blending tools like Alteryx (if applicable) to support data transformation and validation.
Skills Required:
- Strong SQL expertise, with hands-on experience in both Oracle and Snowflake.
- Ability to interpret complex business logic embedded in SQL queries and stored procedures.
- Quick learner with the ability to understand database relationships and dependencies.
- Experience with data validation, testing methodologies, and troubleshooting discrepancies.
- Familiarity with Snowflake-specific SQL functions, performance tuning, and best practices.
- Experience with data blending tools like Alteryx is a plus.
- Strong analytical and problem-solving skills, with keen attention to detail.
- Excellent communication and collaboration skills to work with cross-functional teams.
About SSi People:
With over 26 years of industry experience, SSi People has built its reputation and expertise on putting people first. Everything we do works toward delivering an exceptional experience for our consultants, our clients, and our internal team. Through a genuine commitment to people in everything we do. We have developed refined processes and a stellar internal team to deliver talent quickly. More importantly, we focus on building long-term relationships, not transactions. Putting people first is just what we do well.
By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from SSi People and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here: SSi People Privacy Policy