Insight Global
SQL Data Analyst III
Insight Global, Palo Alto, California, United States, 94306
s: SQL, Tableau, Stakeholder Management
SQL Skills Assessed:
Understand basic syntax
Demonstrate experience on commonly used functions and provide thoughtful approach to corner cases.
Different types of JOINs
Filters, Groupings and Rankings
UNION versus UNION ALL
Aggregate functions
NULL values
Primary and Foreig
n keys in tables
Case statements
Think of ranking approach.
The difference between WHERE and HAVING
Make sure code is not overly lengthy
Good to have skills: Degree in a quantitative field, such as Applied Statistics, Mathematics, Finance, Statistics, Economics, Operations Research, or Information Systems
Experience with HR and Recruiting data
Outstanding organizational, time management, and communication skills
Strong presentation skills
Ability to deal with ambiguity; needs to understand and react quickly to changing priorities even when not all the information is available
Ex-Meta is preferred but not required.
Story Behind the Need -- Business Group & Key Projects: 3 Staff Leave Backfills - Data Analysts w/ 4+ Years
Compelling Story & Candidate Value Proposition: -
Typical Day in the Role: Build rich and dynamic dashboards using out-of-box features, customizations, and visualizations using Tableau and SQL
Explore and recommend emerging technologies and techniques to support/enhance BI landscape components
Participate in the ongoing development of the business intelligence and data solution ecosystem within the wider organization
Provide summary documentation on all analysis results to stakeholders, XFNs, or senior leadership
Uncover gaps in current insight tools, integrate new analytics and tracking solutions to surface data
Leverage tools such as SQL, Tableau, Workday, and Excel to drive analytics and enable client self-service on routine queries
Act as an internal consultant by understanding business needs, scoping data requests, synthesizing insights, and recommending solutions to key business partners
Apply expertise in quantitative analysis and the presentation of data to see beyond the numbers and help inform, influence, support, and execute our business decisions
Collaborate with cross-functional partners to execute and deliver scalable solutions, while influencing roadmap goals
How will performance be measured: -
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal. com.
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .Pay Range - $50-$60s: SQL, Tableau, Stakeholder Management
SQL Skills Assessed:
Understand basic syntax
Demonstrate experience on commonly used functions and provide thoughtful approach to corner cases.
Different types of JOINs
Filters, Groupings and Rankings
UNION versus UNION ALL
Aggregate functions
NULL values
Primary and Foreig
n keys in tables
Case statements
Think of ranking approach.
The difference between WHERE and HAVING
Make sure code is not overly lengthy
Good to have skills: Degree in a quantitative field, such as Applied Statistics, Mathematics, Finance, Statistics, Economics, Operations Research, or Information Systems
Experience with HR and Recruiting data
Outstanding organizational, time management, and communication skills
Strong presentation skills
Ability to deal with ambiguity; needs to understand and react quickly to changing priorities even when not all the information is available
Ex-Meta is preferred but not required.
Story Behind the Need -- Business Group & Key Projects: 3 Staff Leave Backfills - Data Analysts w/ 4+ Years
Compelling Story & Candidate Value Proposition: -
Typical Day in the Role: Build rich and dynamic dashboards using out-of-box features, customizations, and visualizations using Tableau and SQL
Explore and recommend emerging technologies and techniques to support/enhance BI landscape components
Participate in the ongoing development of the business intelligence and data solution ecosystem within the wider organization
Provide summary documentation on all analysis results to stakeholders, XFNs, or senior leadership
Uncover gaps in current insight tools, integrate new analytics and tracking solutions to surface data
Leverage tools such as SQL, Tableau, Workday, and Excel to drive analytics and enable client self-service on routine queries
Act as an internal consultant by understanding business needs, scoping data requests, synthesizing insights, and recommending solutions to key business partners
Apply expertise in quantitative analysis and the presentation of data to see beyond the numbers and help inform, influence, support, and execute our business decisions
Collaborate with cross-functional partners to execute and deliver scalable solutions, while influencing roadmap goals
How will performance be measured: -
SQL Skills Assessed:
Understand basic syntax
Demonstrate experience on commonly used functions and provide thoughtful approach to corner cases.
Different types of JOINs
Filters, Groupings and Rankings
UNION versus UNION ALL
Aggregate functions
NULL values
Primary and Foreig
n keys in tables
Case statements
Think of ranking approach.
The difference between WHERE and HAVING
Make sure code is not overly lengthy
Good to have skills: Degree in a quantitative field, such as Applied Statistics, Mathematics, Finance, Statistics, Economics, Operations Research, or Information Systems
Experience with HR and Recruiting data
Outstanding organizational, time management, and communication skills
Strong presentation skills
Ability to deal with ambiguity; needs to understand and react quickly to changing priorities even when not all the information is available
Ex-Meta is preferred but not required.
Story Behind the Need -- Business Group & Key Projects: 3 Staff Leave Backfills - Data Analysts w/ 4+ Years
Compelling Story & Candidate Value Proposition: -
Typical Day in the Role: Build rich and dynamic dashboards using out-of-box features, customizations, and visualizations using Tableau and SQL
Explore and recommend emerging technologies and techniques to support/enhance BI landscape components
Participate in the ongoing development of the business intelligence and data solution ecosystem within the wider organization
Provide summary documentation on all analysis results to stakeholders, XFNs, or senior leadership
Uncover gaps in current insight tools, integrate new analytics and tracking solutions to surface data
Leverage tools such as SQL, Tableau, Workday, and Excel to drive analytics and enable client self-service on routine queries
Act as an internal consultant by understanding business needs, scoping data requests, synthesizing insights, and recommending solutions to key business partners
Apply expertise in quantitative analysis and the presentation of data to see beyond the numbers and help inform, influence, support, and execute our business decisions
Collaborate with cross-functional partners to execute and deliver scalable solutions, while influencing roadmap goals
How will performance be measured: -
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal. com.
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .Pay Range - $50-$60s: SQL, Tableau, Stakeholder Management
SQL Skills Assessed:
Understand basic syntax
Demonstrate experience on commonly used functions and provide thoughtful approach to corner cases.
Different types of JOINs
Filters, Groupings and Rankings
UNION versus UNION ALL
Aggregate functions
NULL values
Primary and Foreig
n keys in tables
Case statements
Think of ranking approach.
The difference between WHERE and HAVING
Make sure code is not overly lengthy
Good to have skills: Degree in a quantitative field, such as Applied Statistics, Mathematics, Finance, Statistics, Economics, Operations Research, or Information Systems
Experience with HR and Recruiting data
Outstanding organizational, time management, and communication skills
Strong presentation skills
Ability to deal with ambiguity; needs to understand and react quickly to changing priorities even when not all the information is available
Ex-Meta is preferred but not required.
Story Behind the Need -- Business Group & Key Projects: 3 Staff Leave Backfills - Data Analysts w/ 4+ Years
Compelling Story & Candidate Value Proposition: -
Typical Day in the Role: Build rich and dynamic dashboards using out-of-box features, customizations, and visualizations using Tableau and SQL
Explore and recommend emerging technologies and techniques to support/enhance BI landscape components
Participate in the ongoing development of the business intelligence and data solution ecosystem within the wider organization
Provide summary documentation on all analysis results to stakeholders, XFNs, or senior leadership
Uncover gaps in current insight tools, integrate new analytics and tracking solutions to surface data
Leverage tools such as SQL, Tableau, Workday, and Excel to drive analytics and enable client self-service on routine queries
Act as an internal consultant by understanding business needs, scoping data requests, synthesizing insights, and recommending solutions to key business partners
Apply expertise in quantitative analysis and the presentation of data to see beyond the numbers and help inform, influence, support, and execute our business decisions
Collaborate with cross-functional partners to execute and deliver scalable solutions, while influencing roadmap goals
How will performance be measured: -