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:
Bachelors 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.
Community Solution is an Equal Opportunity Employer.