The Business Intelligence Software Engineer, known internally as a Report Developer, is responsible for clarifying requirements, building, and maintaining business information reports, primarily using Microsoft SQL Server and Microsoft Reporting Services, and Team Foundation Server. The Report Developer act as a subject matter expert for these technologies and applies them successfully to create accurate, clear, efficient, and sustainable reports.
Responsibilities of the Business Intelligence Software Engineer:
Ensures Health and Safety is the number one goal by following policies, processes, and acting in a safe manner at all times.
Interview business users to clarify requirements, explain limitations of data in the system, and arrive at mutually-agreed upon technical solution.
Design new reports considering accuracy, performance, maintainability, and clarity of presentation.
Comfortable with stopping one task to switch to another higher-priority task and work with urgency and precision to complete the “hot fix” business requirement.
Estimate effort in days/hours to complete tasks and proactively update manager with revisions to original estimate.
Ability to work in a fast-paced team environment using standard tools to facilitate team coordination, ensure source control and to allow for efficient project management.
Work collaboratively within the team and across other .net development teams to determine the best solutions for the desired outcome.
Work with business owners, development team experts, and database administrators to gain and understanding of the business and application rules for the data being reported on.
Document user specifications and reasons for specific logic within a code to enable future maintenance on that report.
Continuously improve professional skills with reporting and database technologies to keep current with industry best practices.
Requirements of the Business Intelligence Software Engineer:
BS/BA in Computer Science or related field preferred, in lieu of degree 5+ years of SQL SSIS reporting experience required.
Required proficiency: Microsoft RS2008RE, SQL, SQL Reporting Services SSRS, SQL Server Integration Services SSIS, Extract Transform Load ETL.
Clear and logical thinking about data and data relationships
Attention to detail and self-testing of code and reports before notifying user that it is ready for them to test.
Excellent communication skills within report development team is essential to success.
Must not hesitate to seek out assistance with SQL coding or data location if solution is unclear.