Business Intelligence Analyst

Insight Global

New Bremen (OH)

Hybrid

USD 70,000 - 120,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical insurance

Vision insurance

401(k)

Paid maternity leave

Paid paternity leave

Disability insurance

Job summary

A recruitment agency is seeking a Business Intelligence Associate in New Bremen, OH. This full-time role requires a Bachelor's Degree and offers a salary range of $70,000 - $120,000 based on experience. The successful candidate will work with Power BI for report creation, analyze data for business needs, and support users. The position involves onsite work four days a week with one remote day, and benefits include medical and vision insurance, a 401(k), and paid leave.

Qualifications

0-4+ years of experience in business intelligence or data analysis.
Experience with SQL including basic queries to SQL server understanding.
Familiarity with creating custom DAX expressions/functions in Power BI.

Responsibilities

Create, test, implement, and maintain reports and ad-hoc queries.
Identify data needed to provide desired output.
Design and develop analytic and reporting solutions.
Assist with issue resolution and end user support.
Work with the business to analyze data and reporting needs.

Skills

Bachelor's Degree or higher

Hands on experience with PowerBI

Basic SQL queries

Good written and verbal skills

Experience with advanced visualization tools like SSRS, Tableau

Education

Bachelor's Degree

Tools

Power BI

SQL Server

SSIS

Tableau

SAP

Job description

This range is provided by Insight Global. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$70,000.00/yr - $120,000.00/yr

Direct message the job poster from Insight Global

Location: New Bremen, OH (4 days onsite/1 day remote)

Salary: 70K-120K based on experience

Relocation Assistance: Packages for renters and home owners including reimbursement/allowance for moving, packing, etc. - Temporary housing provided

Must Haves:

Bachelor's Degree or higher
0-4+ years of experience in the business intelligence, data analysis, etc. space
Hands on experience with PowerBI from coursework to professional experience
Experience with SQL including basic queries to SQL server understanding

Plusses:

Good written, verbal, analytical and interpersonal skills.
May expect experience with SAP system configuration and administration desired or with advanced visualization tools such as SSRS, Tableau or Power BI.
May develop custom and complex queries in SQL for reporting needs.
May need the understanding of Microsoft SQL Server and SSIS development.
Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.
May need good understanding of SQL familiarity with creating custom DAX expressions/functions.

Day to Day:

Report Creation - Create, test, implement and maintain reports and ad-hoc queries providing actionable information necessary to support business or customer requirement.
Identify data needed to provide the desired output.
Design and develop analytic and reporting solutions appropriate for Business Intelligence platform.
Fine tune reports and dashboards for optimal performance.
Assist with issue resolution and end user support.
Be efficient with BI reporting tools. Use the latest techniques in the industry to make the reporting process efficient which includes but is not limited to automation, speed, aesthetic designs and reducing complexity.
Business Analysis - Work with the business to analyze data and understand business and reporting needs.
Translate the requirement into technical specifications. Communicate status reports/important findings to management and decision-makers.
Work to achieve standardized business reports and data across the organization or for customers.
Perform data analysis on analytical and reporting requirements and recommend solutions for development.
Data Model / Extraction Integration - With guidance from BI Dev 2 and BI Dev 3, build, enhance, and support data modeling and extraction of data elements from multiple internal or external databases to meet business or customer reporting requirements.
Design and build data load process taking all dependencies into consideration.
Support data loading and extraction processes including ensuring optimal performance.
Recommend and develop new metrics that may benefit the company or customers.
Research, Training, and Self Study - Perform on going self-study of job-related issues.
Conduct and/or attend both formal and informal departmental and computer training.