Business Intelligence Developer

Job Description

Teacher/Professional - District Office - BI Developer Job Number 0000760638 Start Date Open Date 12/02/2024 Closing Date ROLE AND PURPOSE: Transform complex student information system data into Power BI reports that drive strategic decision-making across the district. Continuously improve data quality and processes. Provide excellent customer service to other departments. The ideal candidate will combine strong technical skills with customer service skills to deliver high-quality data results and reporting solutions. QUALIFICATIONS: Education/Certification: Bachelor's degree in Computer Science, Information Systems, or a related field from an accredited institution. Experience: 3-5 years of experience in T-SQL programming. 1-3 years of experience in developing and maintaining Power BI reports. SPECIAL KNOWLEDGE/SKILLS: Experience with Microsoft SQL Server and IBM DB2 databases Experience with SSRS and SSIS Frontline ERP/SIS software (Frontline TEAMS, formerly Prologic) Database tools including SQL Server Management Studio and DB Visualizer Strong analytical and problem-solving abilities. Ability to translate business requirements into technical solutions. Strong attention to detail and data accuracy. MAJOR RESPONSIBILITIES AND DUTIES: Design, develop, and maintain BI reports using Microsoft Power BI. Test, optimize, and refactor existing Power BI reports to improve design, functionality, and performance. Create and maintain documentation to help users navigate through Power BI reports. Automate existing processes and systems, when possible, to improve efficiency. Write T-SQL code to prepare data for analysis, reporting, and various data needs. Cleanse and validate data to guarantee data quality. Identify analysis and reporting opportunities by exploring the data. Collaborate with other departments to understand their data analysis needs and translate them into data reports. Implement appropriate data access controls that comply with data security and privacy regulations. Provide excellent customer service by answering questions, implementing new feature requests, and resolving data and technical issues. Contribute to team efforts by accomplishing related results as assigned. Create and maintain SQL Server Jobs. Maintain technology infrastructure and Task Scheduler processes. I. WORKING CONDITIONS: MENTAL DEMANDS / PHYSICAL DEMANDS / ENVIRONMENTAL FACTORS: Tools/Equipment Used: Standard office equipment, including computers and peripherals; standard instructional equipment. Posture: Moderate standing; occasional kneeling, squatting, bending, and stooping Motion: Moderate walking Lifting: Regular light lifting and carrying (less than 15 pounds) Environment: Work inside and outside (exposure to sun, heat, cold, and inclement weather); exposure to noise Mental Demands: Work with frequent interruptions; maintain emotional control under stress, with frequent interruptions. #J-18808-Ljbffr