Data Analyst

ABOUT THIS ROLE

As a Data Analyst in Insight Global’s Professional Services division you will analyze data, interpret it and make recommendations to business owners across the division. You will work with all roles in our Professional Services division to understand business challenges and put in place data systems, processes and analysis techniques and tools to provide insight to enable business owners to make informed decisions.

WHAT YOU’LL DO

Maintain and monitor data sources and systems by addressing errors and monitoring performance

Interpret data trends and patterns as they relate to and impact the business

Prepare reports to assess business performance

Collaborate with business owners to gather data and reporting requirements

Collect, organize and interpret various types of data as well as present this data in a way that is easy to understand

Creating reports for internal teams, external clients and/or stakeholders

Establish KPIs to measure the effectiveness of business decisions

Structuring large data sets to find usable information

Identify patterns and trends in data sets

Define new data collection and analysis processes

Create and implement metadata standards

WHAT YOU’LL NEED TO SUCCEED

Basic understanding of SQL with the ability to write queries to extract, transform, and analyze data across multiple tables

Familiarity with joins, filters, aggregations, and simple window function

Proficient in pivot tables, advanced formulas (XLOOKUP, IF, SUMIFS, etc.), and data cleansing

Experience using Power Query for transforming and loading data

Experience with Power BI for building visualizations and interactive dashboards

Familiarity with Power BI Dataflows, Power Query, and data modeling

Experience in data modeling, dashboard creation, DAX query creation

Experience with Airtable database design, automation, integrations and formulas

Proactive approach to problem solving and an ability to resolve issues

Ability to understand how data can help solve complex business problems

Demonstrated experience in handling large data sets and relational databases

Experience with data visualization tools to understand and communicate insights

Analytical and problem-solving skills

Bachelor’s degree