Sr. Business Intelligence Developer
The Senior Business Intelligence Developer designs, modifies, develops and implements enterprise level reporting solutions and rich dashboards and supports ETL processes and tools. The Senior Business Intelligence Developer is responsible for performing 50% management duties and is responsible for data loading and manipulation to ensure that the data sources are efficiently and effectively loaded into the data warehouse and data is distributed to stakeholders through appropriate Business Intelligence tools. The Senior Business Intelligence Developer is required to provide weekly status reports to their supervisor in the Information Technology (IT) department.
ESSENTIAL POSITION FUNCTIONS:
• Develop and manage effective working relationships with other departments, groups and personnel with whom work must be coordinated or interfaced
• Define, review, and maintain Business Intelligence/Analytic programs for compliance with best practices, industry standards, enterprise architecture, requirements and processes
• Establish and enforce data warehousing standards to meet requirements and business needs
• Evaluate existing subject areas stored in the data warehouse and determine where data should be stored, while working closely with data architect regarding overall architecture
• Create and present training materials and department presentations for FLVS staff
• Develop in-depth understanding of underlying data, data structures, and business uses
• Hands-on assistance, peer coaching, and mentoring to other developers and/or direct reports
• Assist with recruiting, interviewing, and onboarding new hires
• Perform Build Master duties, schedule/manage code reviews, and prepare deployment packages
• Manage Team Foundation Server (TFS) and ensure policies are followed by other team members
• Responsible for following SDLC Agile/Scrum methodology
• Utilizing industry standards to enhance and maintain analysis services cubes(SSAS), SSIS/ETL, SSRS, PowerBi, and Azure within a Microsoft SQL Server environment
• Partner with Infrastructure to assist with conducting root cause analysis to resolve performance and production problems and data issues and data validation
• Provide ongoing maintenance and support of all business intelligence applications
• Provide a minimum of weekly status report updates for current projects
• Meet professional obligations through efficient work habits such as, meeting deadlines, honoring schedules, coordinating resources and meetings in an effective and timely manner, and demonstrate respect for others
• All work responsibilities are subject to having performance goals and/or targets established
(These essential functions are not to be construed as a complete statement of all duties performed. Employees will be required to perform other job related duties as required.)
To view a detailed job description and apply today follow the link provided.
MINIMUM REQUIREMENTS:
Education/Licensure/Certification:
• Bachelor’s Degree in Computer Science or Information Systems; or equivalent combination of education and relevant experience; Master’s degree preferred; or 5-7 years’ experience managing/training end users with internal systems, such as VSA Suite, PowerBI and LMS or 5-7 years’ experience analyzing data in an educational environment.
Experience:
• 5-7 years developing and implementing enterprise-scale BI tools/reports and dashboards
• 5-7 years MS-SQL writing stored procedures and database schema design
• 5-7 years with Microsoft BI Stack including SSAS, SSIS, and SSRS development
• Extensive experience with data warehouse technologies and implementations such as ETL processes, dimensional modeling cloud services, and reporting tools
• Experience in deploying reporting solutions, analytical tools and dashboards
• Experience working with predictive analytics, forecasting, and statistical software preferred
• Solid experience in analyzing query performance issues and modifying data structures or application code to remedy performance problems preferred
• Experience with Azure, Kimball Dimensional Modeling, Bus Matrix and DW Lifecycle preferred
• Experience with HR, Education, and/or Finance data preferred