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.

#J-18808-Ljbffr