Senior Business Intelligence Developer Job in Lake Mary 32746, Florida Us
Senior Business Intelligence Developer
Job ID: 17982
Position Description:
SunGard Public Sector’s local government applications have been successfully delivering advanced, fully integrated solutions to public sector organizations for nearly thirty years. Our government information technologies address the business requirements of cities and counties, public and private utilities, public safety and justice agencies, and not-for-profit organizataions.
Dedicated to serving municipalities worldwide, SunGard Public Sector’s market-leading products provide back-office integration, address wireless computing requirements of field personnel, and support the end-to-end delivery of electronic access to citizens and businesses.
For public safety justice agencies, SunGard Public Sector solutions offer system-wide integration and interoperability for computer-aided dispatch, records management, mobile computing, and jails management.
The Business Intelligence (BI) Developer position performs a key role to deliver Business Intelligence across the entire SunGard Public Sector Local Government application spectrum. The position is directly responsible in building and maintaining Business Intelligence environments which provide a complete BI solution architecture. The primary focus of this role is the ongoing and future development of data modeling, dashboard development and report generation utilizing a variety of BI toolsets. These toolsets include: IBM Cognos 10, Microsoft SQL Server Reporting Services (SSRS) and SAP Business Objects. This requires the candidate to have hands on, in depth experience and expertise with one of these tools sets and a high working knowledge of one or more of the other.
Essential Duties and Responsibilities:
• Design and develop metadata models; integrated reports, scorecards and dashboards
• Gather report requirements from internal product management
• Execute, migrate and automate reports to support day to day requests
• Work closely with Local Government application development teams to ensure reporting requests can be supported by the underlying data source
• Perform analysis to investigate and troubleshoot data inconsistencies and data integrity issues when necessary
• Install, configure, deploy and tune Business Intelligence tools and environment
• Develop BI training, documentation, and help desk capabilities
• Work autonomously and cooperatively within a fast-paced environment and balance priorities to best meet the demands of multiple projects
• Participate in the complete implementation process and strategies for the development of core BI solutions
• Mentor other team members on new and existing technologies and help guide the Business Intelligence development process.
• Work collaboratively with technical staff, and business experts to develop solutions to meet or exceed business requirements and client problems.
Position Requirements:
Qualifications:
• Strong experience with dimensional, logical and physical data modeling experience in developing star schema designs, OLAP cubes, and other metadata concepts
• Able to perform and manage maintenance tasks including security, software installations, configuration updates and troubleshooting environment issues
• Strong analytic, problem solving and collaborative skills
• Experience in requirements gathering and knowledge of standard system development lifecycle concepts
• Experience with structured MSSQL, SQL PL/SQL
• Windows Server 2003/2008 knowledge
• Able to perform detailed documentation of design, development, testing and deployment activities necessary to ensure team knowledge sharing
• DB2 and SQL Server database experience
• Excellent written and communication skills
• Bachelor's Degree and 5+ years of hands on experience with IBM Cognos 8/10, Microsoft SSRS and/or SAP Business Objects as both a developer and administrator
Other Desired Qualifications:
• Experience in Visual Basic, JavaScript, Java and Object Oriented Programming
• Understand and document reporting requirements
• Database experience with one or more of the following: DB2, SQL Server, Oracle or Informix
.