Data BI Analyst Co-op | Power BI, SQL & Azure Basics

gorbel; Town of Victor (NY); On-site; USD 32,000 - 34,000; Full time

Job summary

Gorbel is seeking a junior BI/data analytics assistant in the US. You will support creating BI reports in Power BI, perform SQL/Python data tasks, and help document business requirements under supervision.

You will learn to build basic data models and dashboards while collaborating with ERP/CRM systems to streamline reporting. You will gain exposure to Azure services such as ADF and Databricks, assist in data quality tasks, and help publish scheduled reports.

Qualifications

• Currently pursuing a Bachelor's degree in Computer Science, Information Technology, Business Analytics, or a related field.
• Basic understanding of BI tools such as Power BI or Tableau, with a willingness to learn and apply data visualization techniques.
• Introductory knowledge of SQL and relational database systems (RDBMS); coursework or projects involving SQL preferred.
• Exposure to programming languages such as Python or R through coursework or projects.
• Awareness of Web APIs and their role in data integration.
• Familiarity with data concepts such as data warehousing and ETL processes; exposure to tools like SSIS, Azure Data Factory, or similar is a plus.
• Basic understanding of development tools like Azure DevOps or similar platforms.
• Ability to work collaboratively in a team environment and manage tasks effectively under guidance.
• Strong communication skills to articulate ideas and learn from feedback.

Responsibilities

• Assist in creating and updating basic BI reports using Power BI and Excel under guidance.
• Learn to use SQL and Python for simple queries or scripts.
• Help document business requirements and contribute to building basic data models with supervision.
• Work with ERP systems, CRM tools, and business software to convert manual Excel reports into streamlined BI reports.
• Learn to develop simple dashboards and reports in Power BI and explore self-service data modeling concepts.
• Gain exposure to data integration processes and assist with data quality and governance tasks.
• Shadow team members to understand Microsoft Azure services (ADF, ADLS, Databricks) and participate in basic tasks.
• Assist in publishing and scheduling reports as per business needs.
• Perform basic data validation checks and help troubleshoot minor issues.
• Conduct ad-hoc analysis and prepare simple reports to identify trends under guidance.

Skills

Power BI

SQL

Python

Data Visualization

ETL

Azure Data Factory

Databricks

Excel

RDBMS

APIs

Education

Bachelor's degree in Computer Science or related field

Tools

Azure Data Factory

SSIS

Databricks

Job description

Gorbel is seeking a junior BI/data analytics assistant in the US. You will support creating BI reports in Power BI, perform SQL/Python data tasks, and help document business requirements under supervision.

You will learn to build basic data models and dashboards while collaborating with ERP/CRM systems to streamline reporting. You will gain exposure to Azure services such as ADF and Databricks, assist in data quality tasks, and help publish scheduled reports.