Business Intelligence Developer

Description

Job Summary Responsible for developing business reporting and analysis solutions for business stakeholders. Requires ability to assess and identify processes and procedures to allow departments to acquire and utilize data necessary to manage business operations and evaluate productivity and performance. This position will interact and work extensively within Microsoft Business Intelligence stack including SQL Server, SharePoint and PowerBI. Responsibilities include but are not limited to Analyze and document business reporting requirements and identify the appropriate reporting mechanism that can meet those requirements.Work with the Business Intelligence Architect to design appropriate solutions to ensure that systems can meet stakeholder expectations.Create functional requirements and design documents to ensure business requirements are accurately recorded.Continually strive to improve the efficiency and usability of our BI solutions and other systems by leveraging ongoing research and understanding of business needs.Design and develop dashboards, reports and applications that integrate with other enterprise systems and third party products.Assist other developers, analysts, and designers in conceptualizing and developing business intelligence solutions.Provide expertise and support to end users and other members of the IT support team.Conduct research on emerging development tools and strategies.Work with all levels of business both verbally and in writing to determine business needs and how to address them with business intelligence tools and platforms.Lead the complete software development lifecycle for solutions, including analysis, project management/planning, design, configuring, programming, and testing.Provide expertise and support to business managers and other members of IT to determine how to best implement, support, and use solutions.Work with end users to identify, create, and deliver reports according to requirements.Work with Business Intelligence Architect to create models within the data warehouse and/or changes to existing data stores.Design and manage data warehouse improvement and growth projects.Design, create and manage data cubes.Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.Diagnose and resolve data warehouse access and performance issues.Execute data warehouse configuration and performance tuning.Monitor system details within the data warehouse, including stored procedures, indexes, partitions, query execution time, and implement efficiency improvements.Utilize the SharePoint platform as delivery mechanism for reporting and dashboard development.Work closely with IT Security team to ensure that appropriate measure are being taken to secure information.