Business Intelligence Developer

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.