Data Analyst (Oracle, Snowflake, SQL) | TELECOMMUTE

Job TitleRoles are expected to extend past the original 3 months. As the SMART Data Warehouse remains the source of truth and data foundation for reporting and analytics across C&S, it is undergoing a full scale modernization. The particular role at onshore, is to continue the capital funding for a key data analyst on this modernization/migration team. The analyst will help us accelerate the migration of oracle based crystal reports/PowerBI reports and Talend jobs to Snowflake compatible. The analyst's role is very critical to the project completion as the last phase of the project includes the most important elements such as migrating medium to complex logics, reports and jobs for any restricted markets. Without this role, the modernization project will not likely see the full completion of reporting migration (meaning markets and business may not be able to pull reports) and those that are pulled may not have been tested for full validation leading to poor decisions being made by our business partners. Required 3+ years of experience having Strong SQL skills using Oracle and Snowflake Experience building complex CTE queries Knowledge of query optimization using explain plan and query profiling Strong BI and visualization experience working with PowerBI/Tableau and report development using SAP Crystal reports Prior experience working in a fast paced agile environment Experience performing unit testing and data equivalency testing