Business Intelligence Developer

Saybrook University; Chicago (IL); Remote; USD 90,000 - 100,000; Full time

Job summary

Saybrook University is seeking a Business Intelligence Developer to design and optimize Power BI dashboards and SQL reports. The ideal candidate will have strong analytical skills, hands-on experience with Power BI, and a solid understanding of data warehousing principles. This full-time role offers a competitive salary and generous benefits.

Benefits

Generous paid time-off

Medical and dental insurance

Life and disability insurance

Retirement plan with employer contribution

Tuition reimbursement

Qualifications

• 3+ years experience working with Power BI and SQL Server.
• Strong hands-on experience with Power BI, DAX, Power Query, and data model design.
• Knowledge of data extraction through API/web services is a plus.

Responsibilities

• Design, build, and optimize Power BI dashboards.
• Develop standardized reports using SQL Server Reporting Services.
• Collaborate with business analysts to determine BI requirements.

Skills

Analytical Thinking

Attention to Detail

Communication Skills

Data Accuracy

Power BI

T-SQL

Data Warehousing

Education

Bachelor's degree in Computer Science, Information System, Analytics, or related field

Tools

Power BI

T-SQL

SQL Server Reporting Services

Azure Data Factory

SSIS

DAX

Job description

Business Intelligence Developer page is loaded

Business Intelligence Developer

Apply locations Remote Chicago, IL time type Full time posted on Posted 3 Days Ago job requisition id R0011827

Job Description:

Title: Business Intelligence Developer

Department: IT Applications

Job Purpose

Position responsibilities include, but not limited to:

• Design, build, and optimize Power BI Dashboards
• Design & develop standardized reports using SQL Server Reporting Services, TSQL queries, and stored Procedures
• Create and Deploy Packages for ETL and ELT processes utilizing Azure Data Factory/SSIS
• Develop reusable semantic models and datasets using DAX and Power Query
• Create tables, stored procedures, views, functions, etc using SQL Server Management Studio
• Query Performance Tuning, Optimization and power BI security administration
• Maintain and support existing Data Warehouses/Marts
• Analyze data to improve processes and assist with defining key metrics
• Follow governance standards, resolve data issues, and promote best practices in report design and data usage
• Collaborate with business analysts, subject experts, and other team members to determine BI requirements and develop enterprise level solutions
• Support IT staff and business users in the development, usage and troubleshooting of database-driven applications
• Documentation for all implemented reports, processes, and procedures
• Respond quickly to bug fixes and enhancement requests

Required Qualifications:

Knowledge and Skills:

• Excellent analytical, written and verbal communication skills
• Strong analytical thinking, attention to detail, and commitment to data accuracy
• Strong hands-on experience with Power BI, including DAX, Power Query, and data model design
• Advanced proficiency in T-SQL with the ability to write and optimize complex queries
• Solid understanding of data warehousing principles, star schemas, and relational databases
• Work on multiple projects concurrently.
• Knowledge of data extraction through API/web services is a plus
• Knowledge of SQL BI Tools (SSRS, SSIS, SSAS)
• Familiarity with Power BI Service features: workspaces, scheduled refreshes, and pipelines

Education:

• Bachelor's degree in Computer Science, Information System, Analytics, or related field

Experience:

• 3+ years experience working with Power BI and SQL Server
• Data warehouse/ Data Mart development experience
• Python experience is a plus
• Experience in education industry a plus
• Experience with Microsoft Fabric a plus

Working Conditions:

• Ability to complete sedentary work for extended periods of time.
• Ability to operate office equipment including laptop, phone, etc.

Compensation & Benefits

This opportunity is budgeted at $90,000 - 100,000 base compensation. Additional compensation factors may impact total compensation. To learn more about our competitive benefits and additional rewards, including generous paid time-off, medical and dental insurance coverage, life and disability insurance, retirement plan with employer contribution, multiple flexible spending accounts, tuition reimbursement, click the link below.

https://www.tcsedsystem.edu/careers/

The Community Solution is an Equal Opportunity Employer.

About Us

The Community Solution Education System is an integrated, nonprofit system of colleges and universities that work collaboratively to advance institutional sustainability, student success, and community impact. Founded in 2009, The Community Solution has grown to encompass six distinct communities—The Chicago School,Pacific Oaks College& Children's School, The Colleges of Law,SaybrookUniversity, Kansas Health Science University-KansasCollege of Osteopathic Medicine, and University of Western States. United by a shared vision, we work together to build strategic partnerships and leverage economies of scale so institutions can focus on their mission—educating students.