The Business Intelligence (BI) Developer will use Microsoft SQL Server and related technologies to develop and support reporting and data management solutions for the firm. This developer complies with the principles, standards, and best practices outlined by the firm's data architecture, change management, and release management governing bodies.
The BI Developer will partner with BI Analysts to define and document the business requirements for reporting solutions that meet the needs of financial analysts and other stakeholders. This developer will maintain technical documentation including the update of our report inventory, data dictionary, and technical specifications library.
The BI Developer works under the direction and supervision of a Senior BI Developer.
ESSENTIAL FUNCTIONS / JOB DUTIES:
Under the direction and supervision of a Senior BI Developer, develop and maintain interactive and operational reporting solutions for the enterprise and prepare code for production deployment
Under the direction and supervision of a Senior BI Developer, develop and maintain enhancements to the data warehouse, master data services models, data integration layer, and enterprise data services (stored procedures, views, functions) shared across applications and reporting
Provide evidence for the quality and accuracy of solutions by executing unit and integration test plans and present results to a Senior BI Developer for sign-off
Support intra-day, weekly, monthly and year-end reporting cycles
Comply with the firm's data management principles, policies, standards and best practices as defined by the Data Architecture Working Group
Adhere to all documentation standards, development lifecycle tasks, and status reporting requirements
Bachelor's degree in Computer Science, Information Systems, or related field, or the foreign equivalent
Must have developed and deployed 18 parameterized SSRS reports to production over a 12 month period
Must have developed and deployed 15 code enhancements of reports and/or data integration solutions to production over a 12 month period
5 years of experience with report development and support using Microsoft SQL Server Reporting Services (SSRS) versions 2008 R2 or 2012 including online parameterized reports and scheduled batch subscriptions
5 years of experience with data integration development and support using Microsoft SQL Server Integration Services (SSIS) versions 2008 R2 or 2012 including job scheduling, error trapping, and success / failure notifications
5 years of experience with SQL development and support using Microsoft SQL Server T-SQL versions 2008 R2 or 2012 including stored procedures, database views, functions, and related objects
5 years of experience with Microsoft Visual Studio & BI Development Studio
5 years of experience in the use of Microsoft Visual Source Safe, Team Foundation Services, or similar source code management solutions
3 years of experience troubleshooting existing SQL code to resolve accuracy and performance problems
3 years of experience developing basic report table / database schemas using consistent naming standards and effective use of primary and foreign key constructs
Ropes & Gray