Insight Global's client is looking for a SQL Analyst to join their team that is working on a large SAP transformation project. Part of the project is taking the data out of central finance and use the tool that breaks down all the information and does a cube style view. As they build the tool itself, they take a lot of the information into their data lake, snowflake. They have the engineering side of the house and then the data analytics side which is how they visualize the data. The bottle neck is on the data engineering side. They need a SQL Analyst to alleviate the pressure, someone who can make things happen within analysis in snowflake and use snowflake queries to build Power BI dashboards. We are looking for a hands-on data analyst with advanced SQL expertise in Snowflake to build robust data transformations that drive business insights. The role focuses on tying out metrics, creating smart aggregations, and enabling drill-downs to actionable details—all using SQL as the primary tool. This role is more towards data cleansing, wrangling rather than development. Almost all the data already sits in the data lake snowflake so it is more a matter of doing the right transformations and saving back the data in a new table.Must Haves :5 years of SQL Development- experience in building CTE's, not just left joins. Someone who is able to prepare data before joining the tables.Snowflake experienceExpert in SQL for Snowflake : CTEs, window functions, pivots, dynamic SQL, performance tuningBuild analytic data models and transformations for KPIs, financial tie-outs, and root cause analysisCreate modular, reusable SQL logic to support scalable reportingEnsure data accuracy across sources and metricsFollow best practices on code version control and adapt to this company’s code development life cycle
#J-18808-Ljbffr