JobRialto
Snowflake Data Analyst Job at JobRialto in Austin
JobRialto, Austin, TX, United States, 78746
Job Summary:
We are seeking a highly motivated Snowflake Data Analyst to join Client Charitable's Snowflake Team. This role involves data mapping, view development, and dashboard migration as part of the ongoing transition from an Oracle data warehouse to a Snowflake platform. The ideal candidate will have experience with Snowflake, Oracle, Tableau, and data transformation tools like Informatica, as well as proficiency in data modeling and dimensional modeling. The role will require collaboration within an Agile environment to ensure successful migration, model design, and support of BI-driven projects.
Key Responsibilities:
•Map data from source to target, designing dimensions (DIMs), facts, and views to support Snowflake platform migration.
•Develop views and ensure they are suitable for transformed data and dashboard usage in the Snowflake environment.
•Support testing and migration of existing Tableau dashboards to Snowflake.
•Assess current Oracle data warehouse and dashboard logic to understand business needs and ensure compatibility with the new platform.
•Analyze business logic, translate it to data flow diagrams, and provide data mapping output for downstream model development.
•Work within an Agile team to map, design, and implement new data sources in the Snowflake environment.
•Partner with BI teams to understand dashboard design needs and consumption requirements.
•Validate data queries and ensure high-quality data is delivered for downstream usage.
•Continuously assess and learn the nuances of the Snowflake data model to ensure proper integration and transformation.
•Communicate with business stakeholders to gather requirements and address concerns.
Required Qualifications:
•5+ years of experience in data warehousing with expertise in Oracle and Snowflake.
•Proficiency in Tableau for dashboard development and reporting.
•Strong SQL skills for database querying and data analysis.
•Experience with Informatica or similar ETL tools.
•Solid experience in data transformations and dimensional modeling (DIMs, facts, views).
•Proven ability to analyze, design, and implement data flows and data mapping for complex systems.
•Experience working in an Agile environment.
•Strong communication skills to interact with both technical teams and business stakeholders.
•Strong attention to detail and ability to learn quickly in a dynamic, evolving environment.
Preferred Qualifications:
•Experience with SnapLogic for data integration.
•Familiarity with advanced data modeling techniques for Snowflake or other cloud-based platforms.
•Experience with Tableau dashboard migration and optimization for cloud environments.
•Knowledge of data governance and quality assurance best practices.
Education: Bachelors Degree
We are seeking a highly motivated Snowflake Data Analyst to join Client Charitable's Snowflake Team. This role involves data mapping, view development, and dashboard migration as part of the ongoing transition from an Oracle data warehouse to a Snowflake platform. The ideal candidate will have experience with Snowflake, Oracle, Tableau, and data transformation tools like Informatica, as well as proficiency in data modeling and dimensional modeling. The role will require collaboration within an Agile environment to ensure successful migration, model design, and support of BI-driven projects.
Key Responsibilities:
•Map data from source to target, designing dimensions (DIMs), facts, and views to support Snowflake platform migration.
•Develop views and ensure they are suitable for transformed data and dashboard usage in the Snowflake environment.
•Support testing and migration of existing Tableau dashboards to Snowflake.
•Assess current Oracle data warehouse and dashboard logic to understand business needs and ensure compatibility with the new platform.
•Analyze business logic, translate it to data flow diagrams, and provide data mapping output for downstream model development.
•Work within an Agile team to map, design, and implement new data sources in the Snowflake environment.
•Partner with BI teams to understand dashboard design needs and consumption requirements.
•Validate data queries and ensure high-quality data is delivered for downstream usage.
•Continuously assess and learn the nuances of the Snowflake data model to ensure proper integration and transformation.
•Communicate with business stakeholders to gather requirements and address concerns.
Required Qualifications:
•5+ years of experience in data warehousing with expertise in Oracle and Snowflake.
•Proficiency in Tableau for dashboard development and reporting.
•Strong SQL skills for database querying and data analysis.
•Experience with Informatica or similar ETL tools.
•Solid experience in data transformations and dimensional modeling (DIMs, facts, views).
•Proven ability to analyze, design, and implement data flows and data mapping for complex systems.
•Experience working in an Agile environment.
•Strong communication skills to interact with both technical teams and business stakeholders.
•Strong attention to detail and ability to learn quickly in a dynamic, evolving environment.
Preferred Qualifications:
•Experience with SnapLogic for data integration.
•Familiarity with advanced data modeling techniques for Snowflake or other cloud-based platforms.
•Experience with Tableau dashboard migration and optimization for cloud environments.
•Knowledge of data governance and quality assurance best practices.
Education: Bachelors Degree