
Business Intelligence Developer at The Chicago School. Location Information: Remote - Any State, United States. . 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.. The Community Solution offers a generous compensation and benefits package, as well as the opportunity to work for a leader in the field of education. 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.. .